SQL Server 2008 Notes Part-2: SQL Server 2008 Hardware and Software Requirements

SQL Server 2008 Notes Part-1: SQL Server Editions and Explanation

What are memory/RAM requirements and recommendations for SQL Server 2008?

Minimum Memory is 512MB of RAM for all versions of SQL Server 2008 with a recommended 2GB of RAM.

Express Edition requires a minimum of 256 MB RAM and a recommendation of 1GB RAM.

32 bit versions of SQL Server 2008 requires a minimum of 1 GHZ and 64 bit requires a minimum of 1.4 GHZ.  Recommended processor speed is 2Ghz or faster.

DB Engine which includes the data files, Replication, and Full-Text search requires a minimum of 280 MB of disk space.  SSAS requires 90 MB.  SSIS and SSRS require a minimum of 120 MB each.  The client components that are used to implement and maintain SQL Server 2008 requires 850 MB of free disk space.

What are all the components that are installed along with SQL Server 2008?

• .NET Framework 3.5
• SQL Server 2008 Native Client
• SQL Server 2008 Setup support files

What are the Pre-requirements for SQL Server 2008 installation?

Requires Microsoft Windows Installer 4.5 or later and Microsoft Data Access Components (MDAC) 2.8 SP1 or a later version.  Microsoft IE 6 SP1 is required for all SQL Server 2008 installation for Microsoft Management Console (MMC), SSMS and BIDS.

Which VM environments are supported for SQL Server 2008?

SQL Server is supported in VM environments that run on the Hyper-V role in MS Windows Server 2008 SE, MS Windows Server 2008 EE and DC Edition.

OS Support notes for SQL Server 2008

Except SQL Server 2008 X64 EE and SQL Server 2008 X64 SE, all editions can be installed on any Windows X64 in a Windows-On Windows (WOW64) configuration- 32 bit subsystem of a 62 bit server- that enables 32 bit applications to execute natively in 32 bit mode.

All Windows 2008 Servers are both with and without Hyper-V installed.

There is a 64 bit edition of SQL Server 2008 Express edition for 64 bit OS.

64 bit Itanium processor systems support SQL Server 2008 Enterprise 64 bit IA64 on Windows Server 2008 Itanium edition, Windows Server 2003 SP2 64 bit Itanium EE and DC Editions.

SQL Server 2008 Notes Part-3: SQL Server 2008 Instances, Licensing and Security Considerations

Advertisement