Category: Performance Tuning
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.
We have five SQL servers running on different physical servers. What are the downfalls for combining these SQL servers onto a single physical server?
Is it a good idea to run both SQL Server and IIS on the same physical server?
I need help to justify new hardware for our SQL Server.
Will placing the MDF files and the LDF files on two different physical hard drives help performance?
How many indexes can I add to the table before performance degrades?
We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal?
How can I help identify the worst performing queries in my SQL Server database application?
I'm a newbie to SQL Server performance monitoring. With all the information on your website, I don't know where to start.