Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?

TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Feb 15 2011
Filed under: Filed under: sql server, best practices, storage, system, tempdb, tsql, extent, benchmarking, performance monitoring, contention, dmvs
SQL Server Perf: What is the optimal disk or data file placement configuration layout for better performance?

SQL Server manages when and how disk I/O is performed, but the Windows operating system performs the underlying I/O operations. The I/O subsystem includes the system bus, disk controller cards, disks, tape drives, CD-ROM drive, and many other I/O devices...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 29 2010
Filed under: Filed under: sql server, dba, disk, best practices, storage, tempdb, cpu, raid, benchmarking, core, alignment
SQL Server infrastructure considerations - build effective storage solutions

Best storage placement will provide a solution to obtain optimum performance on a single-instance and/or multiple instances, so w hen we talk about Storage Solutions then SAN comes into mind. Having the storage cost as cheaper it is very easy to obtain...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 6 2010
Filed under: Filed under: application, sql server, performance, storage, hardware, oltp, virtual server, vm
SQL Server: What is the internal representation of all the datatypes?

That is the question from SSP forums asking about the internal representation of data types in SQL Server. Here is further explanation for that questions where I picked up new information too. Back to the basics, that all the data that needs to be stored...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 16 2010
Filed under: Filed under: sql server, query, storage, varchar, column, char, format, number, data types, numeric, precision, integer
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 28 2009
Filed under: Filed under: sql server, best practices, multiple, table, storage, tempdb, create, files, performance monitoring
Free Microsoft Press eBook offer - Introducing SQL Server 2008

Here is the interesting and fantastic news for the SQL Server users, Microsoft Press is offering eBook about "Introducing Microsoft SQL Server 2008" by Industry Experts & SQL Server MVPs - Greg Low, Peter DeBetta & Mark Whitehorn. *...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 1 2009
Filed under: Filed under: sql server, performance, mvp, download, storage, ebook, high avialability, busiiness intelligence, windows live, programmability, offer
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance!

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 13 2009
Filed under: Filed under: sql server, best practices, multiple, storage, tempdb, create, files, performance monitoring
SQL Server 2000 and SQL Server 2005 support for mounted volumes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications SQL Server 2000 and SQL Server 2005 support...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 5 2007
Filed under: Filed under: sql server, kba, standard, 2000, storage, clustering, 2005, mounted, volume
Dynamic formatting within the reports using TSQL?

I felt this is more about SQL Storage engine related blog, but there is blend of TSQL involved in tasking the dynamic reporting within the Reporting Services. Here it goes, the task is to change/highlight the color of a row, based on its value. Therefore...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Oct 3 2007
Filed under: Filed under: sql server, report builder, storage, reporting services, tsql, results, iif
Determining the required capacity of an I/O subsystem before deploying the database

It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 17 2007
Filed under: Filed under: sql server, performance, microsoft, security, i/o, storage, throughput, vendor
VMware Enterprise Desktop Seminar Series - Storage and Capacity

VMware Enterprise Desktop Seminar Series. Register now . Built on an enterprise-proven platform running in 100 of the Fortune 100, VMware desktop virtualization solutions transform how organizations deploy and manage their PCs. Attend a live seminar to...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 10 2007
Filed under: Filed under: sql server, seminar, storage, virtual server, server consolidation, vmware
FAN - File Area Networks

Gain control over the growing amount of file data in your enterprise. Learn how File Area Networks (FANs) can help you centralize file consolidation, migration, replication, and failover. Download this eBook and start streamlining your file management...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sat, Sep 1 2007
Filed under: Filed under: sql server, windows, disaster recovery, storage, disks, fan
FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server"

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 28 2007
Filed under: Filed under: sql server, backup, database, kba, storage
SQL Server 2005 Design Considerations for Migration

Scalability is a major concern when preparing your SQL Server 2005 migration. With database growth, in size and number, common challenges revolve around meeting performance requirements and being able to complete business processes in time. Attend this...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 28 2007
Filed under: Filed under: sql server, databases, webcast, storage, growth

Page 1 of 1 (14 items)

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.