August 5, 2011 at 12:45 pm
I have a sql 2005 server OLTP about 190 gig with 3 major db's being utlitzed. I am getting some extra disk space (drives) and was considering moving one or 2 of the db's to their own arrary/drives. IN making this decision any guidelines/ ideas what to look for in justifyin this move, page waits, io stats etc?
August 5, 2011 at 12:49 pm
http://www.youtube.com/watch?v=RZ4YTg4S7HI
No it's not a joke (guy's wearing a funny costume).
August 6, 2011 at 8:03 am
For justifications:
1) high io_completion wait stats
2) high io write and io read -use sys.dm_io_virtual_file_stats, this provides useful data regarding IO statistics. An example of a simple query using this view is :
SELECT * FROM sys.dm_io_virtual_file_stats(db_id,file_id)
The results can indicate that either that the database is underperforming but that the hard drives are struggling to respond adequately.
For OLTP- data and OLTP -log , establish the acceptable response time.Usually ,I'm looking for 5ms or less , as ideal, depending on IO subsystem architecture
Jack Vamvas
sqlserver-dba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply