When will Microsoft offer a parallel version of Microsoft SQL Server that runs on multiple servers at the same time for automatic load balancing and scalability?
The next major release after Microsoft SQL Server 7.0 is planned to offer cluster-enabled scalability on MSCS clusters. It will use a scalable “shared nothing” architecture to spread a single database across multiple servers. Although this is an important direction for Microsoft SQL Server, it must be kept in perspective: It will only be needed by a small percent of customers. Cluster-enabled scalability will only be needed by extremely large enterprise applications which are (a) too large to run on a single high-end SMP server (for example, eight-processor SMP with 4 GB of RAM), and (b) cannot be partitioned to run on a distributed network using MTS.
Related Questions
- After upgrading SQL Server version 6.x databases to SQL Server 7.0 using the automatic configuration option, the resulting SQL Server 7.0 databases are smaller than their SQL Server 6.x counterparts. Does this mean that there was a problem with the upgrade?
- Do you offer a version of iMagic Inventory for use with Microsoft SQL Server?
- Are there issues with Microsoft Automatic Updates running at the same time?
