ESAT ERKEC (11/27/2012)
My Sql Server Buffer I/O wait is very highI have 390 GB RAM
I set the sql server min 300 gb max 350 gb
what is the reason can be
If you have a multi-terabyte database and you are trying to access lots of it with slow IO subsystem in play you can get this easily. I recommend having a professional tuner give your system a performance review. I suspect lots of suboptimal things will be found.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service