![vmware esxi 5 expand thin provisioned disk vmware esxi 5 expand thin provisioned disk](https://multicloudlife.com/wp-content/uploads/2020/11/Create-VM-Completed-scaled.jpg)
Principle 1: Your database is just an extension of your storage These principles are important because over the past decade, CPU performance has increased at a much faster pace than storage performance, even while capacity has exploded. These will help guide your design decisions and help you achieve acceptable performance both now and in the future. When architecting storage for SQL Server, it’s important to understand a few important principles. The Five Key Principles of Database Storage Design In this chapter, we discuss some of the important storage system component performance aspects that will feed into your benchmarking and baselining activities. Benchmarking and baselining performance are critical to your success, so we’ve dedicated an entire chapter (Chapter 10, “How to Baseline Your Physical SQL Server System”) to those topics. You will need to benchmark and baseline your storage performance to clearly understand what is achievable from your design. Our experience has taught us to make decisions based on fact and not gut feeling. When designing your storage architecture for SQL Server, you need to clearly understand the requirements and have quantitative rather than subjective metrics. Throughout this chapter, we give you architecture examples based on real-world projects that you can adapt for your purposes. We conclude the chapter by covering one of the biggest IT trends and its impact on SQL Server. We present a top-down approach covering SQL Server Database and Guest OS Design, Virtual Machine Template Design, followed by VMware vSphere Hypervisor Storage Design and then down to the physical storage layers, including using server-side flash acceleration technology to increase performance and provide greater return on investment. We provide guidance on what our experience has taught us are important database storage design principles. Many of the concepts we discuss will be valid for past versions of SQL Server and even the newest release, SQL Server 2014.
![vmware esxi 5 expand thin provisioned disk vmware esxi 5 expand thin provisioned disk](https://www.alitajran.com/wp-content/uploads/2020/12/Convert-thick-provisioned-disk-to-thin-on-VMware-ESXi-09.png)
![vmware esxi 5 expand thin provisioned disk vmware esxi 5 expand thin provisioned disk](https://lh6.googleusercontent.com/-pCAWlWzBv5A/VJOWNZDxitI/AAAAAAAAAXM/qKgwGymll4U/w573-h545-no/2014-12-18_14-32-35.jpg)
This chapter first covers the key aspects of storage architecture relevant to both physical and virtual environments as well as the differences you need to understand when architecting storage, specifically for virtualized SQL Server Databases. Greater than 80% of all problems in a virtualized environment are caused by the storage in some way, shape, or form.
VMWARE ESXI 5 EXPAND THIN PROVISIONED DISK CODE
However, if you have bad code and bad queries, we will make them run as fast as possible. Bear in mind as you work through your storage architecture and this chapter that virtualization is bound by the laws of physics-it won’t fix bad code or bad database queries. Understanding the storage architecture in a virtualized environment and getting your storage architecture right will have a major impact on your database performance and the success of your SQL Server virtualization project. Our experience has shown us, and data from VMware Support validates this belief, that more than 80% of performance problems in database environments, and especially virtualized environments, are directly related to storage. Storage is more important than most when compared to the other members of the IT Food Group family we introduced in Chapter 5, “Architecting for Performance: Design,” which consists of Disk, CPU, Memory, and Network.
![vmware esxi 5 expand thin provisioned disk vmware esxi 5 expand thin provisioned disk](https://www.macro32.net/wp-content/uploads/2015/12/00005s.png)
Virtualizing SQL Server with VMware: Doing IT RightĪll aspects of architecting your SQL Server Database for performance are important.