That's wrong man, This is off of msdn: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm l/megasrvs.asp
Here is the piece that pertains: Symmetric Multiprocessors SMP gives vertical growth from small processors to MegaServers by adding more processors, disks, and peripherals to a single system. Beyond a certain point, this growth involves replacing existing equipment with a different system model Symmetric multiprocessing (SMP) grows a server by adding multiple processors to a single shared memory. The system grows by adding memory, disks, network interfaces, and processors. SMP is the most popular way to scale beyond a single processor. The SMP software model, often called the shared memory model, runs a single copy of the operating system with application processes running as if they were on a single processor system. SMP systems are relatively easy to program. They also leverage the benefits of industry-standard software and hardware components. Microsoft Windows 2000 and Microsoft SQL Server 2000 are designed to scale well on SMP systems. They can use up to 32 processors for some applications but the practical limits for general-purpose use today are: Eight processors 32 gigabytes of main memory 10 TB of protected storage (300 36-GB disk drives configured as 60 hardware RAID sets and 10 logical volumes) 50,000 active clients accessing a SQL Server through the IIS Web server or some transaction monitor These are the maximum sizes Microsoft has seen. Typical large servers are half this size or less. With time, Microsoft SQL Server, Windows 2000, and hardware technology will evolve to support even larger configurations. Tim Heald ACP/CCFD Application Development www.schoollink.net -----Original Message----- From: Tim Heald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 3:12 AM To: CF-Talk Subject: RE: Performance boost with Upgrade to dual 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 > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
