Search Results for “first responder kit”

  1. Home
  2. Search Results
  3. (Page 4)
Pocket Square

First Responder Kit Updates: New Checks Across the Board

First Responder Kit
1 Comment
It’s the December to Remember Script Event, and we’ve got updates to everything. Shout out to our contributors this month: @BlitzErik, @RichBenner, @runamuk0, @SQLMonger, and @BrentOzar. Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #591 – add check for 2016 Standard installed without Service Pack 1 (coded by @RichBenner) #615…
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

First Responder Kit Update: sp_BlitzCache Catches Cursors, Scalar Functions, and More

First Responder Kit
7 Comments
Every time we take on a client for our SQL Critical Care®, the very first thing we do is run the First Responder Kit scripts: sp_Blitz to get a health check, sp_BlitzFirst to check their wait stats, sp_BlitzIndex to look at their indexes, and sp_BlitzCache to see the most resource-intensive queries. Very often, these scripts surface…
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

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

First Responder Kit Updated, and sp_AskBrent is now sp_BlitzFirst

We’ve released the first fully open source version of our SQL Server First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzRS, sp_BlitzTrace, and the newest member: the newly renamed sp_BlitzFirst. I wanted to rename sp_BlitzFirst because as an open source project, it’s going to have more than just my own answers as to why your SQL Server…
Read More
Pocket Square

SQL Server First Responder Kit Support

SQL Server First Responder Kit Support Got a question or request for scripts in our First Responder Kit? Here’s a few ways to get help: Got a feature request? Read about how to contribute. – We’ve open sourced our scripts, and we welcome contributions from the public. Got a question or issue? Ask it on DBA.StackExchange.com. –…
Read More
Pocket Square

First Responder Kit

What do you do when SQL Server is unusually slow? Disaster strikes your SQL Server: queries are stalled, applications are down, customers are calling in like crazy, and your boss is in a panic. What do you do? What if the same thing happens, but you’re on vacation? (Can you hear your cell phone ringing…
Read More
Pocket Square

First Responder Kit

My free First Responder Kit (zip) is packed with scripts, worksheets, and checklists like: sp_Blitz, sp_BlitzIndex, sp_BlitzCache – free health check scripts SQL Server Setup Checklist – with the common questions I get about configs High Availability and Disaster Recovery Planning Worksheet – communicating your RPO and RTO clearly The Data Professional Annual Salary Survey…
Read More

SQL Server First Responders Kit Video

7 Comments
When your SQL Server is critically injured you need a first responder kit to help you diagnose the problem and apply emergency aid. In this session, Kendra Little introduces you to invaluable tools and techniques for triaging an emergency. If you have one year’s experience with database administration, this half-hour session will set you up…
Read More
Brent Ozar's Consultant Toolkit

Consultant Toolkit

0 customer reviews
You’re a consultant, and you need to get diagnostic data from your clients’ SQL Servers. You’re tired of asking them, “What version are you running?” and “How big are your databases?” You’re sick of running DMV queries one at a time, copy/pasting the results into files. You’ve played around with the built-in tools like PSSdiag,…
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
Menu