November 27, 2012 at 2:14 am
My Sql Server Buffer I/O wait is very high
I have 390 GB RAM
I set the sql server min 300 gb max 350 gb
what is the reason can be
November 28, 2012 at 6:44 am
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
November 28, 2012 at 7:50 am
I have 700 gb db
November 28, 2012 at 8:59 am
ESAT ERKEC (11/28/2012)
I have 700 gb db
which is quite a bit more than your available buffer pool ...
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply