Configure time based parameters configuration dialog box

Select MS SQL Server to run the km command on it

Select a regular expression from the regular expressions defined in the MS SQL server instance configuration for hostName in env envName dialog box to apply the time based parameters configuration.

Select the regular expressions from the drop-down list box and click Next. Selected MS SQL servers appear highlighted.

Next

Click to open Time parameters configuration for servers of host hostName in environment envName dialog box.

Cancel

Click to exit without saving the configuration.

'Long Running Transactions' criteria (min)

Specify the amount of time the transaction has been running before it is considered as a long running transaction. All long running transactions are reported by the Long Running Transactions parameter.

'SQL Agent Hung Jobs' criteria (min)

Specify the amount of time the job has been running before it is considered as hung job. All the hung jobs are reported by the SQL Agent Hung Jobs parameter.

'Idle Procs' criteria (min)

Specify the amount of time the process has not been consuming any resources before it is considered as idle process. All the idle processes are reported by the Idle Procs parameter.

'Number of Blocking Processes' criteria (min)

Specify the amount of time the process has been blocked by the blocking process before it is considered as blocking process. All the blocker processes are reported by the Number of Blocking Processes parameter

Accept

Click to save the configurations

Cancel

Click to exit without saving the configuration