Category: Performance Tuning
Can I programatically tell SQL Server how to allocate CPU resources?
For best performance, should we install Analysis Service and the cubes as the same server as the production database?
A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why?
T-SQL code in script run faster than it does as a stored procedure. Why?
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.
Is there a way to configure memory cache or buffers per database?