No data for SQL

Troubleshooting steps when no data is received from the SQL server

As we use "Perfmon" to fetch data for Microsoft SQL monitoring, please check if the counters related to SQL are present in the user's perfmon. Please follow the steps below: 
  1. Open the server machine in which the issue is occurring

  2. Start -> Run and then type perfmon (to open Windows Performance Monitor)

  3. In the perfmon window, (in the left pane) expand "Monitoring tools" under Performance.

  4. After expanding "Monitoring tools", click on "Performance Monitor" under it.

  5. Now in the right pane, click on the big green plus ( "+" ) icon (fourth from left) above the graph.


  6. A new window containing the counters will appear. It will contain information like Processor, Processor information etc.


  7. Scroll that list box and check if the following counters are present. If the counters are not available, please reload the relevant SQL counters.
    Eg:
For Default Instances


  • SQL Server:Locks

  • SQLServer:Databases

  • SQLAgent:Jobs


For Named instances


  • MSSQL$<instance name>:Locks

  • MSSQL$<instance name>:Databases

  • SQLAgent$<instance name>:Jobs




Related Help Documentation:



    • Related Articles

    • No data for service and process in Windows server monitor

      If you see "No Data" for process and service metrics (such as CPU or memory usage of monitored services) in the Site24x7 Windows server monitor user interface, follow the troubleshooting steps below. Run PowerShell Commands Open PowerShell as ...

    • Site24x7 Real User Monitoring (RUM) - Data Collection

      When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...

    • Where are Site24x7's physical data storage regions located?

      Site24x7's integrated data centers are located in the US, European Union, India, China, Australia, and Japan. All Site24x7 customer-related data are stored in these physical storage regions. Data Center Primary Data Center Disaster Recovery Data ...

    • Troubleshooting false positive alerts in monitoring

      Problem False positive alerts are being generated. Possible cause The monitoring system is down in some locations. The Website monitor might be configured for one location, such as Seattle, but may appear down when accessed from another location, ...

    • Why is my website response time too high from China?

      If your website is hosted outside China and you have chosen China as the location for monitoring, then the website response time will be high. This is because of the Great Firewall policy followed by China wherein, all the data coming from outside ...