cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Microsoft SQL Database Availability

Elena_Masotta
Observer

We want to know the status of each database on the SQL Server. Does anybody know how to get that information? I’m aware of the Microsoft SQL extension, but I’m not interested in all the metrics for each database - I just want to know that it’s up and running. Therefore, we don’t want to install the extension for each database.

2 REPLIES 2

JamesKitson
Dynatrace Guru
Dynatrace Guru

I don't see a simple way of approaching this that doesn't require some form of extension. That information is pretty simple to extract from a query like:

 

select name, state_desc FROM sys.databases

 

 

To collect the states from here: https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-states?view=sql-server-....

 

A custom extension could be developed to make this query and only report just these results. If you don't have the resources to develop this you can engage our platform extensions team to develop it.

 

Also, as a point of clarification in case it is not clear; for the existing SQL Server extension you only need to 'install' the extension once on an ActiveGate. You then need to configure it to connect to each database but you don't need to install it on each DB server itself.

Thanks!

Does that mean, There is a direct tunnel from ActiveGate to Database necessary ?
i.e. Firewall holes et al. ?
i.e. a UserName & password ?
i.e. is that a readONLY user to interrogate by SQL ?
i.e. What's the recommended Frequency of polling ?