Microsoft SQL Server and Microsoft Windows NT Server run on 2-way to 32-way SMP hardware systems. The most common SMP hardware systems are 2-way and 4-way. Microsoft SQL Server has demonstrated excellent SMP scalability, both on audited benchmarks and in real applications.
Microsoft SQL Server scalability, version 6.5 | ||||
Technologies | Active | Throughput | Database | |
SMP, failover, | 5,000 per SMP | 3,600 transactions per minute 10 million transactions per day | 200 GB | |
Today, a single 4-processor node can support up to 5,000 concurrent users accessing a Microsoft SQL Server storing billions of records on a 200 GB disk array. These servers are capable of processing more than 10 million business transactions per day. In the future, the combination of faster processors, more processors, and software improvements could more than double the rated performance of Microsoft SQL Server on SMP hardware systems.