Help Center > > User Guide> Microsoft SQL Server Database Management (Standard Edition)> CloudDBA> Session

Session

Updated at:May 14, 2020 GMT+08:00

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.

Prerequisites

You have logged in to the DAS console.

Procedure

  1. On the top menu bar, choose CloudDBA > Session.
  2. On the displayed page, view the number of current instance sessions, execution duration of sessions, session list, and slow session list.

    • In the upper left area, the chart shows the number of global sessions which is not changed based on the search criteria.
    • In the upper right area, the chart shows the query results based on your search criteria.
    • Kill a session.

      Locate the abnormal session and click Kill Session to restore the database.

    • Query specified sessions by filters.

      You can combine filters query data such as user and database.

    • Set slow SQL threshold.

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel