Trace flags question.

Question

Trace flags question.

SQLisAwe5oMe

SSChampion

Points: 14052
More actions
June 15, 2013 at 12:48 pm

#279127

Hi Guys,
Does anyone know what does these trace flags will do when I turn them on? And what does it suppose to do? Please advise.
dbcc traceON (8026, -1)
dbcc traceon(2551,-1)
go
dbcc dumptrigger('set',18456)
go
Thanks,
SueTons.
Regards,
SQLisAwe5oMe.

Viewing 3 posts - 1 through 2 (of 2 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

we need filtered dump (only once) on the exception 12345 then we can enable trace flag 2551,8026 :
dbcc traceon (8026,2551,-1)
2551 –> To configure the filtered dump
8026 –>To clear the dumptrigger after generating the dump once.
and then enable

More at:http://sql-blogs.com/2012/01/25/complete-explanation-of-sql-server-memory-dumps-and-its-types/

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 2

bitbucket-25253 (6/15/2013)
we need filtered dump (only once) on the exception 12345 then we can enable trace flag 2551,8026 :
dbcc traceon (8026,2551,-1)
2551 –> To configure the filtered dump
8026 –>To clear the dumptrigger after generating the dump once.
and then enable
More at:http://sql-blogs.com/2012/01/25/complete-explanation-of-sql-server-memory-dumps-and-its-types/

Thanks.

SueTons.

Regards,
SQLisAwe5oMe.