Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAV 1000 Concurrent User Scalability Paper on 290 GB db
generic
Member Posts: 511
The Microsoft Dynamics NAV team is excited to announce the availability of a new White Paper documenting the successful Performance Benchmark Testing of Microsoft Dynamics NAV 2009 SP2 with SQL Server 2008 and Windows Server 2008! This paper describes the scalability tests of Microsoft Dynamics NAV 2009 SP2 running with 1,000 constant concurrent users in heavy transaction processing and analysis activity across various functional areas of the solution.
This document details a sample customer environment that was able to process nearly 3.3 million business transactions, with a total of more than 10.6 million transactions line items, all within an 8 hour day.
The start of the database was a 290 gig db with 51 million gl transactions.
https://mbs.microsoft.com/partnersource/marketing/marketingcollateral/whitepapers/mdgpscalabilitywp.htm
I'm sure you are wondering, how and what have they done this, and NAV 2009 SP2? Well I wish it was true but its GP.
This document details a sample customer environment that was able to process nearly 3.3 million business transactions, with a total of more than 10.6 million transactions line items, all within an 8 hour day.
The start of the database was a 290 gig db with 51 million gl transactions.
-
Testing Hardware
Server Definition – Dell Power Edge 6850
4 Dual-Core 64-bit Xeon processors at 3.40 GHz
16MB L3 Cache
16 GB RAM
1 10/100/1000 NIC
4 Internal drives (18.2 GB 15K U320) Raid 10 on a PERC4/DC
4 Emulex LP1050Ex HBAs
External Storage - Dell | EMC CX600 SAN
6 Raid Groups consisting of 1 LUN each
- Each Raid group consists of 14 - 36.4 GB 15 K/ 2 GB Fiber Channel Drives
- RAID level for all 6 groups is RAID 10
- DATA 1, DATA2, DATA3, DATA4, LOGS, TEMPDB
- Fan out tempdb files – 8 total, 1 for each processor
1 Raid Group consisting of 1 LUN
- RAID group consists of 16 – 73 GB 10 K/ 2 GB Fibre Channel
- RAID level is RAID 5
- ALL BACKUPS
https://mbs.microsoft.com/partnersource/marketing/marketingcollateral/whitepapers/mdgpscalabilitywp.htm
I'm sure you are wondering, how and what have they done this, and NAV 2009 SP2? Well I wish it was true but its GP.
0
Comments
this Whitepaper is for: Microsoft Dynamics GP 10.0 Scalability White Paper for SQL Server 2008 & Windows Server 2008
I'm posting this sarcastically.
Every company from the 70K out there would like this in NAV.
sorry, I have not seen it
Created separate post for inviting comments.
http://ssdynamics.co.in