Archive

Posts Tagged ‘trace flag’

SQL PASS Summit 2011

Important Trace Flags that Every DBA Should Know

 

Again, thank you very much to all of the attendees to my session on indexing.

Likewise thanks to all the people that have thanked me at GameWorks for presenting on this topic.

As I said at the presentation, I was pleasantly surprise by the turn-out.

Finally a big thank you to Julie Koesmarno for co-presenting with me. I hope to do a session with her again soon. It was great fun!

Session:

Important Trace Flags That Every DBA Should Know [DBA-309]

There are a number of important trace flags that should be implemented in most production environments. Yet many DBAs think that trace flags should only be used for testing purposes or to "show-off" at conferences. That they are not supported. Yet nothing could be further from the truth. A good example is trace flag 4199. (Yes, it’s probably worth your while reading KB974006 to understand what trace flag 4199 does!). In this session, Victor Isakov (MCA, MCM, MCT, MVP) and Julie Koesmarno (MCITP) will present the important trace flags that all DBAs should know, what they do, when to implement them and how best to implement them in a production environment. This will enable you to maximize the performance and reliability of your SQL Server infrastructure.

Transact-SQL Demo Scripts

I hope to get invited to speak at SQL PASS Summit in 2012.

 

Safe travels and happy journeys,

Victor

Advertisements