sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored procedure:

@return_store_config : show or hide the Query Store configuration window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_forced_plans : show or hide the Forced Query Store plans window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_top_duration : show or hide the Top queries based on avg. duration window.  A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_top_cpu : show or hide the Top queries based on avg. CPU time window. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_top_log_read : show or hide the Top queries based on avg. logical read IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_top_log_write : show or hide the Top queries based on avg. logical write IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

@return_top_phys_read : show or hide the Top queries based on avg. physical read IO. A ‘0’ indicates not returning the window, a ‘1’ returns the window. ‘1’ is set as the default. (optional)

You can download the lates version of sp_WhatsupQueryStore from the GitHub page at //github.com/Evdlaar/sp_WhatsupQueryStore.

35 comments to “sp_WhatsupQueryStore version 1.1 released”

You can leave a reply or Trackback this post.
  1. Thanks a bunch for sharing this with all people you really realize what you are speaking
    about! Bookmarked. Please also discuss with my web site =).
    We may have a link change arrangement between us

  2. Смотреть порно видео онлайн ИзменаПолнометражный на 24video задаром.
    Добавляйте в закладки, дабы не затерять и
    обладать под рукой исчерпывающий доступ к
    качественному порно видео.
    На Ебалке снедать масса роликов на тему русское порно пикап, и
    вы можете понаблюдать за процессом снятия
    и траха незнакомой девушки с самого азбука и до финального камшота.
    В нашем порно тубе вы сможетеИ мы не рекомендуем
    пробовать отыскивать порно на других сайтах, потому что
    лучше чем у нас вы не найдете.
    Порно с сюжетом, полнометражные порно фильмы с русским
    переводом и. Порно Нарезки Онлайн!!
    Горячие XXX ролики доступны для всех!
    Санса Старка – старшая дочка
    в семье Старков, бросила собственный дом в Винтерфелле,
    дабы отойти в королевство и прихватить обязанности отца.
    261. Чтобы получить руку Лагерты,
    ему нужно было преодолеть медведя и огромного пса, которые охраняли дом его возлюбленной.
    Это уже другой эпизод пародийного сериала Игры Престолов.

    Первая серия пародии эпического
    фильма Игры Престолов. Серси чрезвычайно
    хочет отнять его первобытность и обучить
    трахаться. Король Роберт посещает Винтерфелла с женой Серси.
    Она крайне боится за свое будущность.
    Она единственная кто выжил на этом мистическом острове.

    Она понимает, что решительно скоро она
    потеряет свою безобидность и скорее итого это будет принц Джофри.
    По нашему мнению, китч является частью массовой культуры, да не тождествен ей.
    Регулярно это делают не все, да у
    многих уписывать на компьютере папочка с заветными файлами.

    Этот третий эпизод будет о Джоне Сноу, о внебрачном сыне Нэда Старка.
    Далеко не любой фотохостинг изображений позволял загружать такие файлы, в том числе
    из-за будет большого их объема. Джон встречает ее и они
    начинают симпатизировать товарищ другу.
    В комических текстах обыгрывается умение попугаев заявлять и открывать секреты хозяев.

  3. Link exchange is nothing else however it is just placing the other person’s weblog link
    on your page at appropriate place and other person will also do similar for
    you.

  4. Howdy! I’m at work browsing your blog from my new iphone!
    Just wanted to say I love reading through your blog and look forward to all your posts!
    Carry on the fantastic work!

  5. My brother recommended I would possibly like this website.

    He was once totally right. This submit actually made my day.
    You cann’t imagine just how so much time I had spent for this information!
    Thank you!

  6. fantastic issues altogether, you simply won a new reader.
    What may you recommend about your publish that you just made a few days ago?
    Any positive?

  7. I like the helpful info you supply for your articles.

    I will bookmark your blog and test again right here regularly.
    I am reasonably sure I’ll be told a lot of new stuff right
    right here! Best of luck for the following!

  8. Nice post. I used to be checking constantly this weblog and I am impressed!

    Extremely useful info particularly the remaining phase :)
    I care for such info much. I used to be looking for this certain info for a long time.

    Thanks and good luck.

  9. Hi there,
    Thank you so much for the post you do and also I like your
    post, Are you looking for Buy White Bali Online in the whole USA?
    We are providing Buy Yellow Vietnam Capsules , Yellow Vietnam Kratom , Buy White Bali Online
    , White Bali , Buy White Sumatra Kratom , Buy White Thai Kratom , White Horn Kratom ,
    White Borneo Kratom Capsule the well price and our services are very fast.

    Click here for Contact +1 818-533-8070

  10. Fantastic website. A lot of useful information here. I am sending it to a few pals ans also sharing in delicious.
    And naturally, thanks on your sweat!

  11. With every thing which seems to be building throughout this area,
    many of your opinions are actually somewhat refreshing.

    On the other hand, I beg yor pardon, but I do not subscribe to your entire idea, all be it
    refreshing nonne the less. It looks to us that your opinions are generally not
    totally rationalized annd in fact you are generally your self not entirely certain of the assertion. In any case
    I did take pleasure in looking att it.

  12. Kristian Livolsi, Growth Mindset, BUSINESS GROWTH MINDSET, ENTREPRENEUR, Speaker, THINCLAB,
    KRISTIAN LIVOLSI ADELAIDE, Purpose, Leadership, Failure, Resilience, Mindset, viagra, sex,
    money, porn, boobs, dick, cunt

  13. fantastic issues altogether, you jst received a brand new reader.
    What would you recommend in regards to your ppst that you made a few days in the past?
    Any positive?

  14. One thing I’ve noticed is the fact there are plenty
    off common myths regarding the financial institutions intentions any time talkng about home foreclosure.
    One fantasy in particular is the fact thaat the
    bank prefers to haave your house. The bank wants your cash, not the home.
    They want thhe bucks they loaned you having interest. Preventing the bank is only going to draw any foreclosed summary.

    Thanks for your article.

  15. certainly like your web site but you have to take a look at the spelling on quite a few of
    your posts. Several of them are rife with spelling issues
    and I find it very bothersome to inform the reality nevertheless I’ll definitely come
    again again.

  16. Kristian Livolsi, Growth Mindset, BUSINESS GROWTH MINDSET,
    ENTREPRENEUR, Speaker, THINCLAB, KRISTIAN LIVOLSI ADELAIDE, Purpose,
    Leadership, Failure, Resilience, Mindset

  17. I’m impressed, I have to admit. Rarely do I encounter a blog
    that’s equally educative and amusing, and without a doubt, you’ve hit
    the nail on the head. The issue is an issue that too few folks are speaking intelligently about.
    I’m very happy I stumbled across this in my hunt for something concerning this.

  18. great points altogether, you simply received
    a emblem new reader. What might you suggest about your
    post that you simply made some days ago?

    Any sure?

  19. My brother recommended I might like this blog.
    He was totally right. This submit actually made my day.
    You can not imagine simply how a lot time I had spent for this information! Thanks!

  20. Hi there! Do you know if they make any plugins to help with SEO?
    I’m trying to get my blog to rank for some targeted keywords but I’m
    not seeing very good results. If you know of any please
    share. Thank you!

Write a Reply or Comment

Your email address will not be published.