August 26, 2015 at 12:27 pm
I remember we had a comprehensive document to analyse the performance of SQL server 2005 or 2008.
I need one to do a high level analysis of overall performance of SQL Server 2014.
May be with respect to CPU, Memory, IO, Indexes, Database/Instance configuration, Maxdop etc.
I do not want to drill down into any of the above mentioned items at this point in time. I will do that when I feel something isnt right.
August 27, 2015 at 4:20 am
Why not use the same document? There are changes between 2008 and 2014, but by and large the underlying tool set for monitoring is roughly the same (you should use extended events instead of trace) and the issues around database performance are the same. If you already know the counters and things you need to monitor for 2008, monitor those for 2014. At a high level, they're basically identical.
"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