Monitor Disk Usage
Applies to: SQL Server
Microsoft SQL Server uses Microsoft Windows operating system input/output (I/O) calls to perform read and write operations on your disk. SQL Server manages when and how disk I/O is performed, but the Windows operating system performs the underlying I/O operations. The I/O subsystem includes the system bus, disk controller cards, disks, tape drives, CD-ROM drive, and many other I/O devices. Disk I/O is frequently the cause of bottlenecks in a system.
Monitoring disk activity involves two areas of focus:
Monitoring disk I/O and detecting excess paging
Isolating disk activity that SQL Server creates
For more information on how to troubleshoot I/O issues in SQL Server, see Slow I/O - SQL Server and disk I/O performance.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: Under hela 2024 kommer vi att fasa ut GitHub-problem som feedbackmekanism för innehåll och ersätta det med ett nytt feedbacksystem. Mer information finns i:Skicka och visa feedback för