Data Files I/O Problem.

[Former Member]

we have a database around 1.5TB with 4 data files and 1 log file. All the data files are sitting on a single local drive and log is on a separate drive.

During data loads, our system is getting very slow. I am thinking to have each data file on a separate drive to distribute the I/O across the drives.

Please suggest me for an better approach.

Thanks

[Former Member · Accepted solution]

Have you looked through MicroSoft's recommendations on running SAP on SQL Server? It includes best practices and is available here -> [SAP with SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability|http://www.microsoft.com/sqlserver/2005/en/us/white-papers.aspx]

Hope that is helpful.

J. Haynes

[Former Member]

Hello,

You're running SAP on only two drives? I/O is definitely going to be a bottleneck. I'm running on 30 fibre channel drives and I still could use more I/O at times. At the least you should have each file on it's own drive (preferably RAID) by the best practices put out by SAP and MS.

Regards,

Michael

[Former Member]

Thanks Guys,

we decided to move our data files each in separate network drive. Hope it will show improvement.

Thanks..

[Former Member]

We have similar issue on one of our boxes during data load.

But, we do not have problem on server where data files are sitting on local drives.

After long investigation, other than disk/ Data files I/O other possible cause of problem is Stats not being updated.

By, default table stats will not be updated if change is below 20% or less than 500 lines with "Auto update". So, worth updating stats on tables. But regarding updating stats, reccomondation is not 100% defined for ERP system, while it is clear for BW type database.

Regards,

Krishna