April 8, 2011 at 2:07 am
Hi, 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.
April 8, 2011 at 6:06 am
Use Windows Perfmon.
CPU -% Processor Time - _Total
Process - %Processer Time - SQLServr
MSSQLSERVER - Buffer Manager - Page Life expectency
MSSQLSERVER - Buffer Manager - Buffer cache hit ratio
There are others but these are the core, in my opinion.
April 11, 2011 at 2:30 am
Thanks for the reply, Craig. Unfortunately I need to be able to measure performance down to database level which I don't think PerfMon will do.
Regards,
Gordon.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply