July 2, 2009 at 11:15 am
Hi,
Is the IO monitoring is the SQL DBA responsibility OR the Windows admin???
Who has to do IO testing to make sure IO is good?
thanks
July 2, 2009 at 11:24 am
If it is a SQL Server then we have to monitor and report the numbers to Server \ System admin team if the number are above threshold.
July 2, 2009 at 12:42 pm
murthykalyani (7/2/2009)
If it is a SQL Server then we have to monitor and report the numbers to Server \ System admin team if the number are above threshold.
What do you look for when monitoring I/O?
July 2, 2009 at 1:18 pm
John Doe (7/2/2009)
murthykalyani (7/2/2009)
If it is a SQL Server then we have to monitor and report the numbers to Server \ System admin team if the number are above threshold.What do you look for when monitoring I/O?
I gather details related to disk response time through perform for these counters avg. disk sec\ read , avg disk sec\write and avg disk sec\ transfer for physical disk object.
To know at datafile level I gather various details from this dynamic view
sys.dm_io_virtual_file_stats(SQL 2005) or fn_virtualfilestats if it is sql 2000 and then do analysis from gathered data.
July 2, 2009 at 1:49 pm
I appreciate your insight. I would like to get more infromation on it. Can you direct me to the resources that will help me to understand gathering and analyzing I/O information?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply