Baseline Colletor Solution Change Log

V2.0.4 – 2015.09.25

  • BugFixes
    • Correcting the SetupScript to run when SQLCMD mode is enabled in SSMS
    • Baseline – Output File Cleanup job’s step is not empty anymore when @OutputFileDirectory is NULL
    • Minor fixes (correcting typos)
  • Improvements
    • New option added for trying to locate the Instance Error Log Directory and configure it for @OutputFileDirectory (SQL 2008 / 2008R2 / 2012)
    • Additional instuctions added to the SetupScript

V2.0.3 – 2015.09.22

  • BugFixes
    • SetupScript: Edition check added before Configuring schedules for jobs
    • Correction for supporting case sensitivity instances
    • [dbo].[sp_CollectFileInfo]: QUOTENAME() added to dynamic statements calling databases

V2.0.2 – 2015.09.19

  • BugFixes
    • SetupLog: Instancename ‘MSSQLSERVER’ in case of Default install
    • [dbo].[sp_CollectFileInfo]: #most_recent_file_info – TSMode table was not used in TSMode

V2.0.1 – 2015.09.09

  • BugFixes
    • SetupLog: missing ‘GO’ after sp_CollectInstanceInfo code
  • Improvements
    • SetupLog: BCS Version Info, Basic Environment Info and Executer Info added

V2 – 2015.08.14

  • Features
    • Central Configuration
  • Improvements
    • Version compatibility: 2008+
    • [dbo].[sp_CollectFileInfo]: Redesigned – Semi-Dynamic Collector
    • [dbo].[sp_CollectInstanceInfo]: collects trace flag status info
    • [dbo].[sp_CollectPerfmonData]: skip ‘WAITFOR DELAY @sample_interval’ for the last loop
    • [dbo].[sp_CollectTempDBUsage]: skip ‘WAITFOR DELAY @sample_interval’ for the last loop
    • Help info: Dynamic type and default values (Default CustomConfig)!
    • New Jobs
      • Baseline – Collect InstanceInfo/ConfigData/DatabaseInfo/FileInfo/WaitStats
      • Baseline – Output File Cleanup
      • with recommended schedules
    • Setup logging
  • New Schedules added
    • () baseline – weekend – every 30 mins
    • () baseline – weekend – every 30 mins – BT/6AM-7PM/
    • () baseline – weekend – every 1 hour – BT/6AM-7PM/
    • () baseline – every 4 weeks – 1week – every 30 mins
    • () baseline – every 4 weeks – 1week – every 30 mins – BT/6AM-7PM/
    • () baseline – every 4 weeks – 1week – every 1 hour
    • () baseline – every 4 weeks – 1week – every 1 hour – BT/6AM-7PM/
    • () baseline – every 4 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 4 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 4 weeks – 1week – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 4 weeks – 1week – evey 12 hours /6AM/6PM/
    • () baseline – every 4 weeks – weekdays – every 30 mins
    • () baseline – every 4 weeks – weekdays – every 30 mins – BT/6AM-7PM/
    • () baseline – every 4 weeks – weekdays – every 1 hour
    • () baseline – every 4 weeks – weekdays – every 1 hour – BT/6AM-7PM/
    • () baseline – every 4 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 4 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 4 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 4 weeks – weekdays – evey 12 hours /6AM/6PM/
    • () baseline – every 4 weeks – weekend – every 30 mins
    • () baseline – every 4 weeks – weekend – every 30 mins – BT/6AM-7PM/
    • () baseline – every 4 weeks – weekend – every 1 hour
    • () baseline – every 4 weeks – weekend – every 1 hour – BT/6AM-7PM/
    • () baseline – every 4 weeks – weekend – every 3 hours  12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 4 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 4 weeks – weekend – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 4 weeks – weekend – evey 12 hours /6AM/6PM/
    • () baseline – every 12 weeks – 1week – every 30 mins
    • () baseline – every 12 weeks – 1week – every 30 mins – BT/6AM-7PM/
    • () baseline – every 12 weeks – 1week – every 1 hour
    • () baseline – every 12 weeks – 1week – every 1 hour – BT/6AM-7PM/
    • () baseline – every 12 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 12 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 12 weeks – 1week – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 12 weeks – 1week – evey 12 hours /6AM/6PM/
    • () baseline – every 12 weeks – weekdays – every 30 mins
    • () baseline – every 12 weeks – weekdays – every 30 mins – BT/6AM-7PM/
    • () baseline – every 12 weeks – weekdays – every 1 hour
    • () baseline – every 12 weeks – weekdays – every 1 hour – BT/6AM-7PM/
    • () baseline – every 12 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 12 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 12 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 12 weeks – weekdays – evey 12 hours /6AM/6PM/
    • () baseline – every 12 weeks – weekend – every 30 mins
    • () baseline – every 12 weeks – weekend – every 30 mins – BT/6AM-7PM/
    • () baseline – every 12 weeks – weekend – every 1 hour
    • () baseline – every 12 weeks – weekend – every 1 hour – BT/6AM-7PM/
    • () baseline – every 12 weeks – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 12 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 12 weeks – weekend – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 12 weeks – weekend – evey 12 hours /6AM/6PM/
    • () baseline – every 24 weeks – 1week – every 30 mins
    • () baseline – every 24 weeks – 1week – every 30 mins – BT/6AM-7PM/
    • () baseline – every 24 weeks – 1week – every 1 hour
    • () baseline – every 24 weeks – 1week – every 1 hour – BT/6AM-7PM/
    • () baseline – every 24 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 24 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 24 weeks – 1week – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 24 weeks – 1week – evey 12 hours /6AM/6PM/
    • () baseline – every 24 weeks – weekdays – every 30 mins
    • () baseline – every 24 weeks – weekdays – every 30 mins – BT/6AM-7PM/
    • () baseline – every 24 weeks – weekdays – every 1 hour
    • () baseline – every 24 weeks – weekdays – every 1 hour – BT/6AM-7PM/
    • () baseline – every 24 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 24 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 24 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 24 weeks – weekdays – evey 12 hours /6AM/6PM/
    • () baseline – every 24 weeks – weekend – every 30 mins
    • () baseline – every 24 weeks – weekend – every 30 mins – BT/6AM-7PM/
    • () baseline – every 24 weeks – weekend – every 1 hour
    • () baseline – every 24 weeks – weekend – every 1 hour – BT/6AM-7PM/
    • () baseline – every 24 weeks – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
    • () baseline – every 24 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
    • () baseline – every 24 weeks – weekend – every 8 hours /6AM/2PM/10PM/
    • () baseline – every 24 weeks – weekend – evey 12 hours /6AM/6PM/

V1.2 – 2015.05

  • Bug Fixes

V1.1 – 2015.04

  • Bug Fixes
  • New Collector: sp_CollectInstanceInfo
  • Additional Schedules*

V1 Original Release – 2014.09.13

* – Added in V1.1
** – Added in V2

Tables:

  • * [dbo].[instance_info]
  • [dbo].[configuration_data]
  • [dbo].[database_info]
  • [dbo].[file_info]
  • [dbo].[iovf_stats]
  • [dbo].[perfmon_data]
  • [dbo].[tempdb_usage]
  • [dbo].[wait_stats]
  • [dbo].[ts_file_info]
  • [dbo].[ts_iovf_stats]
  • [dbo].[ts_perfmon_data]
  • [dbo].[ts_tempdb_usage]
  • [dbo].[ts_wait_stats]
  • [dbo].[filter_database_file]
  • [dbo].[filter_performance_counters]
  • [dbo].[filter_wait_types]
  • ** [dbo].[bcs_config]

Collectors:

  • * sp_CollectInstanceInfo
  • sp_CollectConfigData
  • sp_CollectDatabaseInfo
  • sp_CollectFileInfo
  • sp_CollectIOVFStats
  • sp_CollectPerfmonData
  • sp_CollectTempDBUsage
  • sp_CollectWaitStats

Functions/Procedures:

  • ** sp_ConfigureBCS

Jobs:

  • ** Baseline – Collect InstanceInfo/ConfigData/DatabaseInfo/FileInfo/WaitStats
    • SCHEDULE[baseline – daily – every 6 hours /6AM/12PM/6PM/12AM/]
    • STEPS:
      • Collect InstanceInfo
      • Collect ConfigData
      • Collect DatabaseInfo
      • Collect FileInfo
      • Collect WaitStats with @ResetWaitStats=1
      • JobCheck
  • Baseline – CollectIOVFStats
    • SCHEDULE[baseline – every 4 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/]
  • Baseline – CollectPerfmonData
    • SCHEDULE[baseline – every 4 weeks – 1week – every 1 hour – BT/6AM-7PM/]
  • Baseline – CollectTempDBUsage
    • SCHEDULE[baseline – every 4 weeks – 1week – every 1 hour – BT/6AM-7PM/]
  • ** Baseline – Output File Cleanup
    • SCHEDULE[baseline – daily – at 2351PM]

