Join Our Mailing List!
When: Thursday, April10th, 2014, 6:30 PM - 8:00 PM
Social Time starts at 6:00 PM!
TempDB 101 Plus
TempDB is not your ordinary user database and should definitely not be treated like one. The usage patterns and internals dictate that the configuration, monitoring and usage be done in a different way to get the best performance. We will see why aspects such as configuration and file placement play such a key role and why you need to plan ahead for TempDB. See how to detect the memory and space usage associated with the various users in TempDB along with some of the most common performance related scenarios that you will encounter with a well-used TempDB database. Both DBA’s and Developer’s should understand the concepts of TempDB and how some relatively simple changes in code or configuration can potentially make a huge difference in the overall performance of SQL Server.
Andrew J. Kelly is a Mentor with SolidQ (www.solidq.com) and lives in Myrtle Beach, South Carolina. He has over 20 years experience with relational databases and application development on both UNIX and Windows platforms but his main focus now is SQL Server. In addition to general SQL Server training and Mentoring he specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year at many conferences and user groups and has been a SQL Server MVP since 2001.
We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!