BOL Profiler Eventclasses not correct?!

Good morning all

I'm creating a table drawn from all the various books online for SQL
Profiler event classes and have discovered seeming duplicates in the SQL 200
5
BOL topic "SQL Server Event Class Reference" (which appeared AFTER the
December update):

Broker:Forwarded Message Sent - EventClass 190 (was 139), designated as
Always 190

Progress Report: Online Index Operation - EventClass 190

Broker:Forwarded Message Dropped - EventClass 191 (was 140)

TM:Save Tran Starting - EventClass 191

Data File Auto Grow event class - EventClass 92

Log File Auto Grow event class - EventClass 92

Data File Auto Shrink event class - EventClass 95

Log File Auto Shrink event class - EventClass 95

Broker:Queue Disabled - EventClass 143 (REMOVED?)

Anyone else discovered this or is this by 'design', and of course has anyone
from MS got an idea on the 'right' event numbers?

Cheers

Charl

Charl  wrote:
> Good morning all
>
> I'm creating a table drawn from all the various books online for SQL
> Profiler event classes and have discovered seeming duplicates in the
> SQL 2005 BOL topic "SQL Server Event Class Reference" (which appeared
> AFTER the December update):
>
> Broker:Forwarded Message Sent - EventClass 190 (was 139), designated
> as Always 190
>
> Progress Report: Online Index Operation - EventClass 190
>
> Broker:Forwarded Message Dropped - EventClass 191 (was 140)
>
> TM:Save Tran Starting - EventClass 191
>
> Data File Auto Grow event class - EventClass 92
>
> Log File Auto Grow event class - EventClass 92
>
> Data File Auto Shrink event class - EventClass 95
>
> Log File Auto Shrink event class - EventClass 95
>
> Broker:Queue Disabled - EventClass 143 (REMOVED?)
>
> Anyone else discovered this or is this by 'design', and of course has
> anyone from MS got an idea on the 'right' event numbers?
>
> Cheers
>
> Charl

Query the system view sys.trace_events

--
David Gugick
Quest Software
www.quest.com

Hi Charl

I addressed this in your other thread, posted 10 minutes earlier than this
one.
Please look at the new metadata view in SQL Server 2005 called
sys.trace_events.

--
HTH
Kalen Delaney, SQL Server MVP
www. solidqualitylearning
.com


"Charl" <Charl@discussions.microsoft.com> wrote in message
news:AC94110E-12E3-41C3-AE20- 52F4F20AD891@microso
ft.com...
> Good morning all
>
> I'm creating a table drawn from all the various books online for SQL
> Profiler event classes and have discovered seeming duplicates in the SQL
> 2005
> BOL topic "SQL Server Event Class Reference" (which appeared AFTER the
> December update):
>
> Broker:Forwarded Message Sent - EventClass 190 (was 139), designated as
> Always 190
>
> Progress Report: Online Index Operation - EventClass 190
>
> Broker:Forwarded Message Dropped - EventClass 191 (was 140)
>
> TM:Save Tran Starting - EventClass 191
>
> Data File Auto Grow event class - EventClass 92
>
> Log File Auto Grow event class - EventClass 92
>
> Data File Auto Shrink event class - EventClass 95
>
> Log File Auto Shrink event class - EventClass 95
>
> Broker:Queue Disabled - EventClass 143 (REMOVED?)
>
> Anyone else discovered this or is this by 'design', and of course has
> anyone
> from MS got an idea on the 'right' event numbers?
>
> Cheers
>
> Charl
>
>

Thanks to Kalen and David for the reply, I have joined the table previously
created from the BOL information to sys.trace_events. Having retained the
original data from BOL before the December update and ignoring the Broker
eventclass changes there is only one missing eventclass - 144 Broker:Mirror
Route.

My point is that the BOL data is somewhat inaccurate in this case especially
given that most DBAs needing to run Profiler will (I hope!) be refering to
BOL...
Thus when you refer to the EventClass information and it lists an eventclass
it is surely fair to expect the data to be valid?

Best regards,

Charl
"Kalen Delaney" wrote:

>
> Hi Charl
>
> I addressed this in your other thread, posted 10 minutes earlier than this
> one.
> Please look at the new metadata view in SQL Server 2005 called
> sys.trace_events.
>
> --
> HTH
> Kalen Delaney, SQL Server MVP
> www. solidqualitylearning
.com
>
>
> "Charl" <Charl@discussions.microsoft.com> wrote in message
> news:AC94110E-12E3-41C3-AE20- 52F4F20AD891@microso
ft.com... 
>
>
>
>

Charl  wrote:
> Thanks to Kalen and David for the reply, I have joined the table
> previously created from the BOL information to sys.trace_events.
> Having retained the original data from BOL before the December update
> and ignoring the Broker eventclass changes there is only one missing
> eventclass - 144 Broker:Mirror Route.
>
> <SNIP>

You can email feedback directly to Microsoft about the page in question
using the Send Feedback option at the top and then pressing the Send
Feedback button at the bottom.


--
David Gugick
Quest Software