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 ...

    • Synthetic browser module prerequisite and troubleshooting guide for On-Premise Pollers

      Introduction This document provides a structured troubleshooting guide for resolving issues encountered during the download process of On-Premise Poller for Synthetic (Browser) Module. It covers possible statuses, check-up steps, remedies, and ...

    • 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 ...

    • Understanding latency in data center operations

      Latency, measured in milliseconds (ms), is the time taken for a response to be generated by an application or service. Lower latency results in quicker responses. Latency can occur due to several factors like: Network traffic: High volumes can slow ...

    • Unable to add SQL insight monitor

      If the SQL Insight monitor is not getting added even after entering your credentials, try these troubleshooting steps: Ensure that the Auto-discover applications feature is enabled. If not, you will need to trigger discovery using the Discover ...