Очевидные советы по ускорению работы 1С (8.2, 8.3)

27.06.16 20:59

, 1, .

— ( ), 1.

, - , — .

" " . . , , . , , , . , , , .

, ( - - , ). , 1. , , ?

, : HP DL180G6, 2*Xeon 5650, 32 Gb, Intel 362i , Win 2008 r2. , Core i3-2100. , .

1 SQL, SQL: IBM System 3650 x4, 2*Xeon E5-2630, 32 Gb, Intel 350, Win 2008 r2.

10 Gbit Intel 520-DA2 .

. ( , , CIFS/SMB). :

0. , . , . .

, 10 (Pentium 775 socket) 1: . (Celeron = ).

, 775 socket 1 , , 1 8.2 . ( ), ( web, ) .

, . — , HASP.

30 "" , 1 - .

1. , "" , , . ( ). , . , — Ramdisk enterprise.

8.2 256 , ! . , , 100-200 . , , 300-400 .

8.3 256 , .

. , (), 1 1 . , — . , , 1 . , Core i3 70-80.

. , , , , 1 . " " - 3-5 (10-15%).

. - , - . - , . ( . , Intel SpeedStep TurboBoost).

- 1 (, ). , , . , 1 (), , - 1 . - .

( ) :

BIOS. C1, C1E, Intel -state (C2, C3,C4). , . , , - . BIOS , . BIOS , Windows . ( BIOS ). "" BIOS, , Xeon - .

- - . - , , . - .

, . - - - . , .

- .

BIOS C-state ,

Pentium Core ,

Xeon ""

BIOS C-state , .

Turbo boost -

. : Intel Xeon 5650, ramdisk. 23.26, - 49.5. - . , Intel Core.

, 1, - .

) Turbo Boost. , , . , . ( , , , . , Bus speed 133 166 , )

turbo boost , , . ! 1 ( ). , turbo boost , C-state. :

turbo boost 23

, - , Core speed - , - . 1?

		Core speed (), GHz	CPU-Z Single Thread	Ramdisk	Ramdisk -
Turbo boost	20	2,67	957	49,50	36,50
C-state off, Turbo boost	22	2,93	1050	53.19	40,32
C-state on, Turbo boost	23	3,07	1080	53,13	23,04

, 23 , - 22 23 , - - 23 (, C-state 7, , C-state). , , . , 49,5 53 - , .

- turbo boost . , Turbo boost , (BIOS: QPI L0s, L1 - disable, demand scrubbing - disable, Intel SpeedStep - enable, Turbo boost - enable. - - ). - ( ) , c-state , . - ...

. . - . DDR 2/3/4, . , .

. 1 8.2.19.83, , - 1 SQL , Shared memory. Turbo boost . 8.3 .

	800	1066	1333
	48,54	49,50	50,51
1 8.2	49,50	49,50	49,02
	49,02	49,02	49,50
	36,76	36,76	37,04
1 8.2 -	37,04	37,04	36,50
	36,23	36,76	36,76

- . CPU-Z , , CAS Latency RAS to CAS Delay, . , , , .

2. , - . , (1, 2 ), . 1 , iperf ( 1 - 850 , 950-980), . - , , (5-10 ) . 1 100 /, — 120 /. , ( ) . SMB Linux , «» , .

. windows windows server ( windows ) SMB/CIFS, linux (debian, ubuntu ) linux NFS ( SMB , NFS ). , - , . debian 1 - , , , , Win , postgres 50 .

, "" , . 1. servershare, 192.168.0.1share, net use z: 192.168.0.1share ( , ) Z. , 1 , . , :

( , ) - net use DriveLetter: servershare. : net use m: serverbases. , IP , . - dns , hosts. . - ( ).

, . : Intel X520-DA2, Intel 362, Intel 350, Realtek 8169. Win 2008 R2, Win 7, Debian 8. , . , Iperf ( 10 , 7.2 Gbit , , ). , SSD( , ) SSD. 100 Mbit Intel 362. 1 Gbit Intel 350 1 Gbit Intel X520-DA2 ( ) . , ( , 10%, - ). 1 8.2.19.86, 8.3.6.2076. , , .

	100 Mbit CIFS Intel/Intel Win 2008 - Win 2008 ip	100 Mbit CIFS Intel/Intel Win 2008 - Win 2008	1 Gbit CIFS Intel/Intel Win 2008 - Win 2008 ip	1 Gbit CIFS Intel/Intel Win 2008 - Win 2008	1 Gbit CIFS Intel/Realtek Win 2008 - Win 7	1 Gbit CIFS Intel/Realtek Win 2008 - Debian	10 Gbit CIFS Intel/Intel Win 2008 - Win 2008 ip	10 Gbit CIFS Intel/Intel Win 2008 - Win 2008
	11,20	26,18	15,20	43,86	40,65	37,04	16,23	44,64
1 8.2	11,29	26,18	15,29	43,10	40,65	36,76	15,11	44,10
8.2.19.83	12,15	25,77	15,15	43,10			14,97	42,74
	6,13	34,25	14,98	43,10	39,37	37,59	15,53	42,74
1 8.3	6,61	33,33	15,58	43,86	40,00	37,88	16,23	42,74
8.3.6.2076		33,78	15,53	43,48	39,37	37,59		42,74

( , . ):

, , 1. Core i3 40+ , , , . ! ( 10) , 1 , ().

1C 8.3 . - , , . , ( ) , FCoE, , microsoft certified ( ), . , . , 8.2 , 8.3 - . 8.3, .

1 8.3.6.2076 ( , ) - , 8.3.7.2008. 8.3.7.2008 ( ) , . , Process Explorer , 8.3.6.

, 100 , ( ), , 1 . - (latency) .

( ) 1 8.2 Intel - Realtek 10%, Intel-Intel. realtek-realtek . , - Intel, - Intel ( ..). .

( drweb 10 ) 8-10% . ( 1cv8 , ) - , .

. samba , Win XP Win7 ( - ), 1 . , samba debian/ubuntu , . , .

, net use, fio. , 1, /.
( ) , 1 10 . , 10 - iSCSI, . - , 1 .
100 8.3 8.2 - , . , , 8.2, - 8.3.
NFS win - win win-lin 6 , . 25 , ( 2 ). windows NFS .

, ( ). , 30( 40), 10 - ( ).

. ( , , RDP). :

, . , . .
, , . - (, , ).
1. "" , 50 RDP , , .
( 30 , ) SSD . - , 1, , . , , . () , .

, . , , . 8.3.6.2076 8.3.7.2008 ( Ramdisk Turbo boost 8.3.6 56.18 8.3.7.2008 55.56, ). - , turbo boost ( ).

	Raid 10 4x SATA 7200 ATA ST31500341AS	Raid 10 4x SAS 10k HP DG146BB976	Raid 10 4x SAS 15k HP DH072BB978	SSD OCZ Agility 3	Ramdisk	Ramdisk Turbo boost	RAID
	21,74	28,09	32,47	49,02	50,51	53,76	49,02
1 8.2	21,65	28,57	32,05	48,54	49,02	53,19
8.2.19.83	21,65	28,41	31,45	48,54	49,50	53,19
	33,33	42,74	45,05	51,55	52,08	55,56	51,55
1 8.3	33,46	42,02	45,05	51,02	52,08	54,95
8.3.7.2008	35,46	43,01	44,64	51,55	52,08	56,18

RAID , , . - .
8.2 SATA SSD - . . . " (%)" 80-95. , 35, - 49 ( , ). - , 100% write cache hit ratio.
( Agility 3) . - , , , Intel 3700 , . , , SSD , .
( ) 2 ( ), . , , , - .
, , . 1-2, 10, SAS . ( - , perfmon).
- , ( ..).

: ( , ) , , ( 30) - , , .

, , , perfmon, -, , , . .

- .

8.2, .. 8.3 .

, .

	1: Xeon 5520 SQL: Xeon E5-2630 1 Gbit Local SSD	1: Xeon 5520 SQL: Xeon E5-2630 1 Gbit Fibre channel - SSD	1: Xeon 5520 SQL: Xeon E5-2630 1 Gbit Fibre channel - SAS	1: Xeon 5650 SQL: Xeon E5-2630 1 Gbit Local SSD	1: Xeon 5650 SQL: Xeon E5-2630 1 Gbit Fibre channel - SSD	1: Xeon 5650 SQL: Xeon E5-2630 10 Gbit Local SSD	1: Xeon 5650 = SQL: TCP IP	1: Xeon 5650 = SQL: Shared memory	1: Xeon 5650 = SQL: Shared memory Balanced mode	1: Xeon 5650 = SQL: Shared memory Turbo boost	1: Xeon 5650 = SQL: Shared memory Turbo boost - debug
	16,78	18,23	16,84	28,57	27,78	32,05	34,72	36,50	23,26	40,65	39.37
1 8.2	17,12	17,06	14,53	29,41	28,41	31,45	34,97	36,23	23,81	40,32	39.06
	16,72	16,89	13,44	29,76	28,57	32,05	34,97	36,23	23,26	40,32	39.06

, - - , .

, , , . . - ( , ) 1 .
1 5520 5650 . , , ( ).
SQL , , 1, MS SQL ( ) .
1 SQL 1 10 10% . .
Shared memory - , 15%, . , . - SQL , 1 FQDN ( tcp/ip), localhost ServerName, ServerNameInstanceName, zz-testzztest. ( : Microsoft SQL Server Native Client 10.0: : , SQL Server 2000 [126]. HRESULT=80004005, HRESULT=80004005, HRESULT=80004005, SQLSrvr: SQLSTATE=08001, state=1, Severity=10, native=126, line=0).
100 - Win 2008 Std ( ), 32 . - 1 SQL ( 64 ) . MS SQL 24-28 - ( , - 1 ?)
1 SQL - ( - ). Hyper-V ...
- . .
, (ragent.exe -debug) . , , 2-3% .

, .. - , . , 1C MS SQL, ( 3 ), SSD , (128+), . - , ( , ). , .

: http://infostart.ru

Read Full Article