Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

[SQL Server 2016 CTP 2.4 - Query Store] Functionality to collect the information of queries which are not finished

By the effect of query plan change, sometimes the query execution time could become too long to wait. DBAs are requred to cancel them. After cancelation, DBAs are also required to investigate the reason why it took so long time. However there is no information in query store database for unfinished queries.

2 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base