DBCC PAGE Flood

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

DBCC PAGE Flood

Postby TheSQLGuru » Tue May 27, 2014 3:01 pm

Profiling my system while SSC starts up and I noticed a massive amount of DBCC PAGE commands being sent in. No worries - I figure gathering metadata information about objects. But then I stumbled across the 9 THOUSAND PLUS SQL Server Information errors clogging up my windows error log. Makes it hard to see useful stuff in there, plus it can cause wrapping where you lose messages you might otherwise want to keep around.

The messages were all DBCC TRACEON 3604, DBCC TRACEOFF 3604 pairs. Since it seems that this was done during start up and all on the same SPID even, just issue ONE DBCC TRACEON 3604 so you can capture the DBCC PAGE output, rip through your DBCC PAGE calls, then DBCC TRACEOFF 3604. Just 2 informational messages (and a LOT less database activity too, btw) instead of thousands. This should be a no-brainer, very-low-risk change to make too.
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
TheSQLGuru
 
Posts: 19
Joined: Mon Mar 12, 2007 5:20 pm

Postby toad2898 » Thu May 29, 2014 9:57 am

I've noticed this too and agree it generates alot of noise in the error logs. I second your notion for change!
toad2898
 
Posts: 29
Joined: Mon Sep 14, 2009 2:36 pm

Postby TheSQLGuru » Thu May 29, 2014 2:20 pm

I currently have over 16000 of these messages in my log!!
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
TheSQLGuru
 
Posts: 19
Joined: Mon Mar 12, 2007 5:20 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest