Posts
Sort by recent activity
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...
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
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