Monitoring

This chapter describes monitoring section of Querona Administrative Portal.

Users with VIEW SERVER STATE permission granted are able to see monitoring information for all users. Regular users will only see monitoring information regarding objects they already have access rights granted.

List of available options:

• Active statements

• Client connections

• Running jobs

• Alerts

Logs and diagnostic tools (audit logs, statement history, execution-plan cache, and the low-level server logs) now live under Logging & diagnostics.

Most of this information is also available in SQL through dynamic management views — for example sys.dm_exec_sessions, sys.dm_exec_requests and sys.dm_exec_connections — and a running statement can be cancelled with KILL. See the individual pages below.