Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Monday, September 4, 2017

Slow queries during busy times

SQLServerCentral » Latest topics
Slow queries during busy times
We have a SQL 2008 Enterprise Edition server with 32 GB of memory and 16 CPU.
During quiet times of the day, queries will complete in 1 - 2 seconds. I have optimized these queries and added proper indexing (they used to run much longer).
But as so

No comments: