ON SALE
51 %
Save $100.00
Ends in 1606982399
ON SALE
34 %
Save $30.00
Ends in 1606982399
ON SALE
51 %
Up to $100.00
Ends in 1606982399

Fundamentals of TempDB

$59.00$95.00

Clear
  • $0.00

SKU: c-TempDBFundamentals Categories: , ,

Description

You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files.

You’re wondering what exactly goes on behind the scenes.

This class is for curious folks who want to learn:

  • What uses TempDB, and how that affects performance: not just temp tables and table variables, but also triggers, cursors, sorting indexes, workspace spills, the version store, and more
  • How to host TempDB depending on how you use it: understanding what goes in the log file, the data files, why the number of data files matter, and whether your particular workload should be on SAN, local storage, or ephemeral storage, and why
  • How to monitor it: after you understand what uses it and how to host it, you need to keep tabs on how its performance changes over time using DMVs, Perfmon counters, and the First Responder Kit scripts

This course is 90% demos: the only slides are the introductions at the start of the day, illustrations to support a few topics, and the recap at the end of the day. The rest of the time, we’ll be working in SQL Server Management Studio. Roll up your sleeves and join me!

Prerequisites:

  • Before this class, watch the free How to Think Like the SQL Server Engine class. Optionally, you’ll get the best experience out of the “What uses TempDB” modules if you’ve already completed my Fundamentals of Query Tuning and Fundamentals of Parameter Sniffing classes because we’re going to be looking at execution plans – particularly, confusing plans where row estimates have been reused from someone else’s session.
  • Have a local SQL Server 2016 or newer. Your server’s power doesn’t really matter – you can run this class’s labs on your local desktop just fine as long as you’ve got enough space for the database. I will show you the differences in SQL Server 2019, but if you’re not using 2019 yet, no worries – you can just watch those portions of the demos.
  • Download any Stack Overflow database. In the class, I’ll be using the 50GB StackOverflow2013 version, but any version/size will work.

This is a live online class – but you have two buying choices:

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

  • ON SALE
    80 %
    Save $1,190.00
    Ends in 1606809600
    Level 1 Bundle

    Level 1 Bundle

    $1,485.00 $295.00 / year
    Sign Up Now
  • ON SALE
    75 %
    Save $4,500.00
    ON SALE
    78 %
    Save $3,100.00
    ON SALE
    75 %
    Up to $4,500.00
    Live Class Season Pass

    Live Class Season Pass

    From: $895.00 / year
    Select options
  • ON SALE
    61 %
    Save $300.00
    Recorded Class Season Pass

    Recorded Class Season Pass

    $495.00 $195.00 / year
    Sign Up Now
Menu
{"cart_token":"","hash":"","cart_data":""}