[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

8 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.

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

    Reply
  • 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?

    Reply
  • 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?

    Reply
    • 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!

      Reply

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.

Menu
{"cart_token":"","hash":"","cart_data":""}