July 30, 2015 at 9:09 am
Hi,
There is load test activity on our 2012 db. Apart from checking for blocking, high cpu what are the things do I need to capture. Doing this for the first time, any help appreciated
Thanks
July 30, 2015 at 10:01 am
Pretty much the same stuff you'd capture if you were monitoring production servers. You want all the wait statistics. You want to see the queues, if any. You definitely should monitor I/O, that's more important than CPU. If possible, also capture the query metrics using extended events so that you can go back and see the longest running or highest resource queries.
For lots more detail on all this, see the first four chapters of my book on query tuning.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply