Posts
Sort by recent activity
SQL monitor causing CPU pressure in Azure SQL Managed Instance
Hi,We are using latest SQL monitor and Managed Instance. SQL monitor repository is on a different single Azure Database. We are seeing SQL Monitor queries causing continuous 100% Cpu load on the in...
Analysis section shows "Loading" indefinitely
Hi,We are using version 9.1.7.23574.We can't get any data out of Analysis:
Using Azure SQL Serverless as data repository
Hi,Installation went without errors and everything seems to work fine. However base monitor event log is showing following error:2019-08-27 13:15:16,694 [31] ERROR RedGate.SqlMonitor.Engine.Monitor...
Can't compare between OnPrem and Azure PAAS databases
Hi,
This error occurs on both 11 and 12 versions. I've managed to compare these databases before but now I'm getting this error during compare:
"Tried to set a permission of type 'None'".
Does SQL ...
Monitoring stopped randomly
Hi,
We are using version 2.3.0.334 and randomly we get monitoring stopped alerts.
They are caused by:
- Incorrect credentials or insufficient permissions SqlException Login failed. The login is f...
Reset unread alerts in SQL monitor 2.3
Hi,
I have undread alerts flood making the application very slow. I would like to flag all current unread alerts as read or if possible do this with some criteria.
Could you provide some script or ...
Alert: Long running query and top 10 expensive queries logic
Hi,
I've done some testing with this alert and the "top 10 expensive queries"
and it seems that it doesn't catch all long running/expensive queries and I was wondering what is the functioning logic...
Script changes only to DML triggers
Hi,
Is this possible by defining filters etc.?
Now I get basically drop/create of whole table first.
BR
Joona
Trace stopping and starting
Hi,
Whenever I enable trace after a while I begin to see following in logs:
SQL Trace stopped. Trace ID = '3'. Login Name = 'SqlMonitor'.
SQL Trace ID 3 was started by login "SqlMonitor".
This seem...