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
- 304 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
2013 R2 NAV Service going loopy
njward
Member Posts: 38
Hello,
We had an issue yesterday where our NAV service suddenly started consuming up to 100% of the processor on the server. I re-booted the server that evening when nobody was on then system and all calmed down. However, as soon as people started logging in again in the morning off it went again. I actually had to re-boot during the day as it became non-responsive.
We normally see on average of less than 10% CPU usage.
Has anybody got any suggestions on how I can analyse and find the root cause of this problem.
Many thanks
Nick
We had an issue yesterday where our NAV service suddenly started consuming up to 100% of the processor on the server. I re-booted the server that evening when nobody was on then system and all calmed down. However, as soon as people started logging in again in the morning off it went again. I actually had to re-boot during the day as it became non-responsive.
We normally see on average of less than 10% CPU usage.
Has anybody got any suggestions on how I can analyse and find the root cause of this problem.
Many thanks
Nick
0
Comments
I would suggest starting with running the Performance Monitor on your NAV ServiceTier machine.
There's a counter available named Microsoft Dynamics NAV which provides a whole bunch of indicators regarding your running NAV application.
If this doesn't bring up any clues, you may have to have a deeper look on the SQL server itself by using Management Studio and/or SQL Server Profiler. But I am not very familiar with these tools...
Hope this helps
Andrew T.
you may want to try SQL Tracing as well which will provide all SQL transactional details. This way you may be able to identify any large expensive (time consuming) tasks executed by NAV and finally get down to the source.
Some tutorials can be found here:
https://msdn.microsoft.com/en-us/dynamics/nav/dn833407.aspx
http://blogs.msdn.com/b/nav/archive/2012/09/18/example-of-how-to-use-sql-tracing-feature-to-profile-al-code.aspx
Cheers
Andrew T.