Post reply

SQL Server Perfmon Counter: Databases

  • September 19, 2008 at 6:46 am

    #198258

    I'm using the perfmon sql server databases counter but when reviewing the results, I see no way to determine which physical database the counter is referring to. There's no DBID or DATABASENAME etc. How do I relate the metrics to a physcial database such as "master" or "msdb" etc?

    Thanks

    Steve

  • September 19, 2008 at 6:58 am

    #874174

    When you set up the counters you can specify which DB it's for, or specify counters for all databases overall.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2008 at 7:08 am

    #874179

    Thanks Gail. I was using the default "databases" counter constructed by SQL Server. Would add the database name by "Control Panel" -> "Performance"->"Log Counters" ?

    Thanks again.

    Steve

  • September 19, 2008 at 9:13 am

    #874303

    Run perfmon and monitor from there. I normally just run it directly from the run dialog or command line.

    For the databases counters you should see something like the attached pic. (I'm running Vista, will look slightly different on older OSs)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply