~/talk

Become an Expert in Managing Your Tempdb

on YouTube 31m
Talkat Women Data Summit 2021 · on Saturday, 2021-06-26· [databases]

speaker

name:Deepthi Goguri
website:https://dbanuggets.com/

resources

video:https://youtu.be/Acwg4YYiL1k
slides:none on file

summary

Deep dive into tempdb internals with actionable steps: set tempdb to SIMPLE recovery, put data and log on separate fast storage, create multiple data files — start with one file per CPU up to 8 and add in fours if contention persists — size files equally and set fixed autogrowth (for example 64 MB). Use DMVs like sys.dm_db_file_space_usage and sys.dm_db_task_space_usage to find hot operations, and apply SQL Server 2019 allocation improvements to reduce metadata contention.

AI-written summary · about

chapters (5)

  1. 0:00Introduction to tempdb
  2. 6:42Types of tempdb contention
  3. 10:07Solving allocation contention
  4. 21:15Automating tempdb cleanup
  5. 29:06Best practices summary

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.