Skip to content
Query Performance Tuning Strategies with Monica Rathbun episode artwork

Apr 13, 2022 36 min

Query Performance Tuning Strategies with Monica Rathbun

from RunAs Radio Hosted by Monica Rathbun, Richard Campbell

How do you keep your SQL queries fast? Richard chats with Monica Rathbun about her approaches to SQL Server query tuning. Monica starts with defining the problem - how do we know that the database is the performance bottleneck? The conversation dives into measuring query performance and the power of Query Store, but only on SQL Server 2016 and above, so get upgrading! Entity Framework is a standard tool for developers to automate access to SQL. Still, it can generate some pretty ugly queries, and Monica talks about different ways to improve them, including the old standby of writing a stored procedure. Lots of ideas for folks struggling to make their databases go fast! Links: Monitoring Performance with Query Store Common Table Expressions Cursors in SQL Server SQL Server Profiler Glenn's SQL Server Performance Blog Recorded February 22, 2022

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Query Performance Tuning Strategies with Monica Rathbun

0:00 36:03

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of RunAs Radio?

This episode is 36 minutes long.

When was this RunAs Radio episode published?

This episode was published on April 13, 2022.

Can I download this RunAs Radio episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.