When it comes to database deployments, much of the focus is on large-scale enterprise-level systems. However, there are many organizations that have smaller databases ranging from under 500 megabytes to 10 gigabytes. These smaller deployments have their own unique considerations and requirements. In this article, we will explore the key concepts and ideas for deploying small to medium databases with Microsoft SQL Server.

Availability and Disaster Recovery

One of the key elements in any SQL Server deployment is ensuring performance, availability, and disaster recovery. However, smaller database implementations often do not require the same level of availability or performance as larger systems. For example, a trouble ticket tracking system that is only accessed during normal business hours may not need high availability. Similarly, a web application with minimal concurrent users may not require high-end hardware or software. By understanding the specific needs of your database, you can make informed decisions about the level of availability and performance required.

Choosing the Right Software

When selecting the software for your small database implementation, it is important to consider the version of SQL Server that best suits your needs. SQL Server 2005 offers three different editions for production use: Enterprise, Standard, and Workgroup. The Enterprise version includes all features, while the Standard version lacks some enterprise-level elements. The Workgroup edition is limited in terms of CPUs and RAM. However, regardless of the version you choose, the core database engine remains the same, ensuring maximum throughput.

If your organization requires the use of SQL Server 2000, it is available in Enterprise and Standard editions with similar limitations. Additionally, Microsoft offers SQL Server Express, a free version of SQL Server 2005. While it lacks some high-availability features and a rich GUI client, the database engine in SQL Server Express is identical to the costlier versions. This makes it a perfect low-cost solution for many small to medium-sized database deployments.

Choosing the Right Hardware

Extreme databases require extreme hardware, but smaller database implementations have less stringent requirements. In fact, SQL Server 2005 can be installed on a one or two-year-old desktop machine. The hardware requirements are well within reach for most organizations. Even when operating at or just above the minimum hardware requirements, query responses are more than adequate for low to moderate-volume systems. Good 7200RPM IDE drives can yield good results in less-demanding systems, and software RAID setups can be configured for increased disk performance and fault tolerance.

Backup

While many organizations use third-party tools for backing up large databases, the backup tools within SQL Server generally work fine for small to moderately sized databases. In fact, backups of smaller databases can be completed in a matter of seconds. Additionally, remote network locations can be configured as backup storage targets, eliminating the need for costly tape systems.

Conclusion

While high-end servers and enterprise-level SQL Server editions are essential for certain scenarios, Microsoft has provided scaled-down options for smaller database deployments. These options, including the free SQL Server Express, allow organizations to implement SQL Server on relatively minimal hardware. By understanding the specific needs of your database and making informed decisions about software and hardware, you can deploy a small to medium database with SQL Server that meets your requirements without breaking the budget.