Database I/O is the transfer rate, in megabytes per second, of data from memory to disk, disk to memory, or disk to disk.
The easiest way to check the I/O (MB/sec) on your SQL Instance is by checking SSMS Activity Monitor
b) You can correlate this information and look at the Server Wait types . You will probably get wait types that are related to I/O (PAGEIOLATCH_IO, ASYNC_DISKPOOL_LOCK, IO_COMPLETION, ASYNC_IO_COMPLETION)
High I/O causes are normally due outdated statistics, bad query design, lack of proper indexing and/or implicit transactions.
High I/O causes are normally due outdated statistics, bad query design, lack of proper indexing and/or implicit transactions.
No comments:
Post a Comment