Configuration: TempDB Files and Sizes

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…

To access this incredible, amazing content, you gotta get Fundamentals of Database Administration or Recorded Class Season Pass, or log in if you already shelled out the cash.

Menu
{"cart_token":"","hash":"","cart_data":""}