Category: FAQ
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?
We have had some performance problems with a server that is running Terminal Services, SQL Server, and Access databases.
Should I schedule the indexes in my SQL Server databases to be rebuilt before or after the statistics on my tables are updated (or does it matter)?
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?
Is there any option to release the additional memory that has been used by SQL Server after a query is completed?