Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BUFFER I/0 Expand / Collapse
Author
Message
Posted Tuesday, November 27, 2012 2:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:19 AM
Points: 231, Visits: 736
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
Post #1389018
Posted Wednesday, November 28, 2012 6:44 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 4,128, Visits: 5,839
ESAT ERKEC (11/27/2012)
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


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 at GMail
Post #1389728
Posted Wednesday, November 28, 2012 7:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 8:19 AM
Points: 231, Visits: 736
I have 700 gb db
Post #1389791
Posted Wednesday, November 28, 2012 8:59 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 4,128, Visits: 5,839
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 at GMail
Post #1389872
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse