SQL Server Hardware Tips
Configuration
- Automate file cleanup on SQL Server drives using PowerShell
- Disk Partition Alignment Best Practices Whitepaper for SQL Server
- Hard Drive Configurations for SQL Server
- Partition offset and allocation unit size of a disk for SQL Server
Overview
Performance
- Benchmark SQL Server IO after partition offset and allocation unit changes
- Benchmarking SQL Server IO with SQLIO
- Format drives with correct allocation and offset for maximum SQL Server performance
- Gather Storage Subsystem Performance Metrics Using the Diskspd Utility for SQL Server Applications
- How to Monitor Storage Performance with a Single Application
Solid State
