SQL Server 2000 Enterprise Edition (64-bit) Datasheet

Published: April 24, 2003
**
Download

Download64-bit_datasheet.doc
148 KB 1 min @ 28.8 Kbps
Microsoft Word file
**

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.

Product Highlights

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

Top of pageTop of page

Compatibility with Existing SQL Server Installations

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.

Easy Migration from a 32-Bit SQL Server 2000 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-Access Compatibility

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.

Top of pageTop of page

A Scalable Platform for Business Intelligence

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.

Top of pageTop of page

Support for High-Availability Configurations

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.

Top of pageTop of page

A Robust Platform for Server Consolidation

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).

Top of pageTop of page

The Choice for Your Enterprise Database Requirements

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.


Top of pageTop of page