he Wait Statistics module collects key wait statistics from each managed server, saving them to the Collector.WaitStats table. 

The Collector.WaitStatsCurrent view shows the latest collection of wait stats data (from sys.dm_os_wait_stats), including the percentage of the WaitType for each collection period. 

Use the PercentResourceWaitTime column in Collector.WaitStats (or the Collector.WaitStatsCurrent view) to see the percentage of the WaitType for each collection period.  You can use this column as a basis for your custom alerts.  If a performance condition arises, a specific waitType is likely to increase in percentage from one collection to the next, so look for those increases.
 

Table

Collector.WaitStats

Holds the collected wait stats data pulled back from each server.
 
Column Type Description
ID bigint Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers.
WaitType nvarchar The name of the wait type.
WaitingTasksCT bigint Wait type count; the number of waits on this wait type.
MaxWaitTimeMS bigint The maximum wait time on this wait type.
ResourceWaitTimeMS bigint Resource wait time in milliseconds. Calculated as (wait time in ms) – (signal wait time in ms).
PercentResourceWaitTime decimal Percent of total waits.
 
For more information about wait types, see the TechNet article “SQL Server Delays Demystified” at https://technet.microsoft.com/en-us/magazine/hh781189.aspx
 

Views

Collector.WaitStatsCurrent

Provides the most recent collection of wait statistics results.

Each “Current” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Descr

Collector.WaitStatsPrevious

Provides the next-to-most recent collection of wait statistics results.

Each “Previous” view associated with a Collector table contains all (or nearly all) of the columns from the base table, plus a “ViewDesc” description column, and columns from dbo.Servers data:
 
  • ServerName
  • ServiceLevel
  • Version
  • Edition
  • Desc

Jobs

CollectorWaitStatsGet-GOLD

Calls the executable WaitStats.exe for all servers with ServiceLevel = ‘Gold’, to collect wait statistics.
 

CollectorWaitStatsGet-SILVER

Calls the executable WaitStats.exe for all servers with ServiceLevel = ‘Silver’, to collect wait statistics.
 

CollectorWaitStatsGet-BRONZE

Calls the executable WaitStats.exe for all servers with ServiceLevel = ‘Bronze’, to collect wait statistics.
 

Executables

WaitStats.exe

Performs the wait statistics collection for each managed SQL Server instance. Logs the results to the Collector.WaitStats table.

Input parameters:
  • $Query – This parameter refers to the service level that the collector should operate on. Examples: Gold, Silver, Bronze. For more information on this topic, see the article “Executables and Service Levels”.
Example execution:
C:\MinionByMidnightDBA\Collector\WaitStats.exe Gold


 
https://minionware.desk.com/customer/portal/articles/2378798-wait-statistics-module
http://www.MinionWare.net