The application Gupta SQL 9.0.1 is now running in a VM. The Datastores are on a Netapp 6070 (Raid DP 41 FC Disks a 300 GB)
The VM uses 5 LUN's. C: Windows 2003 D:Data E: Gupta SQL : F: Gupta SQL Logs G: Pagefile
Before it run on a HP DL360 G3 (Smart 5i raid controller 64 MB Cache) with 6 x 36 GB and 3 Logical Volumes on raid 5 .
On the HP DL360 G3 the databse update statistics runs 1Hour 3 Minuten.
The VM on the Netapp needs to 2 Hours 14 Minutes.
Analyzed Application SQL Gupta with perfmon: Average transfer size /sec for SQL Log 64 KB Read and Write (E:) and for SQL log 4 KB Read and Write
Performance Tweaks:
1.) Datacore Uptempo: Only 5 Mintes Faster. I think the DB , which 30 GB , is to big.
2.) Partition Aligment for E: and F Partition : 1 Hour 45 Minutes. Improvement 29 Minutes .
3.) OS Filesystem Blocksize(Clustersize) change for E: to 64 KB (default 4 KB) no improvement
4.) OS Filesystem Blocksize changed for F: to 32 KB (default 4 KB) no improvement
5.) Separate LUN for Pagefile G: no improvment
6.) VMware VC changed Queue Depth to 128 : no improvement
Arrgh!!!! What the hell is the problem? Is it cache for random io?