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.
Пікірлер: 8
your jokes make me wanna smoke SO BAD!
@TheBrentOzar
3 жыл бұрын
I hope that's a good thing, hahaha.
You are God sent
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
2 жыл бұрын
During the install you pick where you want it to live.
Thanks for the video. I think it's a positive that I understand the technical content more than the cultural references.
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
2 жыл бұрын
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.