Schedules:

  • baseline – daily – at 2359PM
  • baseline – daily – at 2355PM
  • * baseline – daily – at 2351PM
  • * 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 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 30 mins
  • ** baseline – weekend – every 30 mins – BT/6AM-7PM/
  • baseline – weekend – every 1 hour
  • ** baseline – weekend – every 1 hour – BT/6AM-7PM/
  • 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/
  • ** baseline – every 4 weeks – 1week – every 30 mins
  • ** baseline – every 4 weeks – 1week – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 4 weeks – 1week – every 1 hour
  • ** baseline – every 4 weeks – 1week – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 4 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 4 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 4 weeks – 1week – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 4 weeks – 1week – evey 12 hours /6AM/6PM/
  • ** baseline – every 4 weeks – weekdays – every 30 mins
  • ** baseline – every 4 weeks – weekdays – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 4 weeks – weekdays – every 1 hour
  • ** baseline – every 4 weeks – weekdays – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 4 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 4 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 4 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 4 weeks – weekdays – evey 12 hours /6AM/6PM/
  • ** baseline – every 4 weeks – weekend – every 30 mins
  • ** baseline – every 4 weeks – weekend – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 4 weeks – weekend – every 1 hour
  • ** baseline – every 4 weeks – weekend – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 4 weeks – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 4 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 4 weeks – weekend – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 4 weeks – weekend – evey 12 hours /6AM/6PM/
  • ** baseline – every 12 weeks – 1week – every 30 mins
  • ** baseline – every 12 weeks – 1week – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 12 weeks – 1week – every 1 hour
  • ** baseline – every 12 weeks – 1week – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 12 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 12 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 12 weeks – 1week – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 12 weeks – 1week – evey 12 hours /6AM/6PM/
  • ** baseline – every 12 weeks – weekdays – every 30 mins
  • ** baseline – every 12 weeks – weekdays – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 12 weeks – weekdays – every 1 hour
  • ** baseline – every 12 weeks – weekdays – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 12 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 12 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 12 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 12 weeks – weekdays – evey 12 hours /6AM/6PM/
  • ** baseline – every 12 weeks – weekend – every 30 mins
  • ** baseline – every 12 weeks – weekend – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 12 weeks – weekend – every 1 hour
  • ** baseline – every 12 weeks – weekend – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 12 weeks – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 12 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 12 weeks – weekend – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 12 weeks – weekend – evey 12 hours /6AM/6PM/
  • ** baseline – every 24 weeks – 1week – every 30 mins
  • ** baseline – every 24 weeks – 1week – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 24 weeks – 1week – every 1 hour
  • ** baseline – every 24 weeks – 1week – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 24 weeks – 1week – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 24 weeks – 1week – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 24 weeks – 1week – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 24 weeks – 1week – evey 12 hours /6AM/6PM/
  • ** baseline – every 24 weeks – weekdays – every 30 mins
  • ** baseline – every 24 weeks – weekdays – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 24 weeks – weekdays – every 1 hour
  • ** baseline – every 24 weeks – weekdays – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 24 weeks – weekdays – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 24 weeks – weekdays – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 24 weeks – weekdays – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 24 weeks – weekdays – evey 12 hours /6AM/6PM/
  • ** baseline – every 24 weeks – weekend – every 30 mins
  • ** baseline – every 24 weeks – weekend – every 30 mins – BT/6AM-7PM/
  • ** baseline – every 24 weeks – weekend – every 1 hour
  • ** baseline – every 24 weeks – weekend – every 1 hour – BT/6AM-7PM/
  • ** baseline – every 24 weeks – weekend – every 3 hours /12AM/3AM/6AM/9AM/12PM/3PM/6PM/9PM/
  • ** baseline – every 24 weeks – weekend – every 6 hours /6AM/12PM/6PM/12AM/
  • ** baseline – every 24 weeks – weekend – every 8 hours /6AM/2PM/10PM/
  • ** baseline – every 24 weeks – weekend – evey 12 hours /6AM/6PM/

Tested: 2008 / 2008 R2 / 2012 / 2014

Summary:
Collect SQL Server Baseline (Raw) Data

Comments are closed.