MSSQL 2008: Collect DB Active Requests count

Microsoft.SQLServer.2008.Database.ActiveRequests.Collection (Rule)

SQL 2008 DBs Active Requests performance collection rule

Knowledge Base article:

Summary

Active requests count for SQL 2008 DB

Shows requests count that is executing within SQL Database at the moment

More information can be found under the sys.dm_exec_requests (Transact-SQL) documentation

http://go.microsoft.com/fwlink/?LinkId=789155

Overrideable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Interval (seconds)	The recurring interval of time in seconds in which to run the workflow.	900
Synchronization Time	The synchronization time specified by using a 24-hour format. May be omitted.	00:02
Timeout (seconds)	Specifies the time the workflow is allowed to run before being closed and marked as failed.	300

Element properties:

Target	Microsoft.SQLServer.2008.Database
Category	PerformanceCollection
Enabled	True
Alert Generate	False
Remotable	True

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.SQLServer.2008.Database.ActiveRequests.DataSourceMapped	Microsoft.SQLServer.SQLProbeAccount
WriteToDB	WriteAction	Microsoft.SystemCenter.CollectPerformanceData	Default
WriteToDW	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData	Default

Source Code:

<Rule ID="Microsoft.SQLServer.2008.Database.ActiveRequests.Collection" Enabled="true" Target="SQL2008Core!Microsoft.SQLServer.2008.Database">

  <Category>PerformanceCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Microsoft.SQLServer.2008.Database.ActiveRequests.DataSourceMapped" RunAs="SQL!Microsoft.SQLServer.SQLProbeAccount">

      <IntervalSeconds>900</IntervalSeconds>

      <TimeoutSeconds>300</TimeoutSeconds>

      <SyncTime/>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="WriteToDB" TypeID="SC!Microsoft.SystemCenter.CollectPerformanceData"/>

    <WriteAction ID="WriteToDW" TypeID="SCDW!Microsoft.SystemCenter.DataWarehouse.PublishPerformanceData"/>

  </WriteActions>

</Rule>