Measuring performance down to database level | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Measuring performance down to database levelHi, wondered if I could get some advice on measuring and interpreting cpu and memory usage? I’ve been tasked with gathering cpu and memory usage for a specific set of databases over a 4-week period in order to get an idea of the load on those databases prior to them being migrated to a new SQL Server. I’ve looked at a number of system tables and DMVs and have come to the conclusion that sysprocesses is probably my best best and the plan is simply to gather stats at regular intervals over the next 4 weeks. However I’m not sure how to interpret the results at the end of the test period. Isn’t it the case that cpu and memory figures are cumulative for a particular spid so it’s not just a case of totalling up all the figures and I’d need to do some work in terms of querying the results. Or is there a Dynamic Data View that would give me more informative results? Those I’ve looked at so far seem to be very specific about the kind of information being returned. Regards, Gordon.
You can find some articles in our forum about measuring.
But, have you some issue about performance righ now?
Why not simply download the performance dashboard reports which will get you report details in this regard, see http://www.microsoft.com/downloads/en/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc for more information.