cancel
Showing results for 
Search instead for 
Did you mean: 

Very high database access times

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

sriramsbg
Active Contributor
0 Kudos

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