I just want to note a briefly concept about Wait Stats
Your SQL Server is online, but it’s incredibly slow. The old way to investigate this was to use SQL Server Perfmon counters, but the new way is to ask SQL Server what the bottleneck is.
Refer: http://www.brentozar.com/responder/triage-wait-stats-in-sql-server/
Wait Stats in SQL Server
0 comments:
Post a Comment