locked
Performance counters Database RRS feed

  • Question

  • I am trying to monitor in Windows 7 with SQL Server 2008 R2 one of the performance counters in the section Database, for example the first one Database Cache % Hit as shown in the picture below. Although I click on Ok, the performance counter is not added to the performance monitor. Do you have an idea what could be the problem?Add Counters form
    Friday, December 7, 2012 10:23 AM

Answers

  • How about SQLServer:General Statistics - User Connections

    Counts the number of users currently connected to SQL Server.

    MSSQL$Instance_Name:General Statistics - User Connections


    • Edited by V. Keerthi Deep Friday, December 7, 2012 11:56 AM
    • Proposed as answer by V. Keerthi Deep Friday, December 7, 2012 1:39 PM
    • Marked as answer by pappasa Friday, December 7, 2012 2:31 PM
    Friday, December 7, 2012 11:55 AM

All replies

  • Pappasa, What is the intention behind looking at this counter?

    These counters describe the activity of the Extensible Storage Engine (ESE), a transacted database system that stores all Microsoft® Active Directory® objects, can access a performance object (the Database object) that provides counters to measure the activity of the ESE. This object is not installed by default and needs to be installed using Lodctr.exe in the Platform SDK. Values are only reported for processes that use the ESE. The Database object provides performance statistics for each process using the ESE high performance embedded database management system.

    Friday, December 7, 2012 10:33 AM
  • I would like to monitor the counter "Sessions In Use" in the section Database. I thought Database refers to the SQL Server. If that is not so, how can I monitor the number of sessions on my SQL server?
    Friday, December 7, 2012 11:49 AM
  • How about SQLServer:General Statistics - User Connections

    Counts the number of users currently connected to SQL Server.

    MSSQL$Instance_Name:General Statistics - User Connections


    • Edited by V. Keerthi Deep Friday, December 7, 2012 11:56 AM
    • Proposed as answer by V. Keerthi Deep Friday, December 7, 2012 1:39 PM
    • Marked as answer by pappasa Friday, December 7, 2012 2:31 PM
    Friday, December 7, 2012 11:55 AM
  • Yes, this is what I was searching, thank you.

    • Marked as answer by pappasa Friday, December 7, 2012 2:31 PM
    • Unmarked as answer by pappasa Friday, December 7, 2012 2:31 PM
    Friday, December 7, 2012 1:37 PM