Very high database access times

[Former Member]

Hello Gurus, I need help with a problem I'm encountering that's making me pull my hairs out.

I have ECC and CRM systems sitting in a virtualized environment with the database on MSSQL 2012 SP1. The ECC systems use NAS, the CRM systems presently using local storage to try and resolve these issues:

Disk access times when looking at the operating system level are fine, anywhere from 2-8ms ms/op.

However, when performing actions in SAP, database access times skyrocket and data throughput drops very low.

Here is that ST04 I/O performance looks like in the CRM system, as you can see, very poor:

This CRM host has a total of 32GB assigned , with 10GB dedicated to the SQL server itself.

We see this same sort of slowdown in the ECC system which has 50GB assigned to the SQL server.

Thoughts?

[Sriram2009]

Greeting to Steve

1. Could you refer the SCN link and SAP KBA about MS Sql DB performance

From the SCN link check the point number 1

2. 1744217 - MSSQL: Improving the database performance - Refer the point number 5

Regards

SS