Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Highlighted
Honored Contributor.. Richard Snader Honored Contributor..
Honored Contributor..
272 views

Monitoring MS SQL Servers with SiteScope

We are being asked to monitor MS SQL Server with SiteScope.  One of the things that the SQL Team is used (they were using MS SCOM) is the monitoring knowing dynamically all of the Database names, and being able to show them the status of each individual DB on their SQL Server.  I have not been able to locate a way to do this with SQL Server, and was hoping someone else has found it or written a query that can do that?

 

I have also tried the SiteSQL Solution Template, but that does not do it either.

 

Thanks!

Richard

 

Labels (1)
0 Likes
1 Reply
Established Member.. kenneth.gonzale
Established Member..

Re: Monitoring MS SQL Servers with SiteScope

Hi,

 

SQL monitor monitors by instance not by DB. So you may use DB query monitor: http://msdn.microsoft.com/en-us/library/ms178534.aspx

Kenneth Gonzalez
HP Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.

If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.