Databases Reference
In-Depth Information
2
Demystifying Hardware
WHAT'S IN THIS CHAPTER?
➤
Understanding SQL Server workload types
➤
Server model selection and evolution
➤
Processor selection and SQL Server 2012 licensing considerations
➤
Understanding processor model numbering
➤
Choosing hardware to increase redundancy
➤
Using hardware comparison tools
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
There are no code downloads for this chapter.
THE IMPORTANCE OF HARDWARE
The underlying foundation of SQL Server 2012 performance and scalability is the actual hard-
ware and storage subsystem on which your instance of SQL Server 2012 is running. This is
true whether you are running in a virtualized environment or in a bare metal coni guration.
Regardless of what type of database workload you may have to deal with, and irrespective
of how well designed and optimized your databases are, the characteristics and performance
of your database hardware and storage subsystem are extremely important. Even the most
well-designed and carefully tuned database application can be crippled by poorly chosen or
inadequate hardware. This is not to say that hardware can solve all performance or scalability
problems. A frequently executed, expensive query on an extremely large dataset can quickly
overwhelm even the best hardware and storage subsystem. Despite this, having modern,
Search WWH ::
Custom Search