Drive Read write Rates, I/O monitoring

Question

Post reply

Drive Read write Rates, I/O monitoring

Joe-420121

Hall of Fame

Points: 3152
More actions
January 2, 2010 at 12:18 pm

#138056

I want to know for given day How much Read request/ Write request on each drives in the SQL Server. The report should help to place dbf, log files distributed across the all drives evenly, What tool is available for this; or any idea how to get the report. Pls help thanks in advance for any helps.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

vstitte SSCarpal Tunnel Points: 4475 More actions · Answer 1

You can use PerfMon tool which comes with Windows to capture such information.

Here is a best practices guide from MS that might help. Storage Top 10 Best Practices.

Check this tool out as well from MS that can help provide disk IO capacity. SQLIO Disk Subsystem Benchmark Tool

george sibbald SSC Guru Points: 104210 More actions · Answer 2

If you are looking to spread around your data and log files for multiple databases then you will want to drill down further and get read and write figures for the individual database files, in order to see which are the busiest. For this you can use sys.dm_io_virtual_file_stats or fn_virtualfilestats

---------------------------------------------------------------------