June 11, 2003 at 9:58 am
Hi, My company has just upgraded there server to have dual processors.
We are running SQL 7.0 SP4 and I wondered if I needed to adjust anything to compliment the new upgrade.
Also does it mean I will have to recompile all my stored procedures to create new plans etc??
Thanks in advance
Scott
June 11, 2003 at 10:48 am
Not sure you need to change anything. Was this a same server upgrade? AFAIK if Windows sees 2 CPUs, then SQL will.
Steve Jones
June 11, 2003 at 12:16 pm
yep..same server.so far everything is running fine. Wasn't sure if the recompile would be a good moved as maybe the excution plans would change with faster processing.
Though i'm happy to let it run its course.
Thanks for your time on this
Scott
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply