Back to Browse

Troubleshoot increased Tempdb size in SQL Server

3.6K views
Aug 20, 2023
9:57

In this video, I will share how to troubleshoot the issue related to increaased tempdb size. If you are facing increased tempdb size and want to know root cause of this, you are in right place. Chapters: 0:00 - Introduction 0:17 - Steps to troubleshoot the issue 2:30 - Troubleshoot in SSMS with real examples: increased tempdb size due to user object 6:15 - Troubleshoot in SSMS with real examples: increased tempdb size due to internal objects 7:39 - Troubleshoot in SSMS with real examples: increased tempdb size due to version store 🚀►Github for queries: https://github.com/Bobirmirzo/tempdb/blob/main/g.tsql 📚 ►Full course on Troubleshooting sessions: https://youtube.com/playlist?list=PLxuuX6jGq7kmlUblaWyfIh-iT5r0EWrJX&si=gC5FAhH9i6_b0waY 📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_boburmirzo?igsh=OGQ5ZDc2ODk2ZA%3D%3D&utm_source=qr 🧑‍💼►Follow me on LinkedIn - https://www.linkedin.com/in/bobirmirzo-arslanov-548960173 Watch all my playlists here: 🚀►Full course on Encrypting connections to SQL Server- https://youtube.com/playlist?list=PLxuuX6jGq7kmqOCqYa1lFxQOKFgTfb8j8&si=bBwHhLsu6m5CjFft 🚀 ►SQL Server replication session: https://youtube.com/playlist?list=PLxuuX6jGq7km5E54qm0zc7REGXw6WD4C8&si=fQ_PVoGQ1S8SeI6X 🚀 ►SQL Server Always On Availability Group: https://youtube.com/playlist?list=PLxuuX6jGq7klnjr9OIGt8R1SN76pQzuEB&si=zZVr_sJnc7I9H8d3 🚀 ► SQL Server internals: https://youtube.com/playlist?list=PLxuuX6jGq7kk5_OkxbZ8QDZ2HFBDy2XZ2&si=U2rRfgS2y87t5SU4 🚀 ► Course in On-memory OLTP: https://youtube.com/playlist?list=PLxuuX6jGq7kmt6gfHUW5KhfXGaoSiDXOB&si=fVS1s2L6If36Zg-r

Download

1 formats

Video Formats

360pmp413.0 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Troubleshoot increased Tempdb size in SQL Server | NatokHD