SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Baseline Collector Solution V2

By Robert Virag,

Collecting baseline data is essential. In my previous article I introduced my Free Comprehensive Baseline Collector Solution. I gave an overview about:

  • Why baseline data is essential
  • The rules I follow during developing the solution
  • The collectors themselves, how the collectors work, what data are collected 

I am glad to introduce the new version of the Baseline Collector Solution. The new version does not only differ in bugfixes from the previous version (of course it contains all bugfixes which are in V1.2), but there are also some very cool and useful new features and impovements in BCS V2.

In this article I am introducing two of them:

  • Reworked - sp_CollectFileInfo
  • Central Configuration 

To check all the improvements and features please see the full Change History at the end of the article.

The Rules

The most important thing to understand is the rules, so let's review them:

  1. Collect only raw data 
    The Solution collects and stores raw data. No calculations, no analysis.
  2. Collect as little data as possible:
    Collecting baseline continuously requires a lot of storage space. So I tried to collect as little data as possible.
  3. Be as flexible as possible:
    The Solution has its own standard, but it is still easily customizable. It tries to achieve a 'golden mean' between being extremely standard and being extremely customizable.

The Solution

One of the most important changes is that SQL Server 2005 is not supported anymore, only SQL Server 2008 and above. The reason behind this decision is that I wanted the Solution to be more accurate, so it was necessary to change the DATETIME data type to DATETIME2.

sp_CollectFileInfo - Reworked

The first version of the Solution works with two types of data concerning the volatility of the data: static and dynamic

Static: Data are considered to be static when they change very rarely, like instance configurations. The collectors which collect static data are the following: sp_CollectInstanceData, sp_CollectConfigData and sp_CollectDatabaseInfo These collectors collect and store data in a very effective way by only storing the data which are changed compared to the data stored or the data which are missing for any reason. So only the changed or missing data are collected and stored even if the collectors run every hour or so.

Dynamic: Data are considered to be dynamic when they change very often, like IO virtual file statistics or the wait statistics. Dynamic data can be extremely volatile like performance counters. These data need to be collected frequently to have understandable, analysable, straight and valid trends. The collectors which collect dynamic data are the following: sp_CollectIOVFStats, sp_PerfmonData, sp_CollectWaitStats* and sp_CollectTempDBUsage

*Although wait statistics don't need to be collected very frequently, however this is not because they are not dynamic, but because of the nature of the data, the way we analyze them!

I spent some time thinking this problem over and trying to recategorize the data collected according to the rules followed. I tried to find some area to improve. Finally, I managed to identify a third type. Let's call it semi-dynamic.

Semi-dynamic: Data are considered to be semi-dynamic when they change sometimes or even very often, but they are not necessarily needed every single time. It is possible to specify some kind of thresholds which allow you to decide whether the data are needed or not.

sp_CollectFileInfo has been totally reworked in a way that it can handle database files' data as semi-dynamic data based on different kind of thresholds. It got 3+1 new parameters which allow you to control this behaviour.

@CollectionTimeThreshold: With the @ColletionTimeThreshold parameter you can specify a time threshold in hours. If it is used, data collection is only performed on those data (database files) whose time of the last collection date reaches the threshold specified. 

@ChangedSizeThreshold: With the @ChangedSizeThreshold parameter you can specify the threshold for the file size change in percentage. If it is used, data collection is only performed on those data (database files) whose size changed at least by the specified percentage.

@ChangedSpaceUsedThreshold: With the @ChangedSpaceUsedThreshold parameter you can specify the threshold for the used space size change in percentage. If it is used, data collection is only performed on those data (database files) whose used space size changed at least by the specified percentage.
@CSUTExcludeLog: It works only in conjunction with the @ChangedSpaceUsedThreshold parameter. With the @CSUTExcludeLog parameter ON you can exclude the log files from the data collection. It is a really useful option, since the actual space used in the case of log files is very varying.

You can think of these @%Threshold parameters as switches that you can turn on or off. They are not mutually exclusive, so you can turn on only just one of them or even all of them.

For example, you would like to collect database file data only for those files whose size are changed by 25% and you would also like to have database file data at least every 3 days. The only thing you need to do in this case is to configure the parameter @ChangedSizeThreshold to 25 and @CollectionTimeThreshold to 72.

Please notice that regardless of the state of the switches, data collection is always performed on database files whose physical location were changed since their last collection time.

Four indicator columns were also added to the [dbo].[file_info] and the [dbo].[ts_file_info] tables which let you know what triggered the data collection.

  • ic_cst: indicator column for parameter @ChangedSizeThreshold. NULL means that the switch is disabled, so the condition are ignored, 0 means that it is enabled but the condition were not met, 1 means that it is enabled and the condition were met
  • ic_csut: indicator column for parameter @ChangedSpaceUsedThreshold. NULL means that the switch is disabled, so the condition are ignored, 0 means that it is enabled but the condition were not met, 1 means that it is enabled and the condition were met
  • ic_ctt:  indicator column for parameter @CollectionTimeThreshold. NULL means that the switch is disabled, so the condition are ignored, 0 means that it is enabled but the condition were not met, 1 means that it is enabled and the condition were met
  • ic_path: indicator column for physical location change. 1 means that the file physical location was changed, 0 means that it wasn't.

Please notice that there is no indicator column for parameter @CSUTExcludeLog.

Central Configuration

Besides efficiency (using less storage) the other important improvement of BCS V2 is convenience, i.e. 'ease of use'. So let's talk about the second best feature of BCS V2, which is the Central Configuration Feature.

Every collector has a new parameter called @CustomConfig. This new parameter refers to a predefined configuraion of the specific collector which is stored in table [dbo].[bcs_config] using column [config_name]. Every collector has a default configuration which is named by its name. These default rows cannot be deleted from table [dbo].[bcs_config] and the config names of the default configurations cannot be modified. So basically the default configurations store the default values of the parameters of the collectors. 

You can easily create a new set of predefined values (configuration) for any of the collectors. For this there is only one single puzzle you need to know. Every configuration has a type based on its supported collector. Here you can see the types of the collectors:

Here you can see the parameters supported by the types.

There is one additional type as you can see, this is type 0 which is a general type. Custom configurations defined with type 0 can support every collector. Keep in mind that the collectors don't check the type of the provided custom config. Supportability means that the columns (~parameters) can only be modified if the type of the custom config supports the collector, so the collector has that specific parameter.

In addition, you don't need to maintain table [dbo].[bcs_config] manually using insert, update, delete statements. You can use sp_configureBCS stored procedure.

Syntax:

Creating a new custom config
sp_ConfigureBCS @Action = {'new' | 'create' | 'insert'}
,@NewConfigName = 'config_name'
[ ,<config_parameter_specifications> ]
[ ,<collector_parameter_specifications> ] 


Duplicating an existing custom config
sp_ConfigureBCS @Action = {'clone' | 'duplicate' | 'copy'}
,@ConfigName = 'existing_config_name'
[, @NewConfigName = 'new_config_name']
[ ,<config_parameter_specifications> ]
[ ,<collector_parameter_specifications> ]


Modifying custom config
sp_ConfigureBCS @Action = {'update' | 'modify'}
,@ConfigName = 'existing_config_name'
[ ,@NewConfigName = 'new_config_name' ]
[ ,<config_parameter_specification> ]
[ ,<collector_parameter_specifications> ]


Deleting custom config
sp_ConfigureBCS @Action = {'delete' | 'del' | 'remove' | 'drop'}
,@ConfigName = 'existing_config_name'


Listing custom configs
sp_ConfigureBCS @Action = 'list'


Getting help
sp_ConfigureBCS @Action = 'help'


<config_parameter_specifications>::=
[ ,@ConfigType = {0 | 1 | 2 | 3 | 4 | 5 | 6} ]
[ ,@ConfigDescription = 'config_description' ]

<collector_parameter_specifications>::=
[ ,@Retention = retention ]
[ ,@LogInfo = loginfo ]
[ ,@DestTable = 'desttable' ]
[ ,@DestSchema = 'destschema' ]
[ ,@TSMode = tsmode ]
[ ,@EmptyTSTable = emptytstable ]
[ ,@CollectingInterval = collectinginterval ]
[ ,@Sampleinterval = sampleinterval ]
[ ,@MeasuringInterval = measuringinterval ]
[ ,@ResetWaitStats = resetwaitstats ]
[ ,@BypassNonActiveSrvConfError = bypassnonactivesrvconferror ]
[ ,@CollectionTimeThreshold = collectiontimethreshold ]
[ ,@ChangedSizeThreshold = changedsizethreshold ]
[ ,@ChangedSpaceUsedThreshold = changedspaceusedthreshold ]
[ ,@CSUTExcludeLog = csutexcludelog ]

If you would like to create a new custom config you have two options. You can create a new config or you can create a copy from one of the existing configs. In the first case, every parameter which is not explicitly provided will get a default value of the specified type. If you don't specify the type it will be type 0. In case of duplicating one of the existing config the parameters which are not explicitly provided will get the value of the config to be duplicated. If you don't provide the new config name it will get 'cl_' prefix plus the original config's name

As you can see in the syntax description, you can also list, modify or delete a config. 

Please test your custom configs carefully, since there is not any parameter verification implemented in sp_ConfigureBCS yet.

So far that's all. This is Baseline Collector Solution V2. I hope you will all find the new version useful.

Future plans

Creating stored procedure for collecting Memory Usage Data is still on my list so as the set of stored procedures for analyzing and evaluating the data collected (Analyzing Part of the Solution).

Please report me every bug you may find so I can fix it as soon as I can.

Ideas are always welcome!

Keep checking the updates on SQLApprentice.netIf you have any remarks, questions or any ideas, please feel free to contact me, leave a comment or drop me a mail /robertATsqlapprenticeDOTnet/.

Download Baseline Collector Solution V2

Baseline Collector Solution V2 

Change History

/*********************************************************************************************

Written by Robert Virag
Comprehensive Baseline Collecting Solution
Change History
Changes in V2 - 2015.08.14
<>Features
 () Central Configuration
   - Schema: Table [dbo].[bcs_config]
   - Collectors: @CustomConfig parameter
   - Procedure: [dbo].[sp_ConfigureBCS]
<>Improvements: 
  () Version compatibility: 2008+ 
    - 2005 is not supported anymore; DATETIME => DATETIME2)
  () [dbo].[sp_CollectFileInfo]: Redesigned - Semi-Dynamic Collector
    - Switches: 
    - @ChangedSizeThreshold 
    - @ChangedSpaceUsedThreshold /@CSUTExcludeLog/
    - @CollectionTimeThreshold
    - built-in: ChangedPhysicalLocation
  () [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 
       - based on the collected data type /static-dynamic/
    - 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
----
For scheduling the collectors with agent jobs, Ola Hallengren's code is used
with his permission.
http://ola.hallengren.com/license.html
License:
Copyright (c) 2014 Robert Virag | SQLApprentice.net
Permission is hereby granted, free of charge, to any person 
obtaining a copy of this software and associated documentation 
files (the “Software”), to deal in the Software without 
restriction, including without limitation the rights to use, 
copy, modify, merge, publish, distribute, sublicense, and/or 
sell copies of the Software, and to permit persons to whom the 
Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be 
included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, 
EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES 
OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. 
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, 
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR 
OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR 
THE USE OR OTHER DEALINGS IN THE SOFTWARE.
*********************************************************************************************/
 
Total article views: 4865 | Views in the last 30 days: 26
 
Related Articles
ARTICLE

How to Install and Configure Baseline Collector Solution V2

In this article I go through the installation and configuration processes of my Baseline Collector S...

ARTICLE

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chan...

ARTICLE

Baselines

It can be hard to analyze performance without a baseline. This week, Steve Jones asks how you might ...

BLOG

Baseline SQL Server with SQL Sentry Performance Advisor

Baselines can be any set of metrics that have been recorded to give you an understanding of what is ...

FORUM

TSQL copy data in weekdays

TSQL copy data in weekdays

Tags
baseline    
 
Contribute