SQL Server performance monitoring and alerting
Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer
I'm using SQL Monitor to manage a web server, and we use SQL Data Compare heavily against it. We get quite a few "long running queries" and other alerts from various websites on the server, from Data Compare etc.
I've split the sql connection strings for each connection out against a different user, so now we can at least identify the source of each query (by users), but is there a way of showing the User in the alert table, or even could I rewrite the "long running query" alert and write one per user to be only raised if the query matches that user ?
Any help would be great on this, I've been through the documentation and the forum, but can't see any real references to people wanting to query against the user calling the queries.....
- Posts: 1
- Joined: Thu Nov 07, 2013 9:55 am
- Location: United Kingdom
You can't add a column to the list of alerts to show additional information (user name) and you can't filter out alerts by user. What you can do is filter alerts so they won't be displayed when the query matches a certain SQL command or SQL process name.
So in the case of SQL Data Compare, you can filter out long-running query alerts using the process name "Red Gate Software - SQL Tools", because this is the application name that SQL Data Compare sets as the application name.
I hope this helps.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Monitor 3
Who is online
Users browsing this forum: No registered users and 0 guests