Help Center> Data Admin Service> User Guide> Microsoft SQL Server DB Instance Management (Standard Edition)> CloudDBA> Real-Time Sessions
View PDF

Real-Time Sessions

Scenarios

View the running duration and status of SQL statements online to detect and handle abnormal processes in a timely manner to ensure that databases run smoothly.

Procedure

  1. On the top menu bar, choose CloudDBA > Real-Time Sessions.
  2. On the displayed page, view the running sessions, session execution duration, session list, and slow sessions.

    • In the upper left area, the chart shows the number of global sessions, which keeps the same as the search criteria change.
    • In the upper right area, the graph shows the query results based on your search criteria.
    • Kill a session.

      Select an abnormal session and click Kill to kill it so that the database can recover.

    • Query specified sessions by filters.

      Search for sessions by user, host, or database. The two search boxes are associated.

    • Set slow SQL threshold.

      Set a slow session threshold and click the refreshing button to filter the slow sessions that exceed this threshold.

Parent topic: CloudDBA