MS-SQL Server - Dhab & Raid

Dhab & Raid

- Disk Latency

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance

- History of Performance Monitor

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance

- Allocation Best Practices

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql

- Basics of I/O

https://support.microsoft.com/en-us/topic/hard-disk-drive-sector-size-support-boundaries-in-sql-server-4d5b73fa-7dc4-1d8a-2735-556e6b60d046#:~:text=SQL%20Server%20supports%20disk%20drives,For%20example%2C%208K%20sector%20size.

Additionally,

Raid

https://learn.microsoft.com/en-us/answers/questions/440499/raid-level-for-sql

Best Regards

T. Amit Vaid S.