Update for Baseline Collector Solution (V1.1)

This update “is just” a bunch of bugfixes plus a new collector: sp_CollectInstanceInfo

Stay-tuned! Bigger update is coming very soon… 😉

Download Comprehensive Baseline Collecting Solution V1.1

Change History

Changes in V1.1 – 2015.04

  • Collectors
    • New collector: sp_CollectInstanceInfo
  • New Schedules added
    • marked with ‘*’ below
  • BugFix
    • sp_CollectDatabaseInfo – SQL2014
    • @Retention = NULL
    • CollectingInterval/SampleInterval/MeasuringInterval type, possible value range
    • AI_SQLTRACE_INCREMENTAL_FLUSH_SLEEP
    • Job output file name (@OutputFile0X)
    • sp_CollectWaitStats – @ResetWaitStats = 0 If @MeasuringInterval is specified

V1 Original Release – 2014.09

—//—

Collectors:

sp_CollectConfigData
sp_CollectDatabaseInfo
sp_CollectFileInfo
sp_CollectIOVFStats
sp_CollectPerfmonData
sp_CollectTempDBUsage
sp_CollectWaitStats
*sp_CollectInstanceInfo

Schedules:

baseline – daily – at 2359PM
baseline – daily – at 2357PM
baseline – daily – at 2355PM
*baseline – daily – at 2353PM
*baseline – daily – at 2351PM

*baseline – daily – every 5 mins
*baseline – daily – every 5 mins – BT/6AM-7PM/
baseline – daily – every 10 mins
baseline – daily – every 10 mins – BT/6AM-7PM/
baseline – daily – every 15 mins
baseline – daily – every 15 mins – BT/6AM-7PM/
*baseline – daily – every 30 mins
*baseline – daily – every 30 mins – BT/6AM-7PM/
baseline – daily – every 1 hour
baseline – daily – every 1 hour – BT/6AM-7PM/
*baseline – daily – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
baseline – daily – every 6 hours /6AM/12PM/6PM/12AM/
baseline – daily – every 8 hours /6AM/2PM/10PM/
baseline – daily – evey 12 hours /6AM/6PM/

*baseline – weekday – every 5 mins
*baseline – weekday – every 5 mins – BT/6AM-7PM/
baseline – weekday – every 10 mins
baseline – weekday – every 10 mins – BT/6AM-7PM/
baseline – weekday – every 15 mins
baseline – weekday – every 15 mins – BT/6AM-7PM/
*baseline – weekday – every 30 mins
*baseline – weekday – every 30 mins – BT/6AM-7PM/
baseline – weekday – every 1 hour
baseline – weekday – every 1 hour – BT/6AM-7PM/
*baseline – weekday – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
baseline – weekday – every 6 hours /6AM/12PM/6PM/12AM/
baseline – weekday – every 8 hours /6AM/2PM/10PM/
baseline – weekday – evey 12 hours /6AM/6PM/

*baseline – weekend – every 5 mins
baseline – weekend – every 10 mins
baseline – weekend – every 15 mins
baseline – weekend – every 30 mins
baseline – weekend – every 1 hour
baseline – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
baseline – weekend – every 6 hours /6AM/12PM/6PM/12AM/
baseline – weekend – every 8 hours /6AM/2PM/10PM/
baseline – weekend – evey 12 hours /6AM/6PM/

 

This entry was posted in baseline, Script. Bookmark the permalink.

2 Responses to Update for Baseline Collector Solution (V1.1)

  1. Jay Madsen says:

    Excellent collector, thanks for posting.

    I had a bug with the CollectDatabaseInfo SP.

    I had several offline DBs on my server and a few of them had NULL entries in sys.databases for the collation setting. This caused the SP to fail when inserting into the database_info table.

    I of course could either change the database_info table to accept NULL in the collation field or add a isnull to the SP inserts.

Leave a Reply

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