NAV 2009 Security Sync SLOW.....
sil21
Member Posts: 55
We have a NAV 2009 installation on SQL 2008. The Nav and SQL are on separate boxes. The syncing of security, no matter where you do it from, takes about 90 minutes for 30 users... It seems way too slow. Any idea what could improve this performance ?
0
Comments
-
Switch to standard security model.David Singleton0
-
David Singleton wrote:Switch to standard security model.
You mean Simple, right?Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Security Models: Standard, Enhanced
Recovery Models: Full, Simple, Bulk-logged
I know, hot here in California today
--
Soren
http://gotcal.com0 -
[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Alex Chow wrote:David Singleton wrote:Switch to standard security model.
You mean Simple, right?
Actually I can never remember the options, and was guessing, but this time looks like this time I got it right.David Singleton0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 323 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
