Database servers are used to centrally store databases and to serve up the requested data to the user. Most companies will have a software package that stores its data in a database. Examples are Accounts software such as Sage, CRM software such as ACT or GoldMine, ERP applications such as Everest, SAP or Navision and specialist software (for manufacturing, estate agents, recruitment consultants etc). Most of these applications use Microsoft’s SQL Server as the database.
The Database server needs to be high spec as it provides concurrent access to users requesting complex functions such as searching and sorting of data. All the processing is performed on the server, not the PC, so it is very processor intensive. Put simply the larger the database, the higher the demand.
Microsoft SQL Server is available as a standalone application to run on Server 2003/2008 as well as being included in Microsoft's Premium version of the Small Business Server Suite.
Recommended Hardware:
Minimum Spec: Mid-range Server - Tower or Rack, 8GB, Single CPU, 2x small Hard Drives for the O/S, 3x large Hard Drives for the database, Windows 2003 or 2008 server with SQL Server or Small Business Server Premium Edition
Best Spec: High end Server – Tower or Rack able to store 8 hard drives, 8GB, Dual CPU, 2x small Hard Drives for the O/S, 4x large Hard Drives for the database (mirror and stripe) and 2x hard drives for the log files, Redundant Power Supply, Windows 2003 or 2008 Server 64 bit, SQL server.