Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Performance Tuning on a C/SIDE environment
jjhems
Member Posts: 7
First off, I'm a technical consultant, and my insight in NAV's internals is limited to the login screen 
(well I do manage to setup any components we use).
We have a customer that has just upgraded it's database to 5.0 SP1 (C/SIDE) on a freshly installed Virtual Server (vmware). They are experiencing extremely poor performance. Their performance problems extend to other applications (Outlook, other applications that require networking) as well when the NAV client is active. So I've already suggested to monitor the network, and look for bottlenecks there. We are also going to check the VM configuration for memory, CPU, and disk issues.
All in all, I can cover the stuff outside of NAV as well as the NAV infrastructural matters, but I'm not sure how to test (stress/loadtest), and monitor a C/SIDE database. I know there's a performance benchmark tool for SQL Server databases, but can it be used for C/SIDE as wel?
Any assistance is welcome!
Thanx.
(well I do manage to setup any components we use).We have a customer that has just upgraded it's database to 5.0 SP1 (C/SIDE) on a freshly installed Virtual Server (vmware). They are experiencing extremely poor performance. Their performance problems extend to other applications (Outlook, other applications that require networking) as well when the NAV client is active. So I've already suggested to monitor the network, and look for bottlenecks there. We are also going to check the VM configuration for memory, CPU, and disk issues.
-
Some info on the server/database configuration:
The C/SIDE Database Server is configured to use 990000kB of cache, and commit cache is on.
The database (aprox. 20GB) is setup in a single file (I intend to split this into multiple files, on seperate disks)
All in all, I can cover the stuff outside of NAV as well as the NAV infrastructural matters, but I'm not sure how to test (stress/loadtest), and monitor a C/SIDE database. I know there's a performance benchmark tool for SQL Server databases, but can it be used for C/SIDE as wel?
Any assistance is welcome!
Thanx.
Jeroen Hems
There's no place like 127.0.0.1
There's no place like 127.0.0.1
0
Answers
-is the NAV-client slow if you are working directly on the server and connecting using 127.0.0.1? If no, it means that the network has some problems.
-drives : as always : they should be dedicated PHYSICAL drives
-the VM machine should have enough memory to keep the cache ALWAYS in memory.
-the VM host should have enough memory to keep the VM client machines ALWAYS in memory.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
einsTeIn.NET, I have looked at the client monitor, but I also read that it's capable of dragging down performance on its own. Since the customer is already having severe performance issues, I think it's best to keep that one as a last resort.
Kriki, I've received several test reports that seem to point in one direction, VM configuration!
Thank you again!
There's no place like 127.0.0.1