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

  • Orlando Colamatteo (11/28/2015)


    Monitoring multiple instances implies you need something that can reach out over a network and compile and display results from multiple servers. PowerShell is a good choice for something like that. I would use WMI to monitor CPU but if those DMVs work for you go for it.

    I just need to monitor one instance, with regards to the DMVs they work on my server but on client server gives division by zero error although we are both the same SQL version(2012)