Does SQL 2000 use multiple processors for inserts?

That's the question
Hi
Never see it use more than one. Usually with Inserts, the disk subsystems
can not cope and not the processor.
Each client connection is capable of simultaneous inserts, but each
connection will not span multiple processors.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"hello" <hello@.discussions.microsoft.com> wrote in message
news:3A3D5594-8155-4178-A484-52C0B6A94328@.microsoft.com...
> That's the question
sql

Does SQL 2000 use multiple processors for inserts?

That's the questionHi
Never see it use more than one. Usually with Inserts, the disk subsystems
can not cope and not the processor.
Each client connection is capable of simultaneous inserts, but each
connection will not span multiple processors.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"hello" <hello@.discussions.microsoft.com> wrote in message
news:3A3D5594-8155-4178-A484-52C0B6A94328@.microsoft.com...
> That's the question

Does SQL 2000 use multiple processors for inserts?

That's the questionHi
Never see it use more than one. Usually with Inserts, the disk subsystems
can not cope and not the processor.
Each client connection is capable of simultaneous inserts, but each
connection will not span multiple processors.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"hello" <hello@.discussions.microsoft.com> wrote in message
news:3A3D5594-8155-4178-A484-52C0B6A94328@.microsoft.com...
> That's the question

Does MS SQL 2000 support multiple processors?

We are in the process of moving our SQL servers to a SAN
environment and decided to upgrade our servers to 4
processors. Therefore, does anyone know if MS SQL 2000
supports multiple processors?Depends on the edition. See BOL: Maximum Capacity Specifications for the
complete OS\Edition matrix. For four processors, you can use any of the
Windows Server OS editions and Standard or Enterprise Edition SQL Server
2000.
From the performance side, SQL does very well with multiple processors.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Cory" <crubicco@.yahoo.com> wrote in message
news:04ae01c3883d$882e63b0$a301280a@.phx.gbl...
> We are in the process of moving our SQL servers to a SAN
> environment and decided to upgrade our servers to 4
> processors. Therefore, does anyone know if MS SQL 2000
> supports multiple processors?