locked
cannot see sql server 2008 instance databases in performance monitor RRS feed

  • Question

  •  

     

    im trying to measure the amount of CPU used in a backup and restore, using the SQL Server Databases: Backup Restore counter in Perfmon.

    I can select The counter, but it does not let me select an instance database  to monitor.

     

    see image:

     

     


    I have 3 instances on my machine, 2 sql 2005 and 1 sql 2008. why do these instances not appear? i dont know how to set up this monitoring.

     

     

    if i type LOCALHOST or 127.0.0.1 in the "Select  counters from computer" text box i can see all databases under my sql 2005 instances, but not the ones under the 2008 instances. I have disabled all sql server 2005 services and can confirm none of the sql 2008 instance databases are showing up.

     

    this is a huge problem, especially for when i start stress testing sql server 2008 in preperation for upgrading.

     

    anyone any ideas on why i cannot see sql server 2008 instances in perfmon? I have tried from a remote pc also with the same results.

    Wednesday, April 9, 2008 3:23 PM

Answers

  • reinstalled sql server and all works fine now.

     

    Wednesday, April 9, 2008 4:19 PM

All replies

  • reinstalled sql server and all works fine now.

     

    Wednesday, April 9, 2008 4:19 PM
  • Great!! Such a scary solution :P

    J.A


    Sunday, September 1, 2013 10:15 AM