From the course: SQL Server 2012: Designing Database Solutions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Planning a database server infrastructure

Planning a database server infrastructure - SQL Server Tutorial

From the course: SQL Server 2012: Designing Database Solutions

Start my 1-month free trial

Planning a database server infrastructure

- When designing a Database Server Infrastructure there are several things to consider. Some of the most important include: Hardware. Virtualization. Whether or not you're going to virtualize your database servers. And also the licensing. With Server Hardware we usually group that into four characteristics: The CPU, or processor. How many are you going to have and what type? The memory. How much memory will be necessary for your servers? The disk. How many disks? How much redundancy in the disk? And also the speed at which they can read and write data. And then also the network. How much bandwidth do we need coming in and going out? These are the four broad categories we use when planning the hardware for a database server. When planning the licensing of a database server, you need to think certainly about the licensing of SQL Server, which can be affected by decisions in the previous things we talked about. Some licensing models of SQL Server are per processor, so the more processors…

Contents