How to configure CPU, memory, and storage for SQL Server running in VMware and Hyper-V. Covers questions like how many virtual CPUs to allocate, why you should set a memory reservation, which Perfmon counters to watch, and whether data and log files should be on separate volumes.
09. Virtualization: Configuring SQL Server for Virtualization (47m)
How to configure CPU, memory, and storage for SQL Server running in VMware and Hyper-V. Covers questions like how many virtual CPUs to allocate, why you should set a memory reservation, which Perfmon counters to watch, and whether data and log files should be on separate volumes.
You'll need a membership to access this course. Check out my training classes.
- 01. Architecture Design: Building a Strategy for RPO and RTO (18m)
- 02. Architecture Design: Tactics – Clustering, Always On, Mirroring, and More (29m)
- 03. Architecture Design: Are Always On Availability Groups Right for You? (40m)
- 04. Hardware: How to Build Fast SQL Servers (30m)
- 05. Hardware: Server Sizing (23m)
- 06. Hardware: Find the Old Server’s Bottleneck with Wait Stats (28m)
- 07. Virtualization: How VMware and Hyper-V Manage Resources (20m)
- 08. Virtualization: Planning for Consolidation and Virtualization (32m)
- 10. Virtualization: Backup Mistakes with Virtual SQL Servers (11m)
- 11. Storage: How to Test and Compare Your Storage (34m)
- 12. Storage: SAN Pathing (21m)
- 13. Storage: How to Set Up Your SAN for SQL Server (22m)
- 14. Storage: Using Solid State Drives with SQL (30m)
- 15. Storage Advanced Features: Tiering (12m)
- 16. Storage Advanced Features: Snapshots, Replication, Migrations (22m)
- 17. Go-Live Checklists and Testing (22m)