[Video] How to Capture Baselines with sp_BlitzFirst

Everybody tells you to capture baselines – but what exactly are you supposed to capture? Which Perfmon counters matter? How do you track which data files are growing, and which ones are slow? How can you track which queries are using the most resources?

All you have to do is install the free, open source sp_BlitzFirst and sp_BlitzCache from our First Responder Kit, create a database to hold your results (I like to call mine DBAtools), and then set up an Agent job to run it every 15 minutes:

I show you how to do it and query the baseline data in today’s webcast:

Previous Post
Should you run SSAS/SSIS/SSRS on the SQL Server?
Next Post
Building SQL ConstantCare® Version 2: Easy-to-Afford Monitoring

15 Comments. Leave new

  • Christopher Style
    February 15, 2019 9:44 am

    Ummmm, Brett… this really doesn’t work for SQL servers with a set of Trend Micro databases. Trend Micro overwhelms the results with useless crap that I can’t seem to filter out, no matter how I try. Too bad for me, I guess.

  • If I am logging this to tables the way you show does it automatically pull the expert mode data set?

  • Henrik Staun Poulsen
    February 19, 2019 6:04 am

    hi Brent,
    Does this work with Azure SQL DB?
    no, there is no SQL Agent, but Sp_BlitzFirst should work, so if I create a RunBook, will it work?

  • Dennis Anderson
    March 27, 2019 8:03 am

    If I want to pull all the data into a central repository using linked servers, how do I get around the issue of the xml datatype? I can’t query that across a linked server? The only way I know of is to create views on the tables, leaving out the xml columns. Also can the Power BI script be used against a centralized database?

    • Dennis – you’ll either need to exclude the XML data types, or cast them as nvarchar, or use a more ETL-focused tool like SSIS. About Power BI – yep!

  • Hey Brent!
    I have a SQL Server 2014 SP2 CU4 server with 48 cores and 1 TB of Ram.. sp_Blitzfirst has been running for 15 minutes… Is there something I need to do to get that fast return time?


  • Brent is there any way to put the output of running processes, as is seen when running manually, into an output table? Currently I am only seeing the capability to store stats for filestats, perfmon stats, wait stats, cache stats but not anything for the processes (queries) that are running at the start and end of the run.
    Many thanks.

  • Hi Brent , Do i need to create the database and all tables with column names manually to gather and save the info over time through SQL Job Agent (sp_BlitzFirst) ?


Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.