Search Results for &#8220;sp_blitzindex&#8221;

Index tuning is the fastest way to make queries go faster without buying hardware or spending time in development. Indexing is as much an art as a science, though: there are a lot of vague guidelines, and sometimes you have to break those guidelines in order to get better performance. sp_BlitzIndex is about analyzing your…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.

sp_BlitzIndex's new statistics histograms at the bottom

How Should We Show Statistics Histograms in sp_BlitzIndex?

Last Updated January 4, 2019

Indexing, sp_BlitzIndex

If you’re a graduate of my free How to Think Like the SQL Server Engine course – and you’d better be, dear reader – then you’re vaguely familiar with DBCC SHOW_STATISTICS. It’s a command that shows you the contents of a statistics histogram. When I’m doing the first two parts of the D.E.A.T.H. Method – (D)eduplicating identical…

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

Last Updated July 1, 2020

sp_BlitzIndex

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. They’re just behavioral traits. Let your freak flag fly. One of the warnings is “Aggressive Indexes,” which means sys.dm_db_operational_stats reports minutes of…

1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)

Last Updated December 28, 2017

What if you’re dealing with a database that already exists, and you need to make it go faster with the minimum changes possible? You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how. Part 1 (19 minutes): Part 2 (51m):

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

1.5 Tuning Indexes with sp_BlitzIndex Part 2 (9m)

Last Updated April 17, 2018

You’re not starting from scratch – you’re dealing with a database that already exists, and you have to make it go faster. You need to analyze the current indexes, remove the ones that aren’t helping, and add the right ones. We’ll show you how.

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

1.5 Tuning Indexes with sp_BlitzIndex Part 1 (47m)

Last Updated April 17, 2018

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

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

Last Updated November 15, 2016

These improvements go great with cranberries. The food, not the b – actually, they go pretty well with the band, too. sp_Blitz Improvements #568 – @RichBenner added a check for the default parallelism settings sp_BlitzCache Improvements by @BlitzErik #495 – add warning for indexed views with missing stats #557 – bug fix – don’t alert…

Updated First Responder Kit: sp_Blitz markdown output, sp_BlitzIndex statistics checks

Last Updated April 25, 2017

In addition to lots of bug fixes and tweaks, my favorite option is: sp_Blitz @OutputType = ‘markdown’ sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1, @CheckUserDatabaseObjects = 1 See, recently I’ve spent a lot of time looking at Stack questions going, “Man, if I just had the output of sp_Blitz, I bet I could answer that question…

Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

Last Updated September 22, 2020

First Responder Kit, sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em: How to Use sp_Blitz for a Health Check How to Use sp_BlitzCache to Find Slow Queries How to Use…

First Responder Kit 2016-09: sp_Blitz, sp_BlitzCache, sp_BlitzIndex Improvements

Last Updated February 13, 2017

First, thanks to 5 community volunteers for contributing code this month. In addition to lots of bug fixes, small stuff, and a new Github issue template (thanks, Konstantin Taranov) here’s the big improvements: sp_Blitz Changes @OutputServerName writes output to remote server (Haris Khan) – for years, these stored procs have had an @OutputServerName parameter just waiting to…

Announcing sp_BlitzIndex® v3.0, sp_Blitz® v48, More

Last Updated February 13, 2017

Lots of fun stuff out this week: sp_BlitzIndex® v3.0 adds prioritized, streamlined results. We see so many index design disasters, and we know you have a limited amount of time. Doug Lane put a ton of work into focusing the output on the most important issues, things that are easy-to-fix and will have an immediate performance improvement, and…

sp_BlitzIndex Workaholic Indexes

Last Updated January 30, 2014

Workaholic Indexes These poor indexes. Do they ever get to rest? Checking for top tables We have two checks for workaholics. In sp_BlitzIndex® output, they’ll look something like this: Click to view in a larger window Let’s break down what that means. Workaholics: Scan-a-lots (sys.dm_db_index_usage_stats) These indexes show as having the top user scans according…

sp_BlitzIndex® Holiday Week Edition

Last Updated February 13, 2017

Only one thing could have dragged me away from the soft glow of the electric leg lamp glowing in the window… sp_BlitzIndex® It’s one of those weeks when things get nice and slow. Your business users and managers are all out of the office due to holidays. Your inbox is blissfully quiet. You get a…

sp_BlitzIndex Abnormal Psych

Last Updated July 2, 2018

sp_BlitzIndex® says: We’re Not in Kansas Anymore Our sp_BlitzIndex® script checks out your indexes and lets you know when it finds some things that are unusual. Abnormal psychology findings aren’t necessarily problems– just look at this as a big FYI. Some implementations of indexes may mean that the database can only be restored in a certain…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

Last Updated February 13, 2017

First Responder Kit, Videos

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…

sp_BlitzIndex Missing Indexes

Last Updated March 20, 2019

Diagnosis: Index-a-phobia Change can be rough. But if you never change your indexes, that’s even worse. You have high value missing indexes sp_BlitzIndex® has diagnosed you as having at least one high value missing index. This is at least one (maybe more) indexes that SQL Server thinks could really speed up queries. Now, before we get…

sp_BlitzIndex Feature Phobia

Last Updated December 9, 2018

Your Indexes have Feature Phobia Well, lets be blunt here. Indexes are rarely scared of new features. It’s really people who are scared of new features– or maybe they just don’t know about them. But sp_BlitzIndex® doesn’t like to point fingers at people, so let’s just put the blame on your indexes. No indexes use includes “Included…

sp_BlitzIndex Aggressive Indexes

Last Updated June 20, 2018

Diagnosis: your indexes are just plain violent BAM! BAM! That’s the sound of your indexes clashing into one another. sp_BlitzIndex® found signs of blocking in your database. Can’t we all just get along? Not really. SQL Server runs in pessimistic locking mode by default. Unless you tell it differently, in each database readers may block writers…

sp_BlitzIndex Security

Last Updated March 12, 2016