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

      Data collection issues could be due to any of the following reasons: The On-Premise Poller is Down. The Network Module is Disabled. The Network Module is Down or Initializing. The device hasn't been recently polled. Unable to fetch proper ...

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

    • Troubleshooting tips for log collection errors

      The following is a list of possible log collection errors and the solutions to fix them: Error message Reason Solution Upload Limit Reached You might have reached the maximum upload limit configured for this log type in the current billing cycle. ...