Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Troubleshoot Disk I/O Bottlenecks

Is your server suffering from an excessive number of I/O alerts? If so, should you be worried about server performance degradation? How to best diagnose the underlying issue and smash I/O bottlenecks?

The I/O Stall Time Alarm of Spotlight Cloud is a good indicator of I/O bottlenecks. It gets raised when the average wait time per operation of a database file exceeds the alarm threshold. The alarm utilizes data from sys.dm_io_virtual_file_stats DMV’s for its computations. It uses an average value derived after five collections over the last 15 minutes so you won’t be alerted on an occasional spike. Alarm description includes the database virtual file name, database name, and average amount of wait time per I/O operation.

Four easy suggestions to diagnose I/O related issues in Spotlight Cloud:

1. Check what is contributing to I/O consumption.

I/O consumption is a sign of disk subsystems latency that could be caused by memory or CPU pressure, poorly written queries, or not having a good mixture of indexes.  At the time of the alarm:

First, take advantage of the Properties right-side panel of the Alarms page to view Smart Alarms related data:
1. Details of the alarm including the file name, average I/O wait time on the file, and duration of the alarm

2. Analyze the collected data graphed on the trend chart spanned over last few hours

This post first appeared on Spotlight Cloud, please read the originial post: here

Share the post

Troubleshoot Disk I/O Bottlenecks


Subscribe to Spotlight Cloud

Get updates delivered right to your inbox!

Thank you for your subscription