-
Notifications
You must be signed in to change notification settings - Fork 1
/
Baseline with [sp_BlitzFirst].sql
24 lines (18 loc) · 1.2 KB
/
Baseline with [sp_BlitzFirst].sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-- https://www.brentozar.com/askbrent/
-- Collect Data using below code
EXEC master..sp_BlitzFirst
@OutputDatabaseName = 'DBA',
@OutputSchemaName = 'dbo',
@OutputTableName = 'BlitzFirst', -- the quick diagnosis result set goes here
@OutputTableNameFileStats = 'BlitzFirst_FileStats',
@OutputTableNamePerfmonStats = 'BlitzFirst_PerfmonStats',
@OutputTableNameWaitStats = 'BlitzFirst_WaitStats',
@OutputTableNameBlitzCache = 'BlitzCache',
@OutputTableNameBlitzWho = 'BlitzWho',
@OutputTableRetentionDays = 90;
EXEC master..sp_BlitzFirst @Help = 1
-- Fetch stats As of Date
-- sp_BlitzFirst will look in the output table for all results within 15 minutes of that time, and return them in chronological order.
EXEC sp_BlitzFirst @AsOf = '2015-02-23 18:45', @OutputDatabaseName = 'DBAtools', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzFirstResults'
-- Customized
EXEC sp_BlitzFirst @AsOf = '2019-02-20 03:00', @OutputDatabaseName = 'DBA', @OutputSchemaName = 'dbo', @OutputTableName = 'BlitzFirst', @OutputTableNameFileStats = 'BlitzFirst_FileStats', @OutputTableNamePerfmonStats = 'BlitzFirst_PerfmonStats', @OutputTableNameWaitStats = 'BlitzFirst_WaitStats', @OutputTableNameBlitzCache = 'BlitzCache'