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 - SQL Server Tutorial
From the course: SQL Server 2012: Designing Database Solutions
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.