Jason Riche
asked on
Microsoft Dynamics GP 2013
Hi,
I'm in the process of installing Microsoft Dynamics GP 2013 on a Dell server PER320 running Windows Server 2012 Essentials(64 bit). The processor is an Intel(R) Xeon CUP E5-2430 0 @ 2.20GHz 2.20 GHz, it has 32GB of installed RAM and 3 drives setup in a Raid 5 configuration. When we are running through the process of updating the databases and are finding poor performance from our HDD.
Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.
More Info:
Excellent < 08 ms ( .008 seconds )
Good < 12 ms ( .012 seconds )
Fair < 20 ms ( .020 seconds )
Poor > 20 ms ( .020 seconds )
Our disks was maxing out at over 40ms (.040 seconds). I ran chkdsk on all 3 drives and didn't find any errors. I double checked the requirements for GP 2013 and Raid 5 is supported. Any suggestions on how for improve performance on the drives?
I'm in the process of installing Microsoft Dynamics GP 2013 on a Dell server PER320 running Windows Server 2012 Essentials(64 bit). The processor is an Intel(R) Xeon CUP E5-2430 0 @ 2.20GHz 2.20 GHz, it has 32GB of installed RAM and 3 drives setup in a Raid 5 configuration. When we are running through the process of updating the databases and are finding poor performance from our HDD.
Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.
More Info:
Excellent < 08 ms ( .008 seconds )
Good < 12 ms ( .012 seconds )
Fair < 20 ms ( .020 seconds )
Poor > 20 ms ( .020 seconds )
Our disks was maxing out at over 40ms (.040 seconds). I ran chkdsk on all 3 drives and didn't find any errors. I double checked the requirements for GP 2013 and Raid 5 is supported. Any suggestions on how for improve performance on the drives?
What's the controller?
If you are not running a caching controller ,the performance will suck.
If you are using a PERC S110 (SW RAID) or PERC H310 you made a mistake.
Not a real RAID controllers.
The H710 is what you want
If you are not running a caching controller ,the performance will suck.
If you are using a PERC S110 (SW RAID) or PERC H310 you made a mistake.
Not a real RAID controllers.
The H710 is what you want
Just because RAID-5 is supported it doesn't follow it's the right tool for the job. RAID-5 does have its place, but is ill suited to write intensive workloads, coupled with that a lot of systems are being shipped with a hardware assisted software RAID "controller" that is known to the experts as "fake RAID" and it's performance leaves a lot to be desired.
So, What RAID controller are you using and what disks, SATA? SAS?, what rpm
So, What RAID controller are you using and what disks, SATA? SAS?, what rpm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
just make sure that your DB is on one set of disks and the redo logs are on another - not just a different partition of the same RAIDset
I've requested that this question be deleted for the following reason:
Not enough information to confirm an answer.
Not enough information to confirm an answer.
The answer I provided answered this question very specifically and with detail--if followed would improve GP and SQL performance, so that should suffice an a good answer.
ASKER