Activity overview
Latest activity by DBdave
Stop notification
How can stop this Long Query Notification notification!!!
Process ID: 62
Process name: Microsoft SQL Server Management Studio
Database: XXXXXX
Host: XXXXXXXXX
User: XXXXXXX
Process login time: 15 A...
Restarting the web and base monitor services seemed to have resolved the issue. / comments
Restarting the web and base monitor services seemed to have resolved the issue.
Long Running Queries no longer being captured.
Now id like to believe there were no long running queries on the DB but I know this not true, I just ran one that took almost a minute
For the past 3 days now, NO long running queries are being ca...
Long running queries - stored procedures
If a sproc is captured as a long running query the parameters used to execute the stored procedure are not captured which makes it harder to analyse the issue and makes the alert a little pointless...
Top 10 Expensive Queries
Top 1 execution count query on my DB:
insert into @ValueTable ( [Value]) Values (@NextString)
5,000,000 calls a day.
Where is this being called from?
Thanks
Dave
Brian Donahue wrote:
Hi Dave,
When I view a blocked process alert, I get the following in the "Processes" tab - it shows a blocked process and a blocking process.
Blocked process: SQLCMD
Process ID: 54
Database: DeadlockTests
Host: RGSERVER1
User: BDESA10\ESAUSER
Start time: 16 Dec 2013 11:03 AM
SQL fragment: (@1 int,@2 tinyint)UPDATE [TableA] set [id] = @1 WHERE [id]=@2
Blocking process: SQLCMD
Process ID: 53
Database: DeadlockTests
Host: RGSERVER1
User: BDESA10\ESAUSER
Start time: 16 Dec 2013 11:03 AM
SQL fragment: BEGIN TRAN
UPDATE TableA
SET id = 2
WHERE id = 1
WAITFOR delay '00:03:00'
ROLLBACK
Hi Brian, I get similar entries in my log for blocks but I've noticed that if a large select statement is run against the DB and has many table joins it can cause multiple blocks but the big query itself is not being shown as the cause of the blocking but rather an update or delete statement a step down in the chain. / comments
Brian Donahue wrote:
Hi Dave,
When I view a blocked process alert, I get the following in the "Processes" tab - it shows a blocked process and a blocking process.
Blocked process: SQLCMD
Proce...
SQL monitor blocking
SQL monitor doesn't show the lead blocker.
It catches blocks but only shows ones with a blocking process ID, it doesn't show the process that caused the start of the blocking.
If i run a big report...
Update SQl Monitor
Im currently on SQL Monitor 3.3.0.270. I've been meaning to upgrade to v3.5 but now i have the time to upgrade the link has disappeared
Can someone give me the url to the upgrade?
Many Thanks D