Post reply

Can we do databasewise CPU / memory allocation in SQL 2008 R2 Enterprise edition

  • February 14, 2011 at 1:14 am

    #246541

    I have one simple question Can we do databasewise CPU / memory allocation in SQL 2008 R2 Enterprise edition

  • February 14, 2011 at 1:27 am

    #1286321

    No. There's resource governor, but it just controls query memory and cpu, not the buffer pool.

    If it's important, install separate instances and configure memory and CPU for them

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 17, 2011 at 5:02 am

    #1288145

    HI Please read the attachment and know about the reasource coverner .

    That will be usfull to configure the memory with various count.

    Ragadrs

    Mike

Viewing 3 posts - 1 through 2 (of 2 total)

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