DBA Fundamentals Configuring TempDB

TempDB is a special system database that gets used a LOT behind the scenes, and it needs different configuration than other databases. You'll learn why it's a performance bottleneck, why 4-8 data files alleviate the issue, show how to reconfigure an existing SQL Server, and see the pros and cons of different storage options for it.

[@brianmahoney7567]

Thanks for the video. I think it's a positive that I understand the technical content more than the cultural references.

[@antoniamesesan9711]

your jokes make me wanna smoke SO BAD!

[@TheBrentOzar]

I hope that's a good thing, hahaha.

[@johnboscogakumba8009]

You are God sent

[@tarjei99]

You put the tempdb for an on-site server on a separate *volume* because that makes it easy to see. Especially if you have no resident DBA. Your ordinary spy system discovers if it fills up.
I don't remember if Windows still has a limit of 1000 or 1200 IO operations per volume per second, but spreading data on several volumes should reduce memory requirements somewhat. At least there would be that option.

[@BrentOzarUnlimited]

1000 operations per volume per second? Holy smokes, you must be a time traveler from the 1980s. Time to report to some modern training, chief.

[@darylzero3139]

If you had a server with RAID1 10K OS disks and RAID1 SAS SSD Data drives how you configure the tempdb location and the other database locations?

[@tedm8492]

During the install you pick where you want it to live.