Join Gerry O'Brien for an in-depth discussion in this video Hardware requirements, part of Installing SQL Server 2012.
To get the best performance out of SQL server, you need to consider the hardware components of the server on which you will install the software. Traditionally, the hardware reqiurements given by Microsoft, are the minimum required to install and run SQL server. However, note that these are minimum, and if you would like acceptable performance from your server You will want to consider going about the minimum. At the end of this video you will understand hardware requirements necessary to install an instance of SQL Server. SQL Server requires a minimum of six gigabytes of hard disk space, but the amount that you'll actually use will depend on the components that are installed And of course on the size of the databases that you intend to use with your instance of SQL server.
SQL server requires a minimum of an 800 by 600 screen resolution, but higher screen resolutions are recommended, as it gives you more screen real estate when you start to use the SQL server graphical tools, such as the SQL server management studio. Or SQL server configuration manager. SQL server also requires, specific amounts of computer memory. Once again there are minimum and recommended amount of memory to use for your SQL server installation. SQL server Express edition, requires a minimum of 512 megabytes of memory.
All of the other editions of SQL server, require a minimum of one gigabyte. Microsoft recommends that you use at least one gigabyte for the Express edition, and at least four gigabytes for the other editions. You'll want to consider using more memory as your database sizes increase. SQL server will start to consume more memory as your database sizes grow because of the amount of processing required and the amount of in-memory storage for running things such as SQL queries. SQL Server also has specific CPU requirements.
For the x86 versions, SQL Server requires at least a one gigahertz processing speed. X64 or the 64-bit versions require a minimum of 1.4 gigahertz. One again, using the recommended amounts of two gigahertz or faster for processor speeds. Will give you much better performance on your SQL installation. Even though we've talked about SQL Server being installed on the server, also note that it can be virtualized on Microsoft's Hyper-V environment running on the Windows server operating system.
A good example of this, is in the Windows Azure environment where SQL Server is installed on a virtual machine. So, in summary. Ensuring adequate hardware resources for your SQL server installation, will aid in providing the performance you would expect from your database instance. And once again you should use the recommended or higher hardware specifications as laid out by Microsoft in order to gain the best performance from SQL sever. Using the minimum hardware spec will not provide a good experience.
- Choosing the right SQL Server edition for your organization
- Installing SQL Server
- Testing the installation and connectivity
- Configuring SQL Server services
- Connecting to the network
- Creating and connecting to databases
- Backing up and restoring a database