Search Results for “sp_blitzindex”

  1. Home
  2. Search Results

04 Using sp_BlitzIndex to Diagnose the Most Urgent Index Issues

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 Live Class Season Pass, Recorded Class Season Pass or How I Use the First Responder Kit, or log in if you already shelled out the cash.
Read More

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

sp_BlitzIndex
11 Comments
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…
Read More

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

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.
Read More
Pocket Square

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

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…
Read More

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

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…
Read More

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

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…
Read More

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

First Responder Kit, SQL Server
0
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…
Read More
Pocket Square

sp_BlitzIndex Workaholic Indexes

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…
Read More
Pocket Square

sp_BlitzIndex Abnormal Psych

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…
Read More
Pocket Square

sp_BlitzIndex Missing Indexes

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…
Read More
Pocket Square

sp_BlitzIndex Feature Phobia

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…
Read More
Pocket Square

sp_BlitzIndex Aggressive Indexes

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…
Read More
Pocket Square

sp_BlitzIndex Security

How to Run sp_BlitzIndex® with Minimum Permissions Are you the conscientious DBA who would like to only run procedures with the minimum permissions needed? Or would you like to grant others the ability to run sp_BlitzIndex®, but not need to give them high level permissions? Good news: you can diagnose very tricky index disorders with…
Read More
Menu