I hope you all enjoyed my talk.
Here are some of the links that I mentioned:
The Slides
D2L is Hiring
- Careers & Jobs at D2L Look for roles containing “Software Developer” although the “Performance Engineer” role also looks really cool.
Collecting Query Stats
- Query Store! Links courtesy Cleveland’s own Erin Stellato
Collecting Wait Stats
- Please tell me where it hurts (by Paul Randal) to look at accumulated query stats.
- Capturing Wait Statistics For A Period Of Time (also by Paul Randal)
- CaptureWaitStats (my github project to create query stats collection jobs)
Digging into I.O. Waits
- What Tables are Begin Written To The Most (a blog post of mine)
D2L Tackling tempdb For Good
- Why we were reluctant to use Hekaton: Postponing Our Use of In Memory OLTP
- Challenges modifying table types How to Alter User Defined Table Types (Mostly) Online
- And finally success: In Memory OLTP Defeated Our Tempdb Problems
Tackling Maximum Connections
Spinlock Contention
- Our Spinlock struggles: Detect Excessive Spinlock Contention on SQL Server
Indirect Checkpoint Links