User Error Message - High Count

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

User Error Message - High Count

Postby sean.alexander@ontario.ca » Tue Apr 17, 2012 9:36 pm

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: Select all
USE tempdb
SET nocount ON
SELECT SERVERPROPERTY('IsSingleUser');


Which generated a "User Error Message"

Also, there are:
Code: Select all
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.
sean.alexander@ontario.ca
 
Posts: 6
Joined: Wed Mar 28, 2012 5:54 pm

Postby Chris Spencer » Thu Apr 19, 2012 2:24 pm

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
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

trace flags

Postby sean.alexander@ontario.ca » Thu Apr 19, 2012 2:42 pm

I'll see if there is any way to disable these by trace flags.
sean.alexander@ontario.ca
 
Posts: 6
Joined: Wed Mar 28, 2012 5:54 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 1 guest