Share
Report
10Hi,
Have two questions:
1. If you have a server with two raids one with mechanical disks and one with SSDs and you had to split the servers required in D365FO on premise between the two raids... What servers in order of being critical for user performance would you place on the SSD raid?
Eg 1.SQL 2.AOS 3.ORC ?
2. Is there a benchmark/baseline somewhere detailing the built-in performance test in Dynamics. Mainly to compare what numbers are ok and not ok with our own test.
Here is our test. Anything looks out of order? (since we have some performance issues)
********* Large buffer read **************
LargeBufferReads: Selected 1000 records in 448ms.
********* Test run with 10000 Records **************
Insert : 8020
Select on ClusteredIndex : 2509
Select on Unique index with cache hit: 106
Select on Unique index without cache hit : 22203
Select on Non-unique index : 23428
Tempdb Temp table Inserts : 677, Selects : 133
inMemory Temp table (AOS) Inserts : 776, Selects : 140
SGOC Inserts : 24528, SGOC Lookups (25) times each entry : 410
Update : 34058
Inserts thru recordInsertList : 9117
Insert RecordSet : 491
Update RecordSet : 312
Delete From : 300
Thank you!
All responses (
Answers (
