Search Results for “first responder kit”

  1. Home
  2. Search Results
  3. (Page 5)

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

sp_BlitzFirst v14 adds CPU % Utilization

SQL Server
1 Comment
When your SQL Server is having performance problems, sp_BlitzFirst® checks a bunch of common trouble spots. In this week’s new version, it also checks sys.dm_os_ring_buffers for the most recent CPU utilization report from SQL Server and returns it. Here’s what it looks like when the server isn’t under load – note that “No Problems Found” means…
Read More
Pocket Square

sp_BlitzFirst

sp_BlitzFirst Helps You Troubleshoot Slow SQL Servers. I kept getting emails and phone calls that said, “The SQL Server is running slow right now, and they told me to ask Brent.” Each time, I’d have to: Look at sp_who or sp_who2 or sp_WhoIsActive for blocking or long-running queries Review the SQL Server Agent jobs to…
Read More

[Video] Office Hours in Moab, Utah

Videos
15 Comments
On a cross-country trip, I stopped in Moab, Utah and answered your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:20 YourbiggestFan: Do you have any plans to write an Azure first version of the first responder kit (sp_blitzfirst and sp_bitzcache)which can get the metrics from query store and thus overcome the issue…
Read More

[Video] Office Hours Speed Round: SQL Server Q&A

Videos
0
You posted questions at https://pollgab.com/room/brento and I picked the fastest ones to answer: Here’s what we covered: 00:00 Introductions 00:16 Disgruntled App Developer: Hi Brent a friend was recently reprimanded for running a trace in production. The rationale was perf impact and other ‘potential issues’ that weren’t forthcoming. Any thoughts on why traces have an…
Read More

Free Live Class This Week: Fundamentals of TempDB

Company News
2 Comments
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind…
Read More

[Video] Office Hours Speed Round: Quick Answers

Videos
1 Comment
Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions: 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for around 20 minutes our update or inserts calls from api which is expected to be completed with few seconds.…
Read More

Free Classes Start Next Week. Register Now.

Company News
8 Comments
This month & next, I’m going to teach you the fundamentals of SQL Server database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fall I’m updating and expanding it to a 3-hour version.…
Read More