When we run a purchase order post (receive and invoice) with one product, quantity 1000 pieces, with serial number tracking, tooks 6 or 7 minutes to post (there´s no other users or connections to the server).
With my laptop the same scenario tooks only 3 and a half minutes to complete. When i receive 5000 serial numbers my laptop finish in 13 minutes, the server goes nuts.
Server
DL380G8P ( 2 Intel® Xeon® Processor E5-2690 (20M Cache, 2.90 GHz, 8.00 GT/s Intel® QPI) 32 threads 128 GB Ram, HD 600gb, 15K X6 IN raid 10 WINDOWS SERVER 2012 and SQL SERVER 2012 SP1
There is only one visible disk of the RAID (C:)
SQL server parameters
We create a SQLDATA Directory and we store the mdf, ndf and log file there.
TEMPDB is in the default path (yeah I know is the same disk)
Minimum server memory 80000 mb
Maximum unlimited
All processors are selected with automatically set processor affinity mask for all processors, same for I/O Affinity
Cost threshold for parallelism is set to 5
Locks set to 0
Max degree of parallelism set to 1
Query wait set to -1
Server of database is dedicated (tier one)
Server2 is running NAV Server 2013 Build 7.0.34298 and NAV client 2013 Build 7.0.34298 through Terminal server client (tier two and three)
Here my laptop specs
Gateway NV47H, intel core I3-2350M, 4 gb of ram, one hard drive 500 gb sata-II 5400rpm with Windows server 2012 and SQL server 2012, NAV 2013 Build 7.0.34298 with Nav 2013 Client Build 7.0.34298 in these instance.
My SQL server settings are:
A SQLDATA Directory and we store the mdf, ndf and log file there.
TEMPDB is in the default path (yeah I know is the same disk)
Minimum server memory 0 mb
Maximum unlimited
All processors are selected with automatically set processor affinity mask for all processors, same for I/O Affinity
Cost threshold for parallelism is set to 5
Locks set to 0
Max degree of parallelism set to 1
Query wait set to -1