Friday, March 9, 2012

Errors and Warnings

Running SQL 2005, SP1 on WIN2K3.
I am in the midst of troubleshooting High CPU and have identified several
queries that could use some performance tuning.
However, in the midst of performing some traces in Profiler, not wanting to
rule anything out, I included some of the "Errors and Warnings" events.
One Event Class that occurs very often is an Event Class of "User Error
Message" with:
TextData = "Changed database context to '[Name of a database]', and
TextData = "Changed language setting to us_english."
Because of the shear number of these messages occuring, I was wondering if
this is an error to be concerned about. Any thoughts?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200708/1It is more of an informational message but you may want to find out why they
are changing these. Normally you would set these in the connection and I
wouldn't expect them to pop up otherwise but I never trace that event.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"cbrichards via SQLMonster.com" <u3288@.uwe> wrote in message
news:7779563dc14d7@.uwe...
> Running SQL 2005, SP1 on WIN2K3.
> I am in the midst of troubleshooting High CPU and have identified several
> queries that could use some performance tuning.
> However, in the midst of performing some traces in Profiler, not wanting
> to
> rule anything out, I included some of the "Errors and Warnings" events.
> One Event Class that occurs very often is an Event Class of "User Error
> Message" with:
> TextData = "Changed database context to '[Name of a database]', and
> TextData = "Changed language setting to us_english."
> Because of the shear number of these messages occuring, I was wondering if
> this is an error to be concerned about. Any thoughts?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200708/1
>

No comments:

Post a Comment