Master, model, msdb, tempdb. You see them on all of your servers, but what do you really know about them? If you ever wanted to learn about the SQL Server system databases, their purpose, and the maintenance and configuration required to keep your server running its best, then this session is for you! Learn best practices and techniques, including how to restore master and how to configure tempdb to reduce contention. You'll leave with a better understanding of these shared resources and how they affect your database applications.
Speaker: With 14 years of professional software development experience, Vicky Harp is always interested in learning new ways to improve performance and maintainability of database code. Vicky is a product manager with Idera, where she has worked for the past 10 years creating software to make DBAs' lives easier. She speaks frequently at PASS events and is active on Twitter.
Topics: Database Performance, Database Diagnostics Products: SQL Server Tools for Better Performance