You can actually set SQL7 to run on a particular processor.
> I know for a fact that SQL 7 can take advantage multiple processors. You
> have to be careful though, I am not sure but you may have to get another
> license.
>
> Tim Heald
> ACP/CCFD
> Application Development
> www.schoollink.net
>
> -----Original Message-----
> From: John Innit [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 3:11 AM
> To: CF-Talk
> Subject: Re: Performance boost with Upgrade to dual processor ??
>
>
> is this true for SQL server too? can SQL Server be configured to utilize
> the extra CPU ?
>
>
> At 03:09 PM 4/24/2002, Douglas Brown wrote:
> >The answer is "no" the operating system determines the processor
> >usage. When processor 1 is all used up, then the OS instructs the
> >system to begin using both processors to carry the load. Only one
> >processor is used during minimal usage.
> >
> >
> >
> >
> >
> >
> >"Success is a journey, not a destination!!"
> >
> >
> >
> >Doug Brown
> >----- Original Message -----
> >From: "John Innit" <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Tuesday, April 23, 2002 11:14 PM
> >Subject: Performance boost with Upgrade to dual processor ??
> >
> >
> > > Running a IIS 5.0 / WIN2K Server and CF 4.5.1 on a P3 500 with
> >512KB RAM,
> > > our DB server is also a P3 500 with 512KB RAM running WIN2K and
> >SQL SERVER
> > > 2000.
> > >
> > > I'm thinking of upgrading to dual processors (another P3 500)
> >on both the
> > > web server and DB server and want to know if there is any way in
> >which I
> > > can maximize the performance boost. I heard that the extra
> >processor may or
> > > may not boost CF the web server performance, and alot depends on
> >how the
> > > application is designed. Is this true ? Is there any way I can
> >optimize my
> > > application and CF server to harness the extra benefits of the
> >new processor?
> > >
> > > I heard the the SQL server will definitely see a performance
> >boost but the
> > > CF server may or may not depending on how it was designed...
> > >
> > > any suggestions.
> > >
> > > Thanks.
> > >
> > >
> > >
> > >
> > >
> > >
> >__________________________________________________________________
> >____
> > > Signup for the Fusion Authority news alert and keep up with the
> >latest news in ColdFusion and related topics.
> >http://www.fusionauthority.com/signup.cfm
> > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > > Unsubscribe:
> >http://www.houseoffusion.com/index.cfm?sidebar=lists
> > >
> >
> >
>
>
______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
