Activity overview
Latest activity by crimdon
Using Power BI
Is anyone using Power BI to produce dashboard from SQL Monitor?
Hi there, Thanks for your reply. I've decided to do it with a custom metric using this scrip: DROP TABLE IF EXISTS #errorLog; CREATE TABLE #errorLog ( LogDate DATETIME, ProcessInfo VARCHAR(64), [Text] VARCHAR(MAX) ); DECLARE @starttime DATETIME = DATEADD(MINUTE, -5, GETDATE()), @now DATETIME = GETDATE() INSERT INTO #errorLog EXEC xp_readerrorlog 0,1,NULL, NULL, @starttime, @now SELECT COUNT(*) FROM #errorLog a WHERE EXISTS ( SELECT * FROM #errorLog b WHERE [Text] LIKE '%I/O requests taking longer than 15 seconds%' AND a.LogDate = b.LogDate AND a.ProcessInfo = b.ProcessInfo ); DROP TABLE IF EXISTS #errorLog; Regards Andrew / comments
Hi there,Thanks for your reply. I've decided to do it with a custom metric using this scrip:DROP TABLE IF EXISTS #errorLog;CREATE TABLE #errorLog( LogDate DATETIME, ProcessInfo VARCHAR(64), ...
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
I'm having this trouble at the moment as well. What I've noticed is that it doesn't appear to pass the correct password to the Base Monitor service when installing the new version. / comments
I'm having this trouble at the moment as well. What I've noticed is that it doesn't appear to pass the correct password to the Base Monitor service when installing the new version.
Hi Don, Thanks for that info. Do you manage to get as good (if not better) compression than using native SQL? / comments
Hi Don,Thanks for that info. Do you manage to get as good (if not better) compression than using native SQL?
Latest test for me with SQL Backup v10 (latest patch) and SQL Server 2016 (latest patch). The database is 30Gb with TDE applied to it. Clearly SQL Backup can't be used with a TDE database if you want to also achieve compression on the backups. [image] / comments
Latest test for me with SQL Backup v10 (latest patch) and SQL Server 2016 (latest patch).The database is 30Gb with TDE applied to it.Clearly SQL Backup can't be used with a TDE database if you want...
I keep looking at this every now and again. The bug I was told by Redgate technical support was with SQL Server rather than SQL Backup. I was wondering if anyone knows if its been fixed yet? / comments
I keep looking at this every now and again. The bug I was told by Redgate technical support was with SQL Server rather than SQL Backup. I was wondering if anyone knows if its been fixed yet?
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.
I see that too. Maybe try adding the Obfuscated Password from the backup job? / comments
I see that too. Maybe try adding the Obfuscated Password from the backup job?