Red Gate forums :: View topic - User Error Message - High Count
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

User Error Message - High Count

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sean.alexander@ontario.ca



Joined: 28 Mar 2012
Posts: 6

PostPosted: Tue Apr 17, 2012 9:36 pm    Post subject: User Error Message - High Count Reply with quote

I enabled the custom metric of "Too many user errors" and finally had time to track down some of them.

The Application name was "SQL Monitor - Monitoring - GUID HERE".
The BatchStarting was:

Code:
USE tempdb
SET nocount ON
SELECT SERVERPROPERTY('IsSingleUser');


Which generated a "User Error Message"

Also, there are:
Code:
use [tempdb]


Which generated a "User Error Message" with the value "Changed database context to 'tempdb'."

There seems to be a lot of these initiated by the "SQL Monitor - Monitoring - GUID HERE" application.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Thu Apr 19, 2012 2:24 pm    Post subject: Reply with quote

Hi

I've ran a trace on one of my servers, and yes SQL Monitor seems to be creating a lot of user error messages like the following:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Changed database context to '<DatabaseName>'.


It suprises me that they are classified as 'errors' as it sounds more like 'information' to me. Running a simple USE statement in Management Studio also creates one of these errors so I don't think we're doing anything particularly wrong. Just doing it a lot!

It'd be interesting to hear any opinions about this. I'll keep investigating.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
sean.alexander@ontario.ca



Joined: 28 Mar 2012
Posts: 6

PostPosted: Thu Apr 19, 2012 2:42 pm    Post subject: trace flags Reply with quote

I'll see if there is any way to disable these by trace flags.
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