Search Results for “first responder kit”

Home
Search Results

Connect Item: Query Plan Hash in sys.dm_exec_query_stats vs Query Plan Hash in the query plan

Last Updated March 18, 2017

Shifty Henry said to Bugs You know those moments when you’re looking at something for so long, and it’s still not working, and you’re pretty sure you’re losing that final grip on your sanity? Well, that feeling was multiplied this week by an odd bug that I found, where Query Plan Hashes in system views…

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

Last Updated November 16, 2017

Erik Darling

First Responder Kit, sp_BlitzCache, T-SQL

It keeps me up at night Out of the box, sp_BlitzCache will give you enough stuff to work on in your server’s plan cache to last a month of leap days. This is great for most people, but if you use a ton of dynamic SQL in stored procedures, it can make things difficult. What’s…

[Video] Office Hours 2017/02/22 (With Transcriptions)

Last Updated February 25, 2017

Brent Ozar Unlimited Team

SQL Server, Videos

This week, Erik, Tara, and Richie discuss tempdb etiquette for developers, elastic search vs full-text search, server CPU spiking issues, source control in a database project, querying transaction logs, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the…

Crappy Missing Index Requests

Last Updated November 16, 2017

Erik Darling

Execution Plans, Indexing, sp_BlitzIndex

When you’re tuning queries It’s sort of a relief when the first time you get your hands on it, you get the plan and there’s a missing index request. Even if it’s not a super high-value one, something in there is crying for help. Where there’s smoke, there’s a bingo parlor. But does adding missing…

Simulating Workload With ostress And Agent Jobs

Last Updated February 14, 2017

Erik Darling

Load Testing, SQL Server

This question comes up a lot Especially during Office Hours, and the answer is usually… not great. You can spend a lot of money on people and complicated software to design, run, and monitor workloads against test environments, or you can throw together tests with some free tools like SQL Query Stress or Microsoft’s RML…

Analyzing Temporary Stored Procedures with sp_BlitzCache

Last Updated November 16, 2017

Erik Darling

First Responder Kit, sp_BlitzCache, TempDB

All the cool kids Know that when you’re trying to figure out why a stored procedure is slow sometimes, you should use a temporary stored procedure instead of pulling the code out and running it ad hoc. We frequently point people to Erland Sommarskog’s “Slow in the Application, Fast in SSMS“, because it’s an excellent…

[Video] Office Hours 2016/12/21 (With Transcriptions)

Last Updated December 24, 2016

Brent Ozar Unlimited Team

SQL Server, Videos

This week, Erik and Richie discuss latency, partition tables, SOS_SCHEDULER_YIELD, alerts, nolock, and what people look for in Senior DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss an episode, subscribe via iTunes, Stitcher or RSS.…

Things I Would Love to Put In sp_BlitzCache

Last Updated April 21, 2017

Erik Darling

Execution Plans, First Responder Kit, SQL Server

This is my favorite script to work on Getting stuff to work sp_BlitzCache is so rewarding because XML querying is so ridiculous. I wish Mikael Eriksson would write a book already; it’d make my life a whole lot easier. Along the way, I see a lot of things that I would love to warn people…

Selective XML Indexes: Not Bad At All

Last Updated February 14, 2017

Erik Darling

Indexing, SQL Server

Promises, Promises I said I’d follow up on this, and here it is. I’m by no means the world’s foremost authority on these, I just played with a simple example until I figured out what worked the best for my query. So you can all play along at home, I’m using XML we all have…

Computed Columns Referencing Functions

Last Updated December 7, 2017

Erik Darling

Computed Columns Referencing Functions If you’re here, it’s likely because sp_BlitzCache found a computed column referencing a scalar UDF. For more information about why this is bad, check out a couple blog posts: Still Serial After All These Years Another reason why scalar functions in computed columns is a bad idea And a video!

Spills SQL Server Doesn’t Warn You About

Last Updated February 13, 2017

Erik Darling

Execution Plans, SQL Server

Don’t make me spill Table variables get a lot of bad press, and they deserve it. They are to query performance what the TSA is to air travel. No one’s sure what they’re doing, but they’ve been taking forever to do it. One particular thing that irks me about them (table variables, now) is that…

Optimizer Forcing

Last Updated November 15, 2016

Erik Darling

Some hints can harm performance If you’re here, it’s most likely because sp_BlitzCache warned you about index or seek/scan forcing. Index forcing Index forcing has some pretty harmful side effects. Aside from the fact that it will stop SQL from making missing index requests, your queries will start to fail if the index gets disabled…

Why You Should Test Your Queries Against Bigger Data

Last Updated February 14, 2017

Erik Darling

Load Testing, SQL Server

I Like Testing Things Especially Brent’s patience. And I like watching people test things. SQL Server is sort of perfect for that. You make some changes, you hit f5, and you wait for something to finish. If it’s faster, you ship it. Right? I mean, we all know you just added NOLOCK hints anyway. A…

[Video] Office Hours 2016/08/31 (With Transcriptions)

Last Updated September 9, 2016

Brent Ozar Unlimited Team

SQL Server, Videos

This week, Brent, Richie, and Tara discuss corruption, resetting query stats, fixing parameter sniffing issues, how to suggest features for our scripts, and why Brent is sporting an Oracle sweatshirt. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast?…

Announcing our 2016 SQL Server Training Scholarship Winners

Last Updated February 12, 2017

Brent Ozar

Company News, SQL Server

We’re serious about the heart thing. Thanksgiving is the perfect day for us to give back to the community that has given so much to us. Our SQL Server Training Scholarship program applications were open to folks anywhere in the world working with SQL Server for foundations, non-profits, charities, or other similar companies making a real…

Training Plan for a SysAdmin to Manage Availability Groups

Last Updated April 9, 2017

Kendra Little

Always On Availability Groups

How hard is it for a systems administrator who’s used to running SQL Server on Windows Clusters to tackle Availability Groups? Our example system administrator knows a bit of TSQL and their way around Management Studio, but is pretty new to performance tuning. Well, it might be harder than you think. First, let’s look at…

Database Settings Changed Away from Defaults

Last Updated February 9, 2017

Brent Ozar

Blitz Result: Database Settings Changed Away from Defaults SQL Server has a lot of knobs and buttons, and us human beings just love pushing buttons and tweaking knobs. SQL Server needs a dog to prevent us from touching ’em. This portion of sp_Blitz® checks sys.databases looking for settings that have been changed away from their defaults.…

sp_BlitzTrace™: Extended Events Traces Made Easy

Last Updated September 14, 2017

Kendra Little

sp_BlitzTrace Ever wanted to quickly and easily record how much CPU a query is using, how many logical reads it uses, what temporary objects are created, and whether it causes a recompile? sp_BlitzTrace is a free stored procedure that helps you quickly and easily use Extended Events in SQL Server 2012 and higher to observe…

You’ll need a membership to access this course. Check out my training classes.

RECOMPILE Hints and Execution Plan Caching

Last Updated April 2, 2021

Kendra Little

Execution Plans, Parameter Sniffing

The DBA version of an XKCD classic. When you identify that parameter sniffing is a problem, you need to test whether implementing ‘recompile’ hints will help plan quality. (Not sure what parameter sniffing is? Learn from this blog post or this 50 minute free video.) You must decide: what hint or command do you use,…

Search Results for “first responder kit”

Connect Item: Query Plan Hash in sys.dm_exec_query_stats vs Query Plan Hash in the query plan

sp_BlitzCache Tip: Cutting Through Heavy Dynamic SQL Use

[Video] Office Hours 2017/02/22 (With Transcriptions)

Crappy Missing Index Requests

Simulating Workload With ostress And Agent Jobs

Analyzing Temporary Stored Procedures with sp_BlitzCache

[Video] Office Hours 2016/12/21 (With Transcriptions)

Things I Would Love to Put In sp_BlitzCache

Selective XML Indexes: Not Bad At All

Computed Columns Referencing Functions

Spills SQL Server Doesn’t Warn You About

Optimizer Forcing

Why You Should Test Your Queries Against Bigger Data

[Video] Office Hours 2016/08/31 (With Transcriptions)

Announcing our 2016 SQL Server Training Scholarship Winners

Training Plan for a SysAdmin to Manage Availability Groups

Database Settings Changed Away from Defaults

sp_BlitzTrace™: Extended Events Traces Made Easy

RECOMPILE Hints and Execution Plan Caching

Hi! I’m Brent Ozar.

Save your cart?