|Name:||Sessions per database|
|Description:||This task returns aggregate performance statistics based on sessions connected to the SQL Server instance.|
|Long description:||This task returns aggregate performance statistics based on sys.dm_exec_sessions dynamic management view and sysprocesses view. The views contains one row per connection, and the lifetime of the rows are tied to connection itself. When a session is disconnected/terminated, the corresponding row are eliminated from this views which might produce inaccurate results if there are sessions disconnected between sampling of statistics by the dbWatch task.|
|Default schedule:||0,10,20,30,40,50 * * *|
|Requires engine install:||Yes|
|Compatibility tag:||[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)|
Thanks for your feedback.