DBCC Logical Scan Bytes/sec & default trace

Question

DBCC Logical Scan Bytes/sec & default trace

repent_kog_is_near

SSCertifiable

Points: 7278
More actions
March 23, 2010 at 7:25 pm

#139550

The default trace does audit on DBCC commands.
I see DBCC Logical Scan Bytes/sec counter running every 6 minutes for the Log file of a database, presumably from a 3rd party tool. But that is not being captured by the default trace. What could be the reason?
Dan

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

DBCC Logical Scan Bytes/sec is not a DBCC command it is a performance counter. Are you seeing any DBCC commands being run. I know that RedGate SQL Prompt using some DBCC commands so perhaps that is causing it, if you have it installed?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

repent_kog_is_near SSCertifiable Points: 7278 More actions · Answer 2

Yes, I see that other regular DBCC commands run and get captured.

Why name it 'DBCC' for a counter?

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

repent_kog_is_near (3/24/2010)
Yes, I see that other regular DBCC commands run and get captured.
Why name it 'DBCC' for a counter?

From BOL:

DBCC Logical Scan Bytes/sec
Number of logical read scan bytes per second for database console commands (DBCC).

So that's why. It is the counter that aggregates that information for all DBCC commands against the database.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

repent_kog_is_near SSCertifiable Points: 7278 More actions · Answer 4

ok. that confirms that there are DBCC commands running by the 3rd party tool. But should it not be also captured by the default trace. - if i try a shrinkfile, it captures it right away...

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

Yes you see the events captured. How are you querying/viewing the default trace?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

repent_kog_is_near SSCertifiable Points: 7278 More actions · Answer 6

never mind, I do see it, after all.

i use fn_trace_gettable for the purpose...

Thanks Jack.