An update of the original version of the server
Windows NT / Windows 2000
Most modern businesses use a relational database to store their data. SQL Server 2000 is a relational database system provided by Microsoft. Small businesses utilize SQL Server 2000 in small applications that run on a single server. SQL Server 2000 is also used in large organizations with thousands of concurrent users to run distributed applications.
SQL Server 2000 has many features that convince many businesses to use it for their programs. Because data is the most valuable asset of a 21st century business, backups of data are crucial. SQL Server 2000 provides a wizard for scheduling backups. There is also support for database replication from snapshots or transactions. For businesses with distributed applications the clustering feature is a lifesaver. The management console allows a database administrator to set up clusters of servers quickly. The console also simplifies the management of the servers in a cluster.
Performance in a database system is important. A database application’s throughput is reliant on the speed of the queries used in the app. SQL Server 2000 provides SQL Query Analyzer, a tool for debugging and optimizing SQL queries. Using SQL Query Analyzer a developer can determine the performance bottlenecks in queries and establish areas where optimization is required. SQL Server 2000 also has a self-tuning mechanism that is used to create indexes that are optimized for each user’s particular use case.