BUFFER I/0

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » BUFFER I/0

BUFFER I/0

Rate Topic

Display Mode

Topic Options

Author

Message

ESAT ERKEC

Posted Tuesday, November 27, 2012 2:14 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 1:46 AM
Points: 222, Visits: 707

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

TheSQLGuru

Posted Wednesday, November 28, 2012 6:44 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 3,582, Visits: 5,130

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