Activity overview
Latest activity by gmcquibben
Does SQL prompt scan all of the databases' properties and objects on the server connection or when connecting to an individual database? We are seeing databases coming out of auto-pause due to Red-gate SQL Prompt. / comments
Does SQL prompt scan all of the databases' properties and objects on the server connection or when connecting to an individual database? We are seeing databases coming out of auto-pause due to Red...
Does SQL Prompt scan all the databases on a logical server in Azure SQL Database
Does SQL Prompt scan all the databases when connecting to a logical server used by Azure SQL Database(s)?
What is the best practice for migrating the base monitor and data repository?
I have a link to move the data repository (https://documentation.red-gate.com/sm/maintaining-and-upgrading-sql-monitor/maintaining-sql-monitor/moving-the-sql-monitor-database), but what would be th...
What is the frequency of alert checks per server?
How often is SQL Monitor checking my servers for alerts?
I use the Analytics section the most but the Estate section has become very helpful as we have gone from a small SQL Server footprint of just a handful of servers to over 50+ servers now. / comments
I use the Analytics section the most but the Estate section has become very helpful as we have gone from a small SQL Server footprint of just a handful of servers to over 50+ servers now.
Has there been any resolution to this? I am seeing the same problem with log and Full backups not being reported. / comments
Has there been any resolution to this? I am seeing the same problem with log and Full backups not being reported.
licensing only some of the nodes in a cluster
I have a four node cluster that has a SQL instance on each node. I am only interested in monitoring two of the four node/instances, but the other two instance/nodes are added automatically. Is th...
Alex,
How can you say, that the aggregate is measuring the peaks accurately, when the correct peak should be 389 GB and it is displaying the peak at 111 GB? It is only displaying one-third of the correct peak value.
A Maximum value for a period in time can't change in an aggregation unless you don't include it in the aggregation.
Greg / comments
Alex,
How can you say, that the aggregate is measuring the peaks accurately, when the correct peak should be 389 GB and it is displaying the peak at 111 GB? It is only displaying one-third of the ...
If the chart is aggregating, then how does that explain the large differences in Peak (Maximum) usage? My peak usage is 389 GB in the 12 hour view and 111 GB in the 7 day view. In addition, the graphical representation of 111 GB is proportional to a prior day's peak usage of 380 GB of usage. This looks to be more of a sampling than a true aggregation.[image] / comments
If the chart is aggregating, then how does that explain the large differences in Peak (Maximum) usage? My peak usage is 389 GB in the 12 hour view and 111 GB in the 7 day view. In addition, the g...