Home > IT Answers > Microsoft Windows > Adding processor to SQL Server 2005
Db23
290 pts.
 Adding processor to SQL Server 2005
CPU, Processors, SQL Server 2005
Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won't encounter any problem after doing this? Thanks.

Software/Hardware used:
ASKED: June 25, 2009  3:45 AM
UPDATED: July 2, 2009  5:08 PM
RELATED QUESTIONS
Answer Wiki:
No, there shouldn't be any problems. Just don't forget to get a new CPU license if needed.
Last Wiki Answer Submitted:  June 25, 2009  5:03 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

If you are going from a single CPU to multiple CPU’s you should consider what parallelism will do to your existing queries.

There is an excellent article on the topic here: http://sqlserverpedia.com/blog/sql-server-bloggers/more-parallelism/

MrMiguel
 10 pts.