Comments
Sort by recent activity
Hi Brian,
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 / comments
Hi Brian,
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 convers...
Running with "WHERE Name Like 'MSSQL%'" gives no results. Running query without the Where clause shows there are no results containing MSSQL: [image] / comments
Running with "WHERE Name Like 'MSSQL%'" gives no results. Running query without the Where clause shows there are no results containing MSSQL:
Looks like the instances are not there: [image]
The query without where and with *: [image]
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. / comments
Looks like the instances are not there:
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 ...
Looks like that's set correctly: [image]
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. / comments
Looks like that's set correctly:
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.
Here's a screenshot when I select the cluster: [image]
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. / comments
Here's a screenshot when I select the cluster:
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...
Here's a screenshot of Global Overview: [image]
-Andomar[/img] / comments
Here's a screenshot of Global Overview:
-Andomar[/img]
Hi Brian,
Our administrator checked on the server, and the SQL performance counters are available. Here, we've added Batch Requests/sec to perfmon: [image]
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 / comments
Hi Brian,
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...
Yeah, for SQL counters, there are no nodes shown. For Windows counters there are. That's basically the problem.
Here's a screenshot of the config: [image] [/img]
When we add `nl-sql1`, it automatically expand the 2 nodes. We have three license keys installed. / comments
Yeah, for SQL counters, there are no nodes shown. For Windows counters there are. That's basically the problem.
Here's a screenshot of the config:[/img]
When we add `nl-sql1`, it automatically exp...
Hi, thanks for the reply. I have not received your email.
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 / comments
Hi, thanks for the reply. I have not received your email.
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 wi...
Hi, I've mailed in the logs yesterday. Have you received the logs, and if so, do they show anything useful?
Thanks for your reply,
Andomar / comments
Hi, I've mailed in the logs yesterday. Have you received the logs, and if so, do they show anything useful?
Thanks for your reply,
Andomar