User Error Message - High Count

Monitor, diagnose and receive alerts to problems across your SQL Servers.

User Error Message - High Count

Postby » Tue Apr 17, 2012 8: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

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.
Posts: 6
Joined: Wed Mar 28, 2012 4:54 pm

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


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.

Chris Spencer
Test Engineer
Red Gate
Chris Spencer
Posts: 301
Joined: Tue Aug 29, 2006 8:09 am
Location: Red Gate - Cambridge

trace flags

Postby » Thu Apr 19, 2012 1:42 pm

I'll see if there is any way to disable these by trace flags.
Posts: 6
Joined: Wed Mar 28, 2012 4:54 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests