intro on sp_blitz by brent ozar
TRANSCRIPT
By Nicholas Gianadda
Professional Association for SQL Server
Tear into SQL Server with Brent Ozar’s sp_Blitz
How Did You
get HERE?
WHAT
CAN DO FOR
WHY
SHOULD ADOPT
THE
THEY NEED TO
TO TAKE
Stored Procedure
CAN DO FORDrop Table
SHOULD ADOPT
Select * from
UpdateDELETE
TO
GOGRANT Execute
What is Sp_Blitz
sp_Blitz is a Microsoft SQL Server instance health
script create by Brent Ozar. It uses system views,
DMVs and other state tracking tables to diagnose
common problems with configuration, security and
performance.
Your SQL Server isn’t
going to maintain itself
Maintenance on a SQL
server will help your systems
remain fast and secure
So, what makes
sp_Blitz so GREAT?
There are many tools out there that
can show you diagnostic
information about your SQL server.
Sp_Blitz takes this concept one
step further by including priorities to
clue you in to which items you
should focus on and direct links to
articles on www.brentozar.com that
explain the issue in great detail and
shows you how to resolve it!
What does it look like?
Or This
Why should I use it?
• One time checkup
• Trending your server
• Finding Security flaws
• Great Articles and
Videos to explain the
issues
Now What? I love what I found and I would like to receive this info weekly!!!
• Setup sp_Blitz as a SQL Job
• For emails, use the following parameters:
@EmailRecipients VARCHAR(MAX) = NULL
@EmailProfile sysname = NULL
• Log to a table, use the following parameters:
@OutputDatabaseName NVARCHAR(128) = NULL
@OutputSchemaName NVARCHAR(256) = NULL
@OutputTableName NVARCHAR(256) = NULL
Now What? I love what I found and I would like to receive this info weekly!!!
• Setup sp_Blitz as a SQL Job
• For emails, use the following parameters:
@EmailRecipients VARCHAR(MAX) = NULL
@EmailProfile sysname = NULL
• Log to a table, use the following parameters:
@OutputDatabaseName NVARCHAR(128) = NULL
@OutputSchemaName NVARCHAR(256) = NULL
@OutputTableName NVARCHAR(256) = NULL
What else can I do?
• There are tons of options for keeping an eye on
your server and digging into problems, Here are
a few of my favorites
SQLjobviz
• Visually
review the
history of
your SQL
jobs to see
when they
run and if
they were
successful
SQL Sentry Plan Explorer
• Additional
tool to quickly
identify and
help solve
issues with
your queries