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

    • Troubleshooting VMware ESX hardware monitor sensor data

      If your VMware ESX hardware monitor displays inaccurate or outdated sensor data that does not reflect the actual state of the ESX server, follow these steps to refresh the hardware health data: Steps to fix outdated sensor data: Log in to the VMware ...

    • Troubleshooting steps if you don't see any data after installing the PHP agent

      Problem statement: The APM Insight PHP agent has been installed, but no data is displayed in the Site24x7 web client. Troubleshooting steps: Ensure that you have installed both the PHP agent and the S247DataExporter. Check that you have restarted the ...

    • Troubleshooting steps if the data collection stops for a network device

      Case 1: The On-Premise Poller is Down and/or the Network Module is Disabled. Go to Admin > On-Premise Poller. Check if the state of the On-Premise Poller is active. If not, activate it. Check if the status of the On-Premise Poller is up. If it's ...

    • Troubleshooting steps if some widgets do not show data

      Troubleshooting steps if some widgets do not show data In the Network > Device Performance tab or Server-Agentless > Summary tabs, if you're unable to view values for CPU Utilization, Memory Utilization, or Hardware Details and are instead receiving ...

    • Troubleshooting steps for On-Premise Poller

      Prerequisites and basic details: Prerequisites for installing On-Premise Poller Necessary ports to allow access to the installed On-Premise Poller How secure is On-Premise Poller Amount of bandwidth consumed by the On-Premise Poller software Adding ...