Post reply

2012 Std Instance CPU usage on 40 core servr

  • May 30, 2014 at 4:25 am

    #293837

    I have multiple instances of SQL 2012 Std Edition on a 40 physical core server.

    What I have done is the use the Process - SQLServr -% Processor time Stat and divided by 16 ( the max number of Cores Std ed. can use) as a instance level measure. I also use processor object stats to show how busy the server is.

    Does anyone have any other suggestions on how to represent the servers CPU utilization?

  • May 30, 2014 at 9:02 am

    #1717819

    You might want to limit the instances to individual cores by using the affinity mask configuration item. This should prevent the threads being bounced all over the place, and mixing in with the other instances.

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

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