Posts
Sort by recent activity
Using Power BI
Is anyone using Power BI to produce dashboard from SQL Monitor?
Tracking specific error numbers
I'd like to use SQL Monitor to track and alert me when specific SQL errors are generated. At the moment, I'm tracking 833 errors on one of our servers and am using SQL Agent Alerts to email.Does an...
Longest running queries
Is it possible to see the longest running queries per server? The current report only appears to show this for the entire estate.RegardsAndrew
Overviews Alert History
On the Overviews page, the Alert History defaults to 24 Hours. If there anyway to change this and keep the setting? When I change to to say 12 Hours and change pages it always returns to 24 Hours.
SQLCOMPRESSION
Just been running some tests using the SQLCOMPRESSION option on an encrypted databases. From what I can see, it doesn't not compress the backup like a native backup would do in SQL Server 2016.
Is ...
Auditing
Do Redgate have any plans to develop a data auditing tool? I'm looking for something that will audit INSERTS, UPDATE, DELETES and also SELECTS.
SQL Error Log Informational Messages
Every time I restart a secondary server, I get a load of the following alerts from SQL Monitor
Error: 35262, Severity: 17, State: 1.
Skipping the default startup of database 'xxx'' because the data...
Custom Metrics and High Availability Groups
Is it possible to only execute a customer metric on the primary node of an AG?
New deadlock feature
Must say I like the look of the new deadlock feature. Definite improvement on just showing the sql fragment.
Recording Agent Job duration
I'd like to be able to record the duration of some of my SQL Agent Jobs. Was wondering if anyone else had done this in SQL Monitor and how they went about it.
I was thinking of maybe a custom metri...