Press "Enter" to skip to content

Day: June 10, 2025

Resource Governor on TempDB in SQL Server 2025

Published 2025-06-10 by Kevin Feasel

Ed Pollack takes a peak at some upcoming functionality:

TempDB is a system database in SQL Server that manages temporary objects for all databases on a server. Because it is a shared resource, it can easily become a performance bottleneck., as well as an opportunity for a single database or even a single query to wreck SQL Server performance.

Because of this, administrators will often give TempDB plenty of space and put its files on the fastest storage available. Even with these precautions, it is still possible for a TempDB-hungry workload to hog space and resources that result in latency or timeouts for end users.

SQL Server 2025 introduces the ability to use Resource Governor to help manage TempDB resources automatically. This article dives into the new feature, how to configure it, and how it can effectively manage TempDB-heavy workloads.

Ed starts with a primer on TempDB and Resource Governor functionality, then dives right in. It’s good to see some love for Resource Governor.

Leave a Comment

SQL Server Performance Troubleshooting Script Updates

Published 2025-06-10 by Kevin Feasel

Erik Darling has been busy (plus raking in changes from contributors like he’s farming in an AFK game):

It’s been a busy few months working on scripts in my GitHub repo, including adding two new members to the family.

  • sp_IndexCleanup: Easily deduplicate indexes — scripts all the changes out for you!
  • sp_PerfCheck: A high-level review of performance-related settings and configurations!

Read on to see which other scripts have updates and where you can download all of Erik’s scripts.

Leave a Comment

Debugging Fabric UDFs in Visual Studio Code

Published 2025-06-10 by Kevin Feasel

Sunitha Muthukrishna takes us through a debugging exercise:

Debugging your code is important to identify issues and mitigate them when you’re working with user data functions in Microsoft Fabric. You want to make sure everything works as it should and that’s where local debugging lets you catch problems in your code without messing with the live environment. In this blog post, I will walk you through the steps to make local debugging easier and faster.

Click through to see what you’ll need, as well as the process to debug a function locally.

Leave a Comment

Databases and Reboots

Published 2025-06-10 by Kevin Feasel

Rob Douglas will reboot many things, but not the database server:

I am taking a slightly different tangent. My problem is neither strange or unique – in fact it’s infuriatingly common and it stems from one of the most common troubleshooting techniques in IT. While asking users “Have you tried turning it off and on again?” is a common go to for tech support call handlers, it is not a great idea when the “it” you are talking about is a database server

Click through for a cautionary tale, as well as an explanation of why this usually isn’t the smart play.

Leave a Comment

SSMS 21 Extended Events Session Creation Bugfix

Published 2025-06-10 by Kevin Feasel

Grant Fritchey is happy:

I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that the New Session window in SSMS for Extended Events always opened to the wrong size.

Click through for an example of the bug and how SSMS 21 fixes things. This type of bug is particularly pernicious because there aren’t scroll bars or any sort of indicator that some additional functionality exists, so unless you know that it’s there, you won’t know to look for it.

Leave a Comment