Category: Performance Tuning
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?
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.