SQL Server Performance

Measuring performance down to database level

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by YaHozna, Apr 10, 2011.

  1. YaHozna New Member

    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.
  2. Luis Martin Moderator

    You can find some articles in our forum about measuring.
    But, have you some issue about performance righ now?
  3. satya Moderator

Share This Page