Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!

qs_db_dashboard

Release notes:

  • Forced execution plan overview removed Instead you should use sp_WhatsupQueryStore to quickly analyse forced plans by running EXEC sp_WhatsupQueryStore @dbname = ‘your database’, @return_forced_plans = 1.

    You can download sp_WhatsupQueryStore through GitHub at //github.com/Evdlaar/sp_WhatsupQueryStore.

  • Added Queries with multiple plans performance chart. This chart, unlike the other ones, uses a logarithmic scale to improve readability when query duration between plans have large difference between durations.
  • Removed unused datasets.
  • Changed date/time format on x-axis in charts to exclude the date and only show time.
  • Modified queries to avoid potential locking situations.

Give it a try by downloading the file through it’s GitHub page: //github.com/Evdlaar/QueryStoreDashboard

88 comments to “Query Store Database Dashboard v1.3 released!”

You can leave a reply or Trackback this post.
  1. obviously like your website however you need to check the spelling on quite a few of your posts.

    Many of them are rife with spelling problems and I find it very troublesome to tell the
    truth nevertheless I will definitely come again again.

  2. I just like the helpful information you provide for your articles.
    I will bookmark your blog and test again here regularly. I’m somewhat sure I’ll be told lots of new stuff right right here!
    Good luck for the next!

  3. What i do not understood is in truth how you are no longer really a lot more smartly-favored than you may
    be now. You’re very intelligent. You realize thus considerably in terms of this subject,
    made me for my part believe it from so many numerous angles.
    Its like men and women don’t seem to be fascinated until it is one thing to do with Woman gaga!

    Your personal stuffs nice. At all times care for it up!

  4. I do not know whether it’s just me or if perhaps everyone else encountering issues with your site.
    It appears as if some of the written text in your content are running off the screen. Can someone else
    please provide feedback and let me know if this is happening to them as well?
    This might be a problem with my web browser because I’ve had this happen previously.
    Cheers

  5. I do not know whether it’s just me or if perhaps everybody else encountering issues with your site.
    It appears like some of the written text in your posts are running off the screen. Can somebody
    else please provide feedback and let me know if this
    is happening to them as well? This might be a
    issue with my internet browser because I’ve had this happen previously.
    Kudos

  6. A fascinating discussion is definitely worth
    comment. I think that you should publish more about this subject matter, it may not be a taboo subject but generally folks don’t speak
    about these topics. To the next! Many thanks!!

  7. First off I would like to say terrific blog! I had a quick question that I’d like
    to ask if you don’t mind. I was curious to find out how you center yourself and clear your mind before writing.
    I’ve had a hard time clearing my mind in getting my ideas out there.
    I truly do take pleasure in writing however it just seems like the first 10 to 15
    minutes are generally wasted just trying to figure
    out how to begin. Any recommendations or tips? Thank you!

  8. An interesting discussion is worth comment. I think that you should publish
    more about this subject, it may not be a taboo subject but usually people don’t
    speak about these issues. To the next! Many thanks!!

  9. I do not even know how I finished up right here, however I assumed this post was good.
    I don’t realize who you are however certainly you are going to a famous blogger in case you aren’t already.
    Cheers!

  10. What i don’t realize is in fact how you’re not actually a
    lot more neatly-favored than you might be right now.
    You are very intelligent. You know thus considerably relating to this subject,
    produced me personally believe it from so many varied angles.
    Its like women and men don’t seem to be involved unless it’s something
    to accomplish with Lady gaga! Your personal
    stuffs nice. At all times handle it up!

  11. whoah this blog is fantastic i like reading your articles.
    Keep up the good work! You recognize, many persons are searching round for this info,
    you could help them greatly.

  12. Hey There. I found your blog the use of msn. This is a very well written article.
    I will be sure to bookmark it and come back to read more of your useful info.
    Thank you for the post. I will definitely return.

  13. Asking questions are really pleasant thing if you are not understanding
    something entirely, except this piece of writing offers pleasant understanding
    yet.

  14. For most recent information you have to go to see world wide web
    and on web I found this website as a finest web
    page for most up-to-date updates.

  15. What i do not realize is in fact how you’re no longer really much more neatly-appreciated
    than you might be now. You are so intelligent. You
    realize therefore significantly relating to this topic,
    made me for my part imagine it from so many varied angles.
    Its like men and women are not fascinated except it is one thing to accomplish with Woman gaga!
    Your individual stuffs great. All the time maintain it
    up!

  16. I believe what you published made a lot of sense.
    But, what about this? what if you were to create a killer title?
    I mean, I don’t want to tell you how to run your website, however what if you added something
    to maybe grab folk’s attention? I mean Query Store Database Dashboard v1.3
    released! – DotNine is kinda plain. You could look at Yahoo’s
    home page and watch how they create article titles to get people to
    click. You might add a related video or a pic or two to get people excited about
    what you’ve got to say. In my opinion, it could bring your posts a little livelier.

  17. Hello to every one, for the reason that I am really keen of reading this weblog’s post to be updated regularly.

    It contains nice material.

  18. If some one desires expert view regarding blogging and site-building
    afterward i propose him/her to pay a quick visit this blog, Keep up the
    nice job.

  19. whoah this weblog is magnificent i really like reading your posts.
    Keep up the great work! You recognize, lots of individuals
    are hunting around for this information, you can aid them greatly.

  20. Thanks for another magnificent article. Where else may anyone get that kind of info in such a perfect way
    of writing? I’ve a presentation subsequent week, and I’m on the search for such information.

  21. I know this web site presents quality dependent articles
    or reviews and extra data, is there any other site which gives these kinds of data in quality?

  22. I don’t even know the way I stopped up right
    here, however I thought this publish was great. I don’t recognize who you might be but definitely you are going to a well-known blogger if you are not
    already. Cheers!

  23. you are in point of fact a excellent webmaster.
    The web site loading pace is amazing. It kind of feels that you’re doing any unique trick.

    Moreover, The contents are masterpiece. you’ve performed a fantastic
    task in this subject!

  24. Thanks for any other great post. The place else may
    anybody get that kind of information in such an ideal means
    of writing? I’ve a presentation subsequent week, and I’m at the look for such information.

  25. Attractive section of content. I just stumbled upon your website and in accession capital to assert that I get actually enjoyed account your blog posts.
    Anyway I’ll be subscribing to your augment and even I achievement you access
    consistently quickly.

  26. Please let me know if you’re looking for a writer for your
    blog. You have some really good articles and I think I would be a good asset.

    If you ever want to take some of the load off, I’d love to write some material for your blog in exchange for a link back to
    mine. Please send me an email if interested. Thanks!

  27. I was recommended this web site through my cousin. I’m now not sure whether or not
    this publish is written via him as nobody else know such distinct approximately my
    trouble. You are incredible! Thank you!

  28. What i do not realize is if truth be told how you are now
    not really much more well-appreciated than you might be now.

    You are very intelligent. You realize therefore significantly in the case of this
    subject, made me in my view consider it from a lot of various angles.

    Its like women and men aren’t involved until it’s
    one thing to accomplish with Lady gaga! Your personal stuffs outstanding.
    At all times maintain it up!

  29. Attractive section of content. I just stumbled upon your website and in accession capital to assert that I get actually
    enjoyed account your blog posts. Anyway I will be subscribing to your feeds
    and even I achievement you access consistently quickly.

  30. certainly like your web-site however you need
    to take a look at the spelling on quite a few of your
    posts. Many of them are rife with spelling problems and I in finding it very
    troublesome to tell the truth on the other hand I’ll certainly come
    again again.

  31. important review. Moreover visit my site to enjoy slot via pulsa.
    Fantastic web page has received level of popularity via judi slot gaming persons in Dalam negri.
    Right now there are a lot of intriguing promos cleaning soap
    join at this moment.

  32. fascinating review. As well visit that site make use of situs slot
    online. This website has received acceptance from slot machine game game playing participants in Negara sendiri.
    Presently there are a lot of captivating promos should anyone ever join right
    this moment.

  33. appealing review. Additionally visit the particular site to experience judi slot online.
    These pages has received acceptance received from agen slot deposit
    pulsa gambling house both males and females in Indonesia.
    Certainly, there tend to be many fantastic promos in case you
    join at present.

  34. When someone writes an paragraph he/she keeps the thought of a user in his/her mind
    that how a user can understand it. Thus that’s why this paragraph is amazing.
    Thanks!

Write a Reply or Comment

Your email address will not be published.