Important Trace Flags That Every DBA Should Know
Presenter: Victor Isakov
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) and that they are not supported. Nothing could be further from the truth! Take trace flag 4199, for example (and yes, it's probably worth your while reading KB974006 to understand what trace flag 4199 does!).
In this session, Victor 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.
About the Speaker:
Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd, SQL Connections, PASS Summit, and SQL Code Camp. He has authored a number of books on SQL Server and worked with Microsoft to develop the SQL Server exams and certification.
In 2007, Victor was invited by Microsoft to attend the “SQL Ranger” program in Redmond, WA. Consequently, he was one of the first IT professionals to achieve both the Microsoft Certified Master: SQL Server and Microsoft Certified Architect: SQL Server certifications globally.