Category: FAQ
Our SQL Server is experiencing lots of blocking, but we don't have any resource bottlenecks.
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?
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?
I am having a problem with table locking that is causing concurrency problems.
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?
We have a started experiencing a performance issue with a table that has now grown to over 600,000 rows.
Is there a way to control which CPU performs what tasks in SQL Server?
Is it normal for the buffer cache size to vary throughout the day?
Do you have a recommendation for the maximum number of databases you can place on a single SQL Server?