Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


processor affinity for mssql instances

Posted on 2005-03-15
Medium Priority
Last Modified: 2006-11-17
while running multiple instances of mssql 2k on win2k3 is it possible allocate instances cpu-wise ?
if yes , then how is it done and what if there are more instances than no of cpu.
Question by:Toneys
1 Comment
LVL 15

Accepted Solution

mcmonap earned 500 total points
ID: 13543535
Hi Toneys,

I guess you could do this if you want,

1. open enterprise manager, right click the instance of SQL server you want to change select properties
2. select the processor tab, deselect the processors you do not want this instance to use.

If you have more instances than processors you could either get more processors or have the instances share processors.  I'm not sure how much benefit you will get from making these changes though.

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question