Red Gate forums :: View topic - view sqlUser on alerts page | write custom alerts per sqlUsr
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

view sqlUser on alerts page | write custom alerts per sqlUsr

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dave heywood



Joined: 07 Nov 2013
Posts: 1
Location: United Kingdom

PostPosted: Thu Nov 07, 2013 10:13 am    Post subject: view sqlUser on alerts page | write custom alerts per sqlUsr Reply with quote

Hi,

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.....
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6674

PostPosted: Fri Nov 08, 2013 4:17 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group