Post reply

Resource Governor Pools

  • May 11, 2011 at 11:23 pm

    #72274

    Comments posted to this topic are about the item Resource Governor Pools

  • May 12, 2011 at 12:37 am

    #1323490

    I really like this feature which was introduced in SQL 2008.

    For my work I created a little Excel sheet I like to use to calculate these MIN and MAX values.

    If you're interested you can download the sheet at Resource Governor Pool Calculator[/url]. Comments are appreciated 😉

  • May 12, 2011 at 5:51 am

    #1323594

    This is a good question. I don't see this feature used on any of the servers I manage.

    M&M

  • May 12, 2011 at 6:35 am

    #1323614

    I started using this feature due to consolidation projects to make sure machines have the same resources before consolidation.

  • May 12, 2011 at 6:42 am

    #1323615

    Steve - Another great question. I have used several CPU resource alocation products. They all require that the Min cpu for all groups adds up to 100% or less. 😉

  • May 12, 2011 at 7:27 am

    #1323648

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 12, 2011 at 7:35 am

    #1323656

    Another nice easy one. Thanks.

    Tom

  • May 12, 2011 at 8:12 am

    #1323685

    Thanks for an easy one, my brain is tired this morning.

    Great question!

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • May 12, 2011 at 8:31 am

    #1323700

    sanderstad (5/12/2011)

    I really like this feature which was introduced in SQL 2008.

    For my work I created a little Excel sheet I like to use to calculate these MIN and MAX values.

    If you're interested you can download the sheet at Resource Governor Pool Calculator[/url]. Comments are appreciated 😉

    Nice calculator for those of us challenged by simple math. I like the warning that says the MIN is greater than 100%. Maybe add a running total of available MIN or a message stating that you are at zero available. I already modified my copy 🙂

    (A15 changed to) =IF(SUM(B2:B13)>100,"MIN IS GREATER THAN 100%",IF(SUM(B2:B13)=100,"MIN IS NOW AT 100%",""))

    (A16)AVAILABLE MIN

    (C16)=SUM(100-SUM(B2:B13))

    Thanks for sharing it!

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • May 12, 2011 at 9:22 am

    #1323747

    Glad you liked the question. Easy question if you know the min issue, otherwise, hope you learned something.

  • May 12, 2011 at 12:20 pm

    #1323903

    good question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 12, 2011 at 2:44 pm

    #1323976

    Nice question, thanks!

  • March 16, 2012 at 3:40 pm

    #1460797

    Great and interesting question on the new features.

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply