Post reply

Resource Governor

  • May 7, 2012 at 6:58 am

    #260524

    i have an marketing account , i want that marketing people only can consume max 25% CPU and 30% Memory.

    i have created the resource pool and set above value , i also created the work group for that but i dint know

    how can i associate marketing login with this pool

    Please help

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • May 7, 2012 at 7:16 am

    #1484056

    You need to create a classifier function that classifies that login (based on any attribute of the login) and returns the workload group name. Then you need to alter resource govenor to register the classifier function

    See ALTER RESOURCE GOVERNOR in BoL

    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

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

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