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:
-
Open the server machine in which the issue is occurring
-
Start -> Run and then type perfmon (to open Windows Performance Monitor)
-
In the perfmon window, (in the left pane) expand "Monitoring tools" under Performance.
-
After expanding "Monitoring tools", click on "Performance Monitor" under it.
-
Now in the right pane, click on the big green plus ( "+" ) icon (fourth from left) above the graph.
-
A new window containing the counters will appear. It will contain information like Processor, Processor information etc.
-
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
|
|
|
For Named instances
|
|
Related Help Documentation:
Related Articles
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 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 ...What should I do if Service Health data collection in Microsoft 365 monitor is not happening?
Your Microsoft 365 monitor's Service Health data collection may have stopped because of the recently updated Microsoft 365 Service Communications API policy. Follow the steps below if Service Health data collection in your Microsoft 365 monitor is ...Troubleshooting steps if no data is seen/available for a Windows server monitor
As we use WMI queries to fetch data for a Windows server monitor, please check if the related counters are working properly. Please follow the steps below: Open the server machine in which the issue is occurring. Check if the WMI repository is ...