Monitor does not collect SQL statistics
andomar
Posts: 17
For our cluster of two nodes, Red Gate monitor collects machine statistics:
However, it does not collects SQL Server statistics:
We have done all connection checks suggested in this document:
http://www.red-gate.com/supportcenter/C ... QL_Monitor\help\2.3\SM_Testing_data_collection.htm&p=SQL%20Monitor
Any suggestions for further troubleshooting would be appreciated.
However, it does not collects SQL Server statistics:
We have done all connection checks suggested in this document:
http://www.red-gate.com/supportcenter/C ... QL_Monitor\help\2.3\SM_Testing_data_collection.htm&p=SQL%20Monitor
Any suggestions for further troubleshooting would be appreciated.
Comments
In the first screenshot, you are being shown the machine names of two nodes in a clutser, and in the second, it's trying to show SQL instance names. Are there names instances of SQL on nl-sql1-cluster.nl.tiscali.com?
If so the problem seems to be more related to a failure to get the list of servers than a failure to collect performance counter data.
There really isn't enough information to reach any useful conclusion, though. I'll send you an email and request your SQL Monitor Base Monitor log files.
*edit* It may be that the SQL Counters need rebuilding, but hopefully that information will be in the log.
Thanks for your reply,
Andomar
\\nl-acsdb.nl.tiscali.com\HKEY_LOCAL_MACHINE returns Windows error 5 (access is denied.)
You may want to do the regedit test as described here: http://www.red-gate.com/supportcenter/C ... %20Monitor
The error line you're referring to is for the NL-ACSDB database. We added that as a test but it's not fully configured yet. The issue is with the NL-SQL1 cluster.
Can you see from the logs why we are not receiving SQL statistics for the NL-SQL1 cluster?
Kind regards,
Andomar
Because according to the docs, you add one of the cluster nodes to the server list rather than the SQL cluster name. Could that be the problem?
Here's a screenshot of the config:
[/img]
When we add `nl-sql1`, it automatically expand the 2 nodes. We have three license keys installed.
http://blogs.msdn.com/b/john_daskalakis ... 93110.aspx
(Note, not a Red Gate article so we don't take any responsibility)
Our administrator checked on the server, and the SQL performance counters are available. Here, we've added Batch Requests/sec to perfmon:
We requested a counter on the Sql Monitor server, and that also worked.
Are we correct in concluding that the perfmon counters are present on the server?
-Andomar
In the first screenshot I think you don't see any nodes because these particular counters come from the shared cluster address and not the individual nodes.
-Andomar[/img]
Does this confirm your suspicion? If so, would you have a suggestion on how to fix it?
Our client applications do connect successfully to the cluster IP.
I'll go back to the log files tomorrow-- we removed the server that was incorrectly set up, perhaps this one will now stand out.
Wondering if you can query WMI from the SQL Monitor server and see if you get the instance names back.
On the SQL Monitor base repository computer:
The query without where and with *:
We're hoping you can provide us with a hint on what the issue and possible solutions are.
P.S. Would you know what error codes 6 and 1726 mean? From earlier in the log.
The screenshot was for the server that runs SQL Monitor-- no surprise that it didn't find a SQL Server service. We've now queried the cluster and cluster nodes. I'll continue the conversation by mailing support@red-gate.com, which is a bit easier than forum posts!
-Andomar