Update for Baseline Collector Solution (V1.2)

Still “just” bugfixes, but V2 is just around the corner! So Stay-tuned! Bigger update is coming very soon… 😉

Thank all of you for the feedbacks!

New features coming in  Baseline Collector Solution V2

  • Easier collector management with Central Configuration
  • More effective, re-worked sp_CollectFileInfo 😉

Download Comprehensive Baseline Collecting Solution V1.2

Change History

Changes in V1.2 – 2015.05

  • Support
    • Please notice: For BCS V1.* no new features are coming, only bugfixes!!!
  • BugFix
    • sp_CollectDatabaseInfo – table [database_info] collation_name data type is changed to VARCHAR(128) to allow NULL values in case of the database is not in ONLINE state or AUTO CLOSE option is ON.
    • sp_CollectTempDBUsage – no comment… just: “shame on me” :(

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 Uncategorized. Bookmark the permalink.

Leave a Reply

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