How can we help you today? How can we help you today?

User Error Message - High Count

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

Which generated a "User Error Message"

Also, there are: 
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
0

Comments

2 comments

Sort by
  • Chris Spencer
    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
    0
  • sean.alexander
    I'll see if there is any way to disable these by trace flags.
    sean.alexander
    0

Add comment

Please sign in to leave a comment.