Sorry everyone this SQL server post is going to sneak on here.
We have the redgate sqlmonitoring tool installed (we tried grid/cloud control and it wasn't that good i'm afraid to say) and we just wanted a summary of the instances we are monitoring - to extract this i created the following SQL:
This won't be the start of a lot of SQL server posts......
We have the redgate sqlmonitoring tool installed (we tried grid/cloud control and it wasn't that good i'm afraid to say) and we just wanted a summary of the instances we are monitoring - to extract this i created the following SQL:
SELECT
[Cluster_Name]+'\'+[Cluster_SqlServer_Name],[Cluster_SqlServer_Properties_ProductVersion]
,[Cluster_SqlServer_Properties_ProductLevel],[Cluster_SqlServer_Properties_Edition]
FROM [RedGateMonitor].[data].[Cluster_SqlServer_Properties_StableSamples_View]
This won't be the start of a lot of SQL server posts......
Comments
Post a Comment