Latest SQL Server DBA Performance Tuning FAQ's

Site sponsored by:

Try Idera’s new SQL admin toolset

Home

Articles

Forums

Tips

FAQ's

Blogs

Software

Books

About Us

RSS Feeds

FAQ Topics

All FAQ's

General DBA

General Developer

DBA Performance Tuning

Developer Performance Tuning

Clustering

Error Messages

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest Articles

Slowly Changing Dimensions in SQL Server 2005

Audit Data Modifications

SQL Server 2008’s Management Data Warehouse

Same Report but Different Methods in SQL Server Reporting Services ...

	Microsoft SQL Sever management Studio: Failed to open connection dialog.
	Experiencing a major performance loss with an Indexed view that is using a INDEX SCAN on a table inspite of relevant clustered indexes on the joined tables?
	How to set up database diagram in SQL Server Management Studio Express?
	SQL Server Memory Usage Grows and Not Shrinks
	How to disable database mirroring for a particular database?
	SQL Server Management Studio takes a long time to load, how to improve the load performance of this tool?
	When using SQL Server Management Studio Express I get the error "SQL Server does not allow remote connections". How to resolve this error?
	Which edition of SQL Server 2005 is better, the Standard Edition or the Enterprise Edition?
	Performance delay when a full-text query is executed on a SQL Server with no connection to Internet.
	Managing SQL Server 2005 Express installation & FAQ.
	My manager has asked me to put together a plan for a backup server for our production server running SQL Server. Should I use log shipping or clustering?
	Can you tell me more about the processor queue length?
	Is there any way to allocate processor utilization to SQL Server jobs?
	Is it better to have one large server running multiple databases, or several smaller servers running one database each?
	Is there any benefit for me in turning on the "lightweight pooling" SQL Server configuration option?
	Is there a practical limit to the size of a table I can pin into memory?
	Why isn't my SQL Server taking full advantage of all the RAM I have available in my server?
	We have recently added a second processor to our SQL Server box. How can I configure it to take advantage of the new processor?
	In Performance Monitor, there is an object called Network Interface. What does it mean and under what circumstances would you use it?
	Our SQL Server is experiencing lots of blocking, but we don't have any resource bottlenecks.
	We have a growing population of Access users. My question is whether there is a way of lowering these user's priorities on our SQL Server?
	Is it recommended to install SQL Server on a Windows domain controller?
	My question is how do I move already existing log files in a different drive, or how can I separate data files and log files into different drives?
	I am having a problem with table locking that is causing concurrency problems.
	Why is it better to use RAID 1 for the operating system, SQL Server binaries, and the swap file? What advantages does RAID 1 have over RAID 5?
	In the past couple of weeks, my SQL Server seems to be running slower. Queries just don't seem to run as fast. What should I do?
	Will placing the MDF files and the LDF files on two different physical hard drives help performance?
	I need help to justify new hardware for our SQL Server.
	Is it a good idea to run both SQL Server and IIS on the same physical server?
	We have five SQL servers running on different physical servers. What are the downfalls for combining these SQL servers onto a single physical server?
	When I run a stored procedure in Query Analyzer, it runs in about two minutes. But if I execute the same stored procedure as a job, it runs several hours.
	Do you have a recommendation for the maximum number of databases you can place on a single SQL Server?
	Is it normal for the buffer cache size to vary throughout the day?
	Is there a way to control which CPU performs what tasks in SQL Server?
	We have a started experiencing a performance issue with a table that has now grown to over 600,000 rows.
	Should I schedule the indexes in my SQL Server databases to be rebuilt before or after the statistics on my tables are updated (or does it matter)?
	We have had some performance problems with a server that is running Terminal Services, SQL Server, and Access databases.
	How can I help identify the worst performing queries in my SQL Server database application?
	We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal?
	How many indexes can I add to the table before performance degrades?
	T-SQL code in script run faster than it does as a stored procedure. Why?
	A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why?
	For best performance, should we install Analysis Service and the cubes as the same server as the production database?
	Can I programatically tell SQL Server how to allocate CPU resources?
	When should primary keys be used?
	Our query used to take 30 seconds, and now it takes over 30 minutes. Why?
	When I upgraded by database to the newest version, performance is now much slower. Why?
	We have two stored procedures taking five minutes to run in our development database, but the same stored procedures run quickly on our QA database. Why?
	Is there any option to release the additional memory that has been used by SQL Server after a query is completed?
	Is there a way to configure memory cache or buffers per database?
	I'm a newbie to SQL Server performance monitoring. With all the information on your website, I don't know where to start.
	I am hoping that you may be able to assist me in evaluating the needs of our school district that is purchasing a software package that uses SQL Server as the backend database.
	We run an ERP program that uses SQL Server as the backend database. Does how the ERP program is designed and written affect its performance with SQL Server?
	What are the pros and cons of running more than one instance of SQL Server on a single physical server?
	What is the difference between a table and index scan in an execution plan?
	Why does the performance of some queries vary so widely?
	Why doesn't query parellelism use all of the available CPUs?
	What is the difference between SQL Server 2000 standard and enterprise editions?
	Should I use CPU or elapsed time to measure query performance?
	How can I determine if a table is pinned in SQL Server memory or not?
	The tempdb database grows so large I run out of disk space. What can I do?
	How can I capture performance data over time, and review it later?
	At what point should I worry about page splits, and what can I do to help reduce them?
	DBCC INDEXDEFRAG doesn't seem to work like it should.
	Each night we have to run a job that takes about 10 hours to complete. As it runs, it uses 100% of the CPU. What can I do?
	How do I know if my table has redundant indexes?
	Why do I get error messages when my SQL Server is running under a heavy load.
	Are more CPUs better than fewer CPUs for the best performance from SQL Server?
	Why is my Memory: pages/sec counter exceeding 20 for my SQL Server?
	Does running the SQL Server Index Wizard or the Database Engine Tuning Advisor find all of the tables in my database that need indexing?
	My SQL Server seems to take memory from the operating system, but never releases it. Is this normal?
	Is it possible to keep the entire database in memory?
	What is the difference between DELETE and TRUNCATE? Is one faster than the other?
	What happens during the rebuild of a clustered index?
	What happens when SQL Server executes a stored procedure or query ?
	Why can it take so long to drop a clustered index?