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.