- When designing a Database Server Infrastructurethere are several things to consider.Some of the most important include:Hardware.Virtualization.Whether or not you're going to virtualizeyour database servers.And also the licensing.With Server Hardwarewe 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 usewhen planning the hardware for a database server.When planning the licensing of a database server,you need to think certainly aboutthe licensing of SQL Server,which can be affected by decisionsin the previous things we talked about.

Some licensing models of SQL Server are per processor,so the more processors you havethe more money you're going to spend on licensing.So that decision about processor affects you in other ways.And then also virtualization.Virtual servers are licensed differentlythan physical servers,so your decision about virtualizationwill also affect your licensing cost.You should also considerthat you're not just licensing SQL Server.At a minimum you also need to license an Operating System,which could be a significant cost.

And there may be other softwareyou're going to run on the server also.Maybe a backup software or a security software.With all of those thingsthe cost would typically increasethe more servers you have.So you need to consider that in your cost model also.

Resume Transcript Auto-Scroll

Author

Released

3/23/2015

Learn how to design databases, secure databases, and keep them in tip-top shape, with SQL Server 2012. Join Martin Guidry in this course, as he reviews each step in the process: from designing the infrastructure, a logical schema, and execution plan for the physical hardware, to using indexes to fine-tune performance and implementing policy-based management. He explains best practices for database design, shows where developers can bend the rules, and introduces techniques to manage your database throughout its lifecycle with PowerShell and other monitoring tools.