You need to consider a few more things before you install SQL Server 2000 on any given computer. In most multi-SQL Server operations, the machine needs to participate in network security. An applications server such as SQL Server usually requires a large amount of resources exclusively available for its use. Also, appropriate permission sets need to be configured to ensure that sensitive data is not available where it shouldn't be. SQL Server 2000 as a ResourceParticipating as a network user, with access to resources through a login ID, is an important aspect of SQL Server. The service accounts that make up the database and agent engines are assigned a domain user account that will have administrative rights over the machine where it is installed. WARNING Sharing Machines You seldom want SQL Server to share a machine with other applications, and certainly a SQL Server should never share a machine with a security server such as a Windows 2000 or Windows NT Domain controller. SQL Server 2000 Back Office IntegrationSQL Server's capability to store data and handle scheduled procedures makes it an important portion of the Microsoft Server family. SQL Server can be used as the data support and back end of web sites running on IIS. SQL Server stores the data gathered by SMS in an enterprise infrastructure analysis. SQL Server can even supply information to the email system through Exchange. SQL Server by the NumbersA number of sources have provided impressive measurements of the capabilities of SQL Server 2000. Here are some of the impressive numbers:
Other statistics available that compare SQL Server to other products will change on a regular basis. Suffice it to say that Microsoft SQL Server is equal if not superior to other database engines in its class. The following list provides some of the more important figures to keep in mind as you prepare any implementation:
As you can see from the list of limitations, SQL Server can be used as the data storage software for virtually any size data structure. |