Sunday, March 25, 2012

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

No comments:

Post a Comment