Hi everyone,
We use 3 tier Architecture at Navision 2009 R2. Nav service's performance is fine. But frequently Client(RTC) locks for 15-25 second same time. I think Server stop working in that time. Because, all clients are affected this problem same time. We have 35 users. Especially, this problem occurs busy times.
Thanks.
*This post is locked for comments
Problem solved! We changed security model from Enhanced to Standart. Navision is working perlectly.
I will try to change Securty Model. From Enhanced to Standart.
you can try to run SQL profiler tracing and find the cause.
or
you can also try to see if any blocking
Try following this steps in order to tune up your SQL: blogs.msdn.microsoft.com/.../microsoft-dynamics-navsql-server-configuration-recommendations
Good luck!
Ethem,
I believe those are SQL system tables which contain metadata information about other tables, i don't think that is causing an issue in your scenario.
Does the client locks on a certain operation ?
I found somthing. When Navision RTC opening, db locks sysallocunits, syscolpars, sysidxstats, sysrowsets, sysrscols, sysschobjs objects. In that time navision service stop response.
Why this object is locked when opening?
Do you have schedule maintenance at that time or any job queues are running at the time ?
I cant find any thing in event viewer.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
