Comments
Sort by recent activity
No updates? / comments
No updates?
I have not enabled tracing on any of my servers.
I guess I will be looking forward to 2.3! / comments
I have not enabled tracing on any of my servers.
I guess I will be looking forward to 2.3!
Apologies, it is [data].[Cluster_SqlServer_Process_UnstableSamples].
SELECT [utils].[Tickstodatetime](min([CollectionDate]))
FROM [RedGateMonitor].[data].[Cluster_SqlServer_Process_UnstableSamples]
returns '2011-02-09 20:26:11.063'.
What should be the oldest data I see in this table? I will implement my own purge policy for the time being.
Additionally, the [Cluster_Machine_Process_UnstableSamples] has a similar issue, though not to the degree of it's SqlServer counterpart. / comments
Apologies, it is [data].[Cluster_SqlServer_Process_UnstableSamples].
SELECT [utils].[Tickstodatetime](min([CollectionDate]))
FROM [RedGateMonitor].[data].[Cluster_SqlServer_Process_UnstableSamples]...
Sigh... apologies again. As in my post (and now my corrected title) the offending table is Cluster_SqlServer_SqlProcess_UnStableSamples, / comments
Sigh... apologies again. As in my post (and now my corrected title) the offending table is Cluster_SqlServer_SqlProcess_UnStableSamples,
SELECT PK.ParentID,
count(*)
FROM [RedGateMonitor].[data].[Cluster_SqlServer_SqlProcess_UnstableSamples] US
JOIN [RedGateMonitor].[data].[Cluster_SqlServer_SqlProcess_Keys] PK ON PK.ID = US.ID
GROUP BY [ParentId]
shows that one server is responsible for 65% of the data. They have all been monitored for the same period (over a month now), so it isn't related to length of history...
This server generally has over 300 active connections during business hours. I am assuming that explains the volume of data logged?
If that is the case, I have to say we are storing too much data for too long for this to be considered as an enterprise solution.
I will have over 300 servers to monitor... / comments
SELECT PK.ParentID,
count(*)
FROM [RedGateMonitor].[data].[Cluster_SqlServer_SqlProcess_UnstableSamples] US
JOIN [RedGateMonitor].[data].[Cluster_SqlServer_SqlProcess_Keys] PK ON PK.ID = US.ID
GR...