processors replacement

Hi,
SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
memory (3G used for sql server). We're going to replace
these processors with the new, faster 4 processors. Is
there any known problem we can expect regarding starting
sql services and databases with new processors?
TIA
Arminarmin,
As long as Windows comes up, should be fine. ;-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
armin wrote:
> Hi,
> SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
> memory (3G used for sql server). We're going to replace
> these processors with the new, faster 4 processors. Is
> there any known problem we can expect regarding starting
> sql services and databases with new processors?
> TIA
> Armin|||Your execution plans are going to need updating. They are
developed using a combination of cpu, memory and disk
speed, so if one changes its going to effect the rest.
Its not a big job, just look up update statistics, then
watch your server fly...
Peter
"The best minds are not in government. If any were,
business would steal them away."
Ronald Reagan
>--Original Message--
>Hi,
>SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
>memory (3G used for sql server). We're going to replace
>these processors with the new, faster 4 processors. Is
>there any known problem we can expect regarding starting
>sql services and databases with new processors?
>TIA
>Armin
>.
>|||They have to shut down the server to add the upgrades and all execution
plans are lost when you stop sql server anyway. And the plans are not
directly related to disk speed at all. Even CPU and memory are things that
are taken into account at run time and not necessarily at compile time. A
complex plan will always have a single and a parallel plan created the first
time it is run. At run time it is decided based on how busy the cpu's are,
memory available, etc that determine if the single threaded plan is used or
a parallel plan and how many threads generated.
--
Andrew J. Kelly SQL MVP
"Peter The Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:766e01c494e9$304f2300$a301280a@.phx.gbl...
> Your execution plans are going to need updating. They are
> developed using a combination of cpu, memory and disk
> speed, so if one changes its going to effect the rest.
> Its not a big job, just look up update statistics, then
> watch your server fly...
> Peter
> "The best minds are not in government. If any were,
> business would steal them away."
> Ronald Reagan
>
> >--Original Message--
> >Hi,
> >
> >SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
> >memory (3G used for sql server). We're going to replace
> >these processors with the new, faster 4 processors. Is
> >there any known problem we can expect regarding starting
> >sql services and databases with new processors?
> >
> >TIA
> >
> >Armin
> >.
> >|||Thank you very much, to all of you!
If I unterstood complete discussion correctly, as soon as
NT comes up, I should let it fly?
BR
Armin
>--Original Message--
>armin,
>As long as Windows comes up, should be fine. ;-)
>Mark Allison, SQL Server MVP
>http://www.markallison.co.uk
>Looking for a SQL Server replication book?
>http://www.nwsu.com/0974973602m.html
>
>armin wrote:
>> Hi,
>> SQL Server 7.0 is running on WinNT 4.0, 4 processors 4G
>> memory (3G used for sql server). We're going to replace
>> these processors with the new, faster 4 processors. Is
>> there any known problem we can expect regarding
starting
>> sql services and databases with new processors?
>> TIA
>> Armin
>.
>sql