SSD prices are coming down and adoption is going up. Our clients have used them to solve all kinds of performance problems, and we’ve found some surprising results. In this module, you’ll learn the internals of these fast drives, the pros and cons of the various connection methods (SATA, PCI Express, SAN), and see why…
14. Storage: Using Solid State Drives with SQL (30m)
SSD prices are coming down and adoption is going up. Our clients have used them to solve all kinds of performance problems, and we’ve found some surprising results. In this module, you’ll learn the internals of these fast drives, the pros and cons of the various connection methods (SATA, PCI Express, SAN), and see why…
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)
- 09. Virtualization: Configuring SQL Server for Virtualization (47m)
- 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)
- 15. Storage Advanced Features: Tiering (12m)
- 16. Storage Advanced Features: Snapshots, Replication, Migrations (22m)
- 17. Go-Live Checklists and Testing (22m)