The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

TempDB - Permanent Impact – sponsored by Hewlett Packard Enterprise

Wed, Sep 14 2016 18:00 UTC

TempDB - Permanent Impact – sponsored by Hewlett Packard Enterprise

As a DBA you hear different theories and "gospel truths" about TempDB from many people. Frankly there is no single version of the truth except that if you don't use and manage it well, it will make your life a real h*ll. What works for you in one situation may not work for you in another situation. What works for a situation today, might not guarantee its success for a similar situation tomorrow. We will talk about Temporary User Objects, Work Tables, Interim Results, Version Store for Data, Standards for its configuration, Contention, Data Files per CPU - Myth or Reality? Dynamic Growth or Pre Sized? Trace Flags to Manage Tempdb? Should we store the entire Tempdb on SSDs? Should we shrink TempDB or not? We will also look at the various enhancements in SQL 2016 about Tempdb and how best to monitor Tempdb. Hopefully at the end of the session your knowledge on Tempdb won't be Temp.

Paresh Motiwala

Paresh Motiwala an Azure enthusiast, a DBA Manager (Boston)has led several large SQL implementations, migrations and upgrades. He has managed multi terabyte OLTP databases. He loves learning and talking about Big Data. He has also been a Senior SQL DBA and a Solutions Architect in Fortune 100 companies. He also helps organizing / and speaks at many SQL Saturdays, Azure Bootcamp and User Groups. He is a certified in Big Data Analytics and FinTech(MIT) Project manager, Public Speaker, an avid singer, cook, open networker, and stand-up comedian. He teaches public speaking, debating, interviewing and group discussion skills. He also mentors DBAs in Boston area; and children around the globe via

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.


Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.


Follow us on Twitter: @PASS_DBA_VC

Back to Top