Author: jwokelly
Our query used to take 30 seconds, and now it takes over 30 minutes. Why?
When I upgraded by database to the newest version, performance is now much slower. Why?
We have two stored procedures taking five minutes to run in our development database, but the same stored procedures run quickly on our QA database. Why?
Is there any option to release the additional memory that has been used by SQL Server after a query is completed?
Is there a way to configure memory cache or buffers per database?
I'm a newbie to SQL Server performance monitoring. With all the information on your website, I don't know where to start.
I am hoping that you may be able to assist me in evaluating the needs of our school district that is purchasing a software package that uses SQL Server as the backend database.
We run an ERP program that uses SQL Server as the backend database. Does how the ERP program is designed and written affect its performance with SQL Server?
What are the pros and cons of running more than one instance of SQL Server on a single physical server?