Activity overview
Latest activity by sql-lover
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...
How many licenses do we need for BackupPro on a cluster?
Mine is an active/passive Windows cluster running SQL2012. Logic will say I will only one? As MSSQL can only exists on the active node, but the active node can be A or B. Can someone from RedGate c...
I cannot take FULL backup via GUI (Win 2012 Cluster setup)
So... I wanted to be sure this is the correct behaviour.
I installed redGate Backup Pro 8 on a two node Windows Cluster running SQL2012. I followed these instructions: https://documentation.red-gat...
Not able to take DIFF backups via GUI - Backup Pro 7.7.07
I am not able to take DIFF backups via GUI. The Differential backup type is simple grayed out or not available on the GUI. And of course, I've taken FULL backups.
I am running Backup Pro 7.7.07 on ...
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.
Where is SQL Monitor 5.0 ?
The usual link for upgrades that you get on existing configuration (top right corner) has been removed. I went to RedGate website, logged in, clicked on "download latest" and the binaries are for S...
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 ...
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...
How to block or ignore alerts from certain user
I do use Ola Hallengren backup solution on all SQL servers. During the weekend, the jobs run and they take quite a bit to finish; this is normal. But Monday morning, I have tons of alerts due this....
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...