Comments
Sort by recent activity
Thanks.
I just upgraded to 5.01 yesterday. So far, no problems for me. / comments
Thanks.
I just upgraded to 5.01 yesterday. So far, no problems for me.
rpriesing wrote:
Has there been any work done on improving the performance of the RedGateMonitor Database? We are running on Windows server 2012, SQL 2014 and have 81 servers being monitored, the database has grown to 600GB with 5 tables being the bulk of that space. Regular Index Maintenance takes over a day to complete for the whole database. Anyone do any partitioning of the larger tables (Cluster_SqlServer_Database_Performance_UnstableSamples, Cluster_Machine_Process_UnstableSamples, Cluster_SqlServer_Database_Storage_UnstableSamples, Cluster_SqlServer_Database_File_UnstableSamples, Cluster_SqlServer_TopQueries_UnstableSamples) to help with performance and data purging? Any other tricks to speed up access and overall performance?
I do have a similar issue, and it's just 4 servers. However, I found that for SQL maintenance itself, including RedGate monitor database, Ola Hallengren solution is the best. Look for it online.
It's free. But really powerful too. It skips tables based on amount of pages and fragmentation. That can speed up the maintenance job a bit. / comments
rpriesing wrote:
Has there been any work done on improving the performance of the RedGateMonitor Database? We are running on Windows server 2012, SQL 2014 and have 81 servers being monitored, t...
SomeOnenew2014 wrote:
Hi,,,
We are three DBAs that use SQL monitor software. How can add new administrator to it. I checked configuration >> manage user role but no luck
any ideas??
As far as I know, you can't, which surprises me and should be improved later, IMO. You all need to share "Administrator", which is the account with higher privileges.
If you are the lead DBA, you can give them the lower role, which is Standard User Role. They will be able to read and close alerts, but won't be able to alter major configurations on the RedGate setup. / comments
SomeOnenew2014 wrote:
Hi,,,
We are three DBAs that use SQL monitor software. How can add new administrator to it. I checked configuration >> manage user role but no luck
any ideas??
As far as ...
chriskelly wrote:
I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the _TotalBytes values in the tables you have quoted.
Thanks Chris,
Let me take a look ... / comments
chriskelly wrote:
I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the...
Evan Moss wrote:
Are the names showing properly through the LogicalDisk counter in PerfMon? It would be best if you could test PerfMon remotely as detailed in this article: http://documentation.red-gate.com/pages ... d=17270677
Thanks,
Evan
Do I have to check this on the target or monitored server or on the server that hosts the monitoring system? / comments
Evan Moss wrote:
Are the names showing properly through the LogicalDisk counter in PerfMon? It would be best if you could test PerfMon remotely as detailed in this article: http://documentation...
Evan Moss wrote:
We have seen this happen in other cases where third party tools have affected the naming in PerfMon.
Thanks,
Evan
Hi Evan,
What does that mean? My MS-SQL servers are dedicated boxes. And I have two of my servers, which are identical, without that problem.
Everything started after my SAN admin and I added two new volumes, which I made mount points. It seems like after that, RedGate can't recognize any of those new names.
I've stopped the RedGate monitoring service without any luck. I even put the MS-SQL box on maintenance mode and re-add but it did not refresh those names. I even upgraded to 4.0 this morning ... still no luck ... / comments
Evan Moss wrote:
We have seen this happen in other cases where third party tools have affected the naming in PerfMon.
Thanks,
Evan
Hi Evan,
What does that mean? My MS-SQL servers are dedicat...
Make a job of this ... SELECT
--virtual file latency
ReadLatency = CASE WHEN num_of_reads = 0
THEN 0 ELSE (io_stall_read_ms / num_of_reads) END,
WriteLatency = CASE WHEN num_of_writes = 0
THEN 0 ELSE (io_stall_write_ms / num_of_writes) END,
Latency = CASE WHEN (num_of_reads = 0 AND num_of_writes = 0)
THEN 0 ELSE (io_stall / (num_of_reads + num_of_writes)) END,
--avg bytes per IOP
AvgBPerRead = CASE WHEN num_of_reads = 0
THEN 0 ELSE (num_of_bytes_read / num_of_reads) END,
AvgBPerWrite = CASE WHEN io_stall_write_ms = 0
THEN 0 ELSE (num_of_bytes_written / num_of_writes) END,
AvgBPerTransfer = CASE WHEN (num_of_reads = 0 AND num_of_writes = 0)
THEN 0 ELSE ((num_of_bytes_read + num_of_bytes_written) /
(num_of_reads + num_of_writes)) END,
LEFT (mf.physical_name, 2) AS Drive,
DB_NAME (vfs.database_id) AS DB,
--vfs.*,
mf.physical_name
FROM sys.dm_io_virtual_file_stats (NULL,NULL) AS vfs
JOIN sys.master_files AS mf
ON vfs.database_id = mf.database_id
AND vfs.file_id = mf.file_id
--WHERE vfs.file_id = 2 -- log files
WHERE (io_stall / (num_of_reads + num_of_writes)) >20
ORDER BY Latency DESC
--ORDER BY ReadLatency DESC, Drive;
GO
Save on a table and aggregate the read column (or write). Make the job to send you an alert based on that.
Good luck! / comments
Make a job of this ...SELECT
--virtual file latency
ReadLatency = CASE WHEN num_of_reads = 0
THEN 0 ELSE (io_stall_read_ms / num_of_reads) END,
WriteLatency = CASE WHEN...
Can someone point me to the step by step process (or link) that explains how to upgrade on a Windows 2008R2 two node cluster?
On a standalone instance, it's pretty straight forward, but I'm afraid that's not the same (or should not) when RedGate runs on a two node Cluster.
Thanks in advance, / comments
Can someone point me to the step by step process (or link) that explains how to upgrade on a Windows 2008R2 two node cluster?
On a standalone instance, it's pretty straight forward, but I'm afraid ...
Sorry for my late reply.
I wanted to confirm I used UNC path. And appreciate the answer and follow up. Hope my thread helps someone in the future.
Thanks again! / comments
Sorry for my late reply.
I wanted to confirm I used UNC path. And appreciate the answer and follow up. Hope my thread helps someone in the future.
Thanks again!
lnielsen wrote:
I've got RedGate set to monitor 3 DBs and the actual RedGateMonitor database size right now is around 8GB and the log is around 1.5GB. This is will a full backup setup nightly.
Currently the RedGateMonitor DB has 24MB free space and the autogrowth is set for 5% and the log at 10%.
Now, I've only been running this thing since 1/3/2013 (17 days) so I have two main questions.
1) What should the autogrowth be set at for the RedGateMonitor database/log file
2) Does this size seem excessing? Any recommendations.
I'm just using the out of the box alerts with SMTP setup. One thing I have noticed is the tool is SLOW. It's the only thing running and has 6GB memory all to itself. [image]
Never set auto-growth on any database to a percentage, use MB and fix values instead. It creates fragmentation and makes the queries slow!
I suggest to keep an eye for a week or so, and put a fix MB value. I usually leave 20% available free space, above whatever it needs, so it will have space to growth without increasing the actual file, avoiding fragmentation.
How much should be? Like the RedGate engineering said, difficult to say. Just keep an eye on it. / comments
lnielsen wrote:
I've got RedGate set to monitor 3 DBs and the actual RedGateMonitor database size right now is around 8GB and the log is around 1.5GB. This is will a full backup setup nightly.
C...