Search Results for “sp_blitz”

Home
Search Results

Security Admins List

Last Updated April 8, 2015

Security admins can pat down any login- which gives them a lot of power. Blitz Result: Security Admins List Like sysadmins, don’t think of these security accounts as just plain security admins. Think of them as users who can get you fired. “But you said that about sysadmins!” Yep. But the sysadmins aren’t alone. Anyone…

Sysadmins List

Last Updated April 8, 2015

Brent Ozar

It may be time to trip the alarm on your sysadmins. Blitz Result: Sysadmins List Don’t think of these security accounts as sysadmins. Think of them as users who can get you fired. Anyone in the sysadmin role can perform any task whatsoever, including covering their tracks. This part of our SQL Server sp_Blitz script…

MSDB History Not Purged

Last Updated April 17, 2015

Brent Ozar

We’ve got a little bit of backup history here. Blitz Result: MSDB History Not Purged SQL Server tracks the history of every backup. It stores this data in the MSDB database. That’s a system database, and by default, our system databases are stored on the C drive unless specified otherwise during installation. This poses danger…

Thanks for registering. You’re now in an elite club. Well, a club.

Last Updated June 28, 2021

Brent Ozar

Cheers! Alright, you’re in. Here’s a direct zip file link to my SQL Server First Responder Kit (zip). It’s full of stuff to help make your SQL Server faster and more reliable. I’d suggest opening sp_Blitz.sql first in SSMS. Run that, and it creates the sp_Blitz stored proc – you can put it in any database you…

Ozar’s Hierarchy of Database Needs: a 6-Month DBA Training Plan

Last Updated July 10, 2019

Brent Ozar

Processes and Practices

You need to poop. Maybe not right now, but in general, you need to breathe, eat, drink, sleep, and poop. If you can’t do any of those things, then the rest of your needs will take a back seat until you can accomplish the basics. Psychology professor Abraham Maslow designed Maslow’s Hierarchy of Needs to…

Five Favorite Free SQL Server Downloads

Last Updated August 14, 2013

Brent Ozar

SQL Server

So you’re lazy and you’re company’s broke – what to do? Here’s my favorite free downloads to help manage SQL Server: Understand execution plans with SQL Sentry Plan Explorer – I dunno about you, but viewing execution plans in SQL Server Management Studio is a pain in my rear. The scrolling sucks, the cost numbers…

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

Last Updated July 28, 2019

Brent Ozar

SQL Server

SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow. Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there’s a much better tool, and it’s completely free. In this five minute tutorial video, I explain how to use sp_WhoIsActive from Adam…

Wait Stats

Last Updated November 15, 2017

Brent Ozar

Using Wait Stats to Find Why SQL Server is Slow Forget page life expectancy, buffer cache hit ratio, and disk queue length – those antiquated stats worked great for Grandpa, but it’s time to find an easier way to tune. Whenever SQL Server is running queries, it’s tracking how much time it spends waiting on…

Knowing the Relative Value of Databases

Last Updated February 9, 2017

Brent Ozar

Licensing, Processes and Practices, Virtualization

All databases are not created equal. Learn how to find greedy databases – ones that are using up more IO than others – and learn what options you have for reducing their loads.

Scaling SQL Server

Last Updated July 26, 2020

Brent Ozar

Scale Up or Scale Out? Scaling SQL Server I would like to scale up my coffee cup. Want your app to be able to handle more users? Here are tips, tricks, and links to comprehensive references on how to scale SQL Server– either Scale Up or Scale Out. Do You Really Have a Scale Problem? It…

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

Last Updated February 17, 2020

Brent Ozar Unlimited Team

Backup and Recovery

BACKUP LOG WITH TRUNCATE_ONLY is a dangerous command: it empties out the contents of your SQL Server’s transaction log without really backing it up. Database administrators sometimes run this command right before shrinking their log file with a DBCC SHRINKFILE command, thereby freeing up drive space. Why ‘truncate_only’ is not a recognized backup option. When…

Stop Shrinking Your Database Files. Seriously. Now.

Last Updated October 9, 2019

Brent Ozar

Production Database Administration

298

I had sworn to myself that if I saw one more helpful article about how to shrink your SQL Server database files with DBCC SHRINKFILE or how to back up your log with TRUNCATE_ONLY, I was going to write a rant about it. Epic Advice Fail SQL Server Magazine just tweeted about their latest article,…

Getting Help With A Slow Query

Last Updated October 21, 2017

Brent Ozar

Execution Plans

StackOverflow users often ask, “I’ve got this query that runs slow – can you help?” Here’s a few tips to get better, faster answers, including getting the execution plan and relevant Perfmon data.

SQL Server Database Performance Tuning

Last Updated February 23, 2021

Brent Ozar

You’re a developer, DBA, or sysadmin stuck with long running queries in SQL Server, and you need to do SQL Server performance tuning. I can help! I’m a consultant, and I do this for a living. I don’t keep anything secret – I’ll tell you how you can get started, or if you prefer, you…

SQLIO Tutorial: How to Test Disk Performance

Last Updated February 13, 2017

Brent Ozar

SQL Server, Storage

Storage is a black box, right? The SAN admins ask how much storage space you need, you tell them, and then they give it to you. They don’t tell you how fast (or slow) it is, they don’t know whether it meets your needs, and they probably don’t know where the bottlenecks are. It’s time…

SQL Server 2005 Setup Checklist Part 2: After The Install

Last Updated June 27, 2017

Brent Ozar

SQL Server

I’ve covered what needs to happen before you install SQL Server – now, let’s talk about what to do immediately after the setup finishes. Install not just the service packs, but also the cumulative updates. Starting with SQL Server 2005’s Service Pack 2, Microsoft releases hotfixes in cumulative packs. These updates do more than just…

Search Results for “sp_blitz”

Security Admins List

Sysadmins List

MSDB History Not Purged

Thanks for registering. You’re now in an elite club. Well, a club.

Ozar’s Hierarchy of Database Needs: a 6-Month DBA Training Plan

Five Favorite Free SQL Server Downloads

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

Wait Stats

Knowing the Relative Value of Databases

Scaling SQL Server

How to BACKUP LOG WITH TRUNCATE_ONLY in SQL Server 2008, R2, 2012, 2014, 2016, 2017, 2019

Stop Shrinking Your Database Files. Seriously. Now.

Getting Help With A Slow Query

SQL Server Database Performance Tuning

SQLIO Tutorial: How to Test Disk Performance

SQL Server 2005 Setup Checklist Part 2: After The Install

Hi! I’m Brent Ozar.

Save your cart?