~/talk

Troubleshooting CPU Performance Issue for SQL Developers

on YouTube 58m
Talkat Great Indian Developer Summit 2015 · 2015-04-21..04-24· [databases]

speaker

name:Pinal Dave
github:pinalmdave

resources

video:https://youtu.be/1qNYdS2rJvg
slides:none on file

summary

Argues CPU matters but disk I/O usually decides real-world slowness and shows concrete fixes: a demo inserts 100k rows in 0.2s when log and data sit on fast media but 23s or 1m19s when the log or files are on slow drives or autogrowth triggers. Immediate wins are move log to SSD, separate MDF and LDF onto appropriate disks, and pre-size data files and set sensible autogrowth — changes that the demos show produce instant measurable speedups.

AI-written summary · about

chapters (6)

  1. 0:00Introduction and setup
  2. 6:36Basics of SQL Server resources
  3. 19:14Demo one: Single vs multi-disk storage
  4. 35:37Demo two: Log file performance impact
  5. 48:07Demo three: Database file optimization
  6. 57:36Summary and resources

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.