Home > IT Answers > SQL Server > Adding processor to SQL Server 2005
Db23
230 pts.
0
Q:
Adding processor to SQL Server 2005
SQL Server 2005, Processors, CPU
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.
ASKED: Jun 25 2009  3:45 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
No, there shouldn't be any problems. Just don't forget to get a new CPU license if needed.
Last Answered: Jun 25 2009  5:03 AM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

MrMiguel   10 pts.  |   Jul 2 2009  5:08PM GMT

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: <a href="http://sqlserverpedia.com/blog/sql-server-bloggers/more-parallelism/" title="http://sqlserverpedia.com/blog/sql-server-bloggers/more-parallelism/" target="_blank">http://sqlserverpedia.com/blog/sql-serve…</a>

 
0