Category: FAQ
Why doesn't query parellelism use all of the available CPUs?
How can I capture performance data over time, and review it later?
Why is my Memory: pages/sec counter exceeding 20 for my SQL Server?
Are more CPUs better than fewer CPUs for the best performance from SQL Server?
Why do I get error messages when my SQL Server is running under a heavy load.
How do I know if my table has redundant indexes?
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?
DBCC INDEXDEFRAG doesn't seem to work like it should.
At what point should I worry about page splits, and what can I do to help reduce them?