Activity overview
Latest activity by bullpuppy
This is my first time using this SQL Monitoring tool. It looks very good and we are looking forward to migrating from SCOM to this tool.
These questions may be something for another forum, and I would be grateful for the proper posting.
I love to get a data dictionary of the schema so we do some additional intelligent pattern checking and trending. There is one question that my colleagues have asked the support group but the answer was that it is not possible to make this change. We have clusters with usually 20 instances. All SQL Monitor names for specific SQL Server in a cluster are in the format Custer Name Instance name. This is quite good unless when the actually instance is known to the network, applications and the users as different name. We have this case quite often. When we receive an alert then we have no idea what the network name of the SQL server is until we get into the Alert. When we add a Clustered SQL server instance to SQL Monitor that has a different network name we add it with the name known to the networkinstance name, not the clusterinstance name. SQL Monitor monitors it fine except it alerts using the cluster instance name. I am sure that the network name we used to add the server SQL Monitor is in a table somewhere. I may be able to query out some info to make the Alert more friendly.
Thanks / comments
This is my first time using this SQL Monitoring tool. It looks very good and we are looking forward to migrating from SCOM to this tool.
These questions may be something for another forum, and I wo...