Comments
Sort by recent activity
So ...
On an active / passive 2008R2 Windows Cluster, RedGate 7 ... do we have to change registry settings on both nodes or just the active one?
I actually went to the passive one (the one who does not own the SAN) and while I can see the registry keys, everything is empty there.
Any ideas?
I am not a big fan or messing around with registry, especially on a Win Cluster, so I did not alter the passive node.
Thanks, / comments
So ...
On an active / passive 2008R2 Windows Cluster, RedGate 7 ... do we have to change registry settings on both nodes or just the active one?
I actually went to the passive one (the one who do...
petey wrote:
SQL Backup works on a per-server license. This means you can have 10 instances running on the same physical server, and you would still need only 1 license. However, if the 10 instances were running on 10 different virtual servers on the same box, you would need 10 licenses.
For your cluster, you would need 2 licenses, one for each node, not withstanding the fact that only 1 SQL Backup service will be active at any point in time. However, if you have 2 or more clusters running on the same cluster node, you would still need only 1 license on that node.
Thanks Peter.
I actually clarified this with sales this morning. But appreciate your response. / comments
petey wrote:
SQL Backup works on a per-server license. This means you can have 10 instances running on the same physical server, and you would still need only 1 license. However, if the 10 ins...
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 ...