Home Forums SQL Server 2005 Administering Query to calculate CPU usage for one database over period of time RE: Query to calculate CPU usage for one database over period of time

  • PowerShell might not make sense if you'll only ever need to worry about one instance. If it's just peak usage you want then PerfMon is a good choice. With a few clicks you can setup a PerfMon Log with the CPU counters you want and end up with a delimited log file you can analyze. You can then pull that log into Excel and show it as a chart. If you use the DMV method you have to implement all the polling, collecting and scheduling stuff yourself.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato