Activity overview
Latest activity by franklink
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!
No updates? / comments
No updates?
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...
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,
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]...
Cluster_SqlServer_SqlProcess_UnStableSamples is 57% of DB
Is this normal? I am running 2.2.
There are only 6 servers being monitored right now as this is basically a small scale test. I did not expect this table to have 11.5 million rows with only 6 serve...
An error has occurred. Try refreshing the page: ...
I have this error at the top of all web pages:
An error has occurred. Try refreshing the page: the problem may be temporary. Error details.http://web01/SQLMonitor/static/2.1.0.23 ... esponse.js: 23...
Compression on monitor DB
My DB host for SQL Monitor is a 2008 R2 box. I know from my testing this DB can grow quite large. I would like to enable compression on the larger tables.
Does anyone have any experience/know of an...