Activity overview
Latest activity by patelrk
I got around the problem by creating a step before creating the release script, using the DLM Release 2 widget to copy the production schema over the top of the test database schema. The create the release script, then deploy. That seemed to work. / comments
I got around the problem by creating a step before creating the release script, using the DLM Release 2 widget to copy the production schema over the top of the test database schema. The create the...
Getting Pre-update schema check failed when using the Release widget in VSTS
Hi I'm getting this when i'm trying to release changes from a Perform Create step in VSTS. Is there a way to find out what is actually making it fail in the Pre-auth check? Is there a verbose fla...
Hi Chris
I'm using version 3.1.0.125 for SqlMonitor.
The database version is Sql Server 2008.
Thanks / comments
Hi Chris
I'm using version 3.1.0.125 for SqlMonitor.
The database version is Sql Server 2008.
Thanks
Blocked process alert doesn't always show all the info
When we get blocked process alerts, we noticed that the Processes tab shows incomplete info in the Blocking Process (for instance). The info that's missing is the Blocking process, host and the us...
Custom metric list not refreshing
A minor issue...after creating a new custom metric, you are returned to the list of custome metrics, however, to see your newly created metric, you need to press F5 to refresh the page.
Hi Priya
Thanks for the email for the fix. I will install it soon.
I ran the DBCC SHOWCONTIG WITH TABLERESULTS, FAST and it came up with 6 indexes that were greater than 1000 pages and all had logical fragmentation of 24%-97%
Thanks
Rakesh / comments
Hi Priya
Thanks for the email for the fix. I will install it soon.
I ran the DBCC SHOWCONTIG WITH TABLERESULTS, FAST and it came up with 6 indexes that were greater than 1000 pages and all had log...
Fragmented indexes alert not firing
Hi
With the old SQL Monitor 1, i used to get this alert regularly, which was fine because i knew which indexes they were and would get round to defragging them later at an off-peak time. However, w...
Thanks Chris
I did already have the low and medium alert thresholds disabled so i would never have seen the original sql fragment. That's why i couldn't figure out why the alert wasn't being filtered out.
I can't see this situation happening very frequently so am happy to add blobeater to my regex, but with the lack of sql fragment history as the alert escalates (if you don't have the low and medium level alerts selected), makes diagnosis quite difficult.
For example, in my situation where i have only High selected the alert chain would look a little like:
Alert level High ->
-- network protocol: LPC
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
USE [RedGateMonitor21]
DBCC CHECKDB(N'RedGateMonitor21') WITH NO_INFOMSGS
Alert level Low->
DECLARE @... VARBINARY(8000) SELECT @... = CheckIndex (ROWSET_COLUMN_FACT_BLOB) FROM { IRowset 0x70C6840502000000 } GROUP BY ROWSET_COLUMN_FACT_KEY >> WITH ORDER BY ROWSET_COLUMN_FACT_KEY, ROWSET_COLUMN_SLOT_ID, ROWSET_COLUMN_COMBINED_ID, ROWSET_COLUMN_FACT_BLOB OPTION (ORDER GROUP)
Thanks
Rakesh / comments
Thanks Chris
I did already have the low and medium alert thresholds disabled so i would never have seen the original sql fragment. That's why i couldn't figure out why the alert wasn't being filte...
Hi Chris,
Sorry for the late reply, i've been off for two weeks. It's a Check Database Integrity Task from a maintenance plan / comments
Hi Chris,
Sorry for the late reply, i've been off for two weeks. It's a Check Database Integrity Task from a maintenance plan
Hi Chris
Just checked the SQL Monitor email alerts for this morning and i have started getting the long running backup jobs through again, so yes, BACKUP filtering was filtering. Still getting the CHECKDB ones through even thought that's still specified in the filter.
Thanks
Rakesh / comments
Hi Chris
Just checked the SQL Monitor email alerts for this morning and i have started getting the long running backup jobs through again, so yes, BACKUP filtering was filtering. Still getting the...