Scale the management of critical business data to new heights. Manage and analyze large amounts of data to grow your competitive advantage and enhance your business agility. Do all this and more on the new 64-bit database platform from Microsoft, built and optimized for a new class of server technology.
Microsoft SQL Server™ 2000 Enterprise Edition (64-bit) offers a complete database and analysis platform for next-generation data warehousing, e-commerce, and line-of-business applications running on Itanium-based servers. SQL Server 2000 Enterprise Edition (64-bit) dramatically reduces the time required to scale databases to run on 64-bit platforms.
Optimized to run on Itanium-based servers and Microsoft Windows Server™ 2003, SQL Server 2000 Enterprise Edition (64-bit) delivers exceptional performance, reliability, and scalability; easy migration; and total cost of ownership (TCO) advantages for today's most demanding enterprise workloads.
Built to take advantage of hardware enhancements of the new breed of 64-bit servers, SQL Server 2000 Enterprise Edition (64-bit) offers higher levels of single-system scalability (scale-up) for the most memory-intensive data applications.
No longer bound by the 32-bit memory limit of four gigabytes (GB), SQL Server 2000 (64-bit) is able to perform complex queries on large data sets without performance loss. Direct utilization of additional memory is made available to the system to use for essential database resources in order to increase throughput and performance. By expanding the headroom necessary to access large amounts of data and to support large numbers of concurrent database users and client applications, SQL Server 2000 (64-bit) enables new levels of scalability for enterprise applications
SQL Server 2000 Enterprise Edition (64-bit) ships a 64-bit database server, a 64-bit server agent, and a 64-bit analysis server with online analytical processing (OLAP) and data mining. These components of SQL Server 2000 Enterprise Edition (64-bit) are code compatible with the 32-bit version of SQL Server 2000, making it easy to integrate a 64-bit server with other SQL Server 2000 (32-bit) database servers.
For database management and administration, 32-bit clients and SQL Server tools such as SQL Server Enterprise Manager and SQL Query Analyzer are easily used to remotely manage a SQL Server 2000 Enterprise Edition (64-bit) database.
By maintaining the same on-disk format on both 32-bit and 64-bit platforms, database administrators are able to protect key database investments made previously on a 32-bit server, easily moving user databases over to the new platform with minimal conversion effort. Migration is as easy as detaching the 32-bit database using a system-supplied stored procedure, transferring the user database to the 64-bit server's disk sub-system, and attaching it to the 64-bit database server, again using a system-supplied stored procedure.
Client applications that currently access SQL Server 2000 (32-bit) are able to easily connect to and access SQL Server 2000 (64-bit) without changes to application code. SQL Server 2000 (64-bit) supports client–access technology such as Microsoft ActiveX® Data Objects (ADO) and OLE DB, and maintains complete Transact-SQL code compatibility with the 32-bit version.
Aggregating data acquired from multiple sources and adding them to the data warehouse is critical for providing enterprises with the ability to answer business analysis questions. With the ability of SQL Server 2000 (64-bit) to address additional memory on a single 64-bit server, complex dimension structures can now be stored in memory to analyze a large amount of data. Cube processing and cube querying are also enhanced by access to larger memory resources for caching, faster processing, and deeper analysis.
SQL Server 2000 (64-bit) supports up to eight nodes in a failover cluster, enabling more complex high availability configurations. By allowing other 64-bit servers to back up critical applications in the event of planned or unplanned downtime, business operations are more protected and business applications are continuously available.
With the significant increase in memory capacity on 64-bit systems, enterprises now have an enhanced platform to consolidate their databases and database servers, requiring fewer machines to serve larger amounts of data. The ability of 64-bit hardware to support multiple processors also enables organizations to consolidate applications on fewer physical machines, each supported by SQL Server 2000 (64-bit).
SQL Server 2000 Enterprise Edition (64-bit) scales to meet the demanding requirements of today's enterprises. Capable of addressing complex computations involving massive amounts of data processing, from data warehouse applications to natural science simulation applications, SQL Server 2000 Enterprise Edition (64-bit) provides the data management horsepower necessary for high-end enterprise applications.
You now have the choice to implement your enterprise applications on SQL Server 2000 Enterprise Edition (64-bit), providing better performance and total cost of ownership compared to Unix-based database offerings. With database sizes rapidly increasing, SQL Server 2000 (64-bit) helps you to build and sustain a strategic advantage by efficiently managing your corporate data assets and keeping your company agile and responsive in today's competitive market.