Session load


Job details

Name: Session load
Platform: Sqlserver
Category: Performance
Description: Shows the number of active sessions over time.
Long description: Shows the number of active sessions over time.
Version: 1.1
Default schedule: 0,10,20,30,40,50 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘1999′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
keep data for 5 Number of days to provide statistics for.

Job Summary

SELECT COUNT(*) FROM master.dbo.sysprocesses WHERE cmd != 'TASK MANAGER'

Technical Description

Dependencies

Reports and Presentations

Implementation Specifics

Report Templates and Output

Report Title Description Example Output
Session load Shows the number of total and active session over time. Graph of session numbers over historical dates.
Session history Presents average, max, and min session statistics. Data table with averages, maximums, and minimums of session counts.
Sessions per database Lists top databases by current session counts. Table with databases and their respective session counts.
Sessions per host Displays top hosts by current session counts. Table listing hosts and associated session counts.
Sessions per login Details top logins by current session counts. Table showing logins and their session numbers.
Current sessions Current session details for top active programs and users. Detailed table of current sessions by program, user, and host.

The job automates data collection and reporting processes critical for database performance monitoring, thus reducing the need for manual checks and enabling quick responsiveness to potential issues.