SQL Server 2000 Limitations


  • Identify and manage environment restrictions.

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 Resource

Participating 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 Integration

SQL 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 Numbers

A number of sources have provided impressive measurements of the capabilities of SQL Server 2000. Here are some of the impressive numbers:

  • SQL Server allows maximized database capacity ”approximately 1,000,000 terabytes. With this, you could store the name and address information for the entire population of the planet in a single database!

  • Up to 16 simultaneous instances of SQL Server can be running.

  • SQL Server supports up to 64 gigabytes of physical RAM.

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:

  • Databases per instance of SQL Server: 32,767

  • Procedure nesting Levels: 32

  • Columns per table: 1,024

  • Columns per index or key: 16 with total byte size under 900 bytes

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.



MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 228

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net