Red Gate forums :: View topic - DBCC PAGE Flood
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

DBCC PAGE Flood

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
TheSQLGuru



Joined: 12 Mar 2007
Posts: 19

PostPosted: Tue May 27, 2014 3:01 pm    Post subject: DBCC PAGE Flood Reply with quote

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.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
toad2898



Joined: 14 Sep 2009
Posts: 26

PostPosted: Thu May 29, 2014 9:57 am    Post subject: Reply with quote

I've noticed this too and agree it generates alot of noise in the error logs. I second your notion for change!
Back to top
View user's profile Send private message
TheSQLGuru



Joined: 12 Mar 2007
Posts: 19

PostPosted: Thu May 29, 2014 2:20 pm    Post subject: Reply with quote

I currently have over 16000 of these messages in my log!!
_________________
Kevin G. Boles
SQL Server MVP 2007-2012
Indicium Resources, Inc.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group