# Dynamics 5.01 (SQL) open database too slow **URL:** \ **Category:** Developers Forum\ **Created:** [November 12, 2009, 12:14pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493 "2009-11-12T12:14:59Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Andy\_Malkin](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Andy\_Malkin](https://www.dynamicsuser.net/u/Andy_Malkin)\ **Post date:** [November 12, 2009, 12:14pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/1 "2009-11-12T12:14:59Z")
We have Dynamics 5.01 and an SQL database, and use Windows Logins. Recently we have added about 140 new Windows Users to the database, with on average 5 roles each. The Windows Login table now has 470 entries, and the Windows Access Control table 2400. The new users belong to a new domain, which is over a VPN (new users are in the US, and the database is in the UK). We have found that the time taken to open the Dynamics database has gone from an acceptible 5 to 10 seconds, to around 1 minute. Does anyone know the reason for this? Thanks, Andy ---
**Author:** ![modric](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@modric](https://www.dynamicsuser.net/u/modric)\ **Post date:** [November 12, 2009, 12:59pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/2 "2009-11-12T12:59:36Z")
Andy, If you are familiar with SQL management tools - you may trace the login sequence in SQL Profiler, this will show time consumed. Table sizes you mentioned, however, are next to nothing for SQL server, more looks like network (VPN) lags… BTW what do you mean by _open the Dynamics database_? When you start the Navision client, actually its “ready for work” long before hourglass cursor disappears, this behaviour is present from first version working with SQL DB. ---
**Author:** ![Andy\_Malkin](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Andy\_Malkin](https://www.dynamicsuser.net/u/Andy_Malkin)\ **Post date:** [November 12, 2009, 1:08pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/3 "2009-11-12T13:08:15Z")
Modris, I’m not familiar with SQL Profiler, but I too suspect it may be to do with VPN lags. But why should opening a database want to jump across the VPN? By Open a Database, I mean in the Navision Client, click File - Database - Open. It’s the time taken after you have done this, and before you get a chance to open the company, which is too long. Andy ---
**Author:** ![modric](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@modric](https://www.dynamicsuser.net/u/modric)\ **Post date:** [November 12, 2009, 1:26pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/4 "2009-11-12T13:26:23Z")
Well - you mean that lags now affect **ALL** users - your local UK ones, too, simply after you added those from US? Then it’s seemingly not Navision/SQL problem, but Win security mechanisms like AD, Domain(s) security and so on - ask you sysadmin(s) for help. But it’s a real “swamp”, where one can seek for lag reasons for ages… I myself had a problem in such environment, spread all over the world - after 3 months research our security admin found that Win (not Navision, but overall Windows) login lags in Europe in cases when Mexico City MS Exchange server is down - there was a complicated schema of trusted domains. It wanted to check something in Mexico, waited for timeout, as didn’t get the answer, and happily logged us in afterwards… At least I had time to go & prepare the morning pot of coffee [:D] ---
**Author:** ![Andy\_Malkin](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Andy\_Malkin](https://www.dynamicsuser.net/u/Andy_Malkin)\ **Post date:** [November 12, 2009, 4:36pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/5 "2009-11-12T16:36:33Z")
Modris, Thanks for your opinions and ideas, we will look at the problem from the Windows network angle, and hopefully find out what causes the delay. Andy ---
**Author:** ![David\_Singleton](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/david_singleton/32/7471_2.png) [@David\_Singleton](https://www.dynamicsuser.net/u/David_Singleton)\ **Post date:** [November 12, 2009, 5:19pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/6 "2009-11-12T17:19:54Z")
Do I understand correctly that Nav users in the US are logging into Navision server in the UK via the VPN? If so this is wrong and you need to go to a TS or Citrix solution. ---
**Author:** ![Andy\_Malkin](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Andy\_Malkin](https://www.dynamicsuser.net/u/Andy_Malkin)\ **Post date:** [November 13, 2009, 2:33pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/7 "2009-11-13T14:33:14Z")
David, The users are using Citrix to get to the Navision server - thanks for the thought. ---
**Author:** ![modric](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@modric](https://www.dynamicsuser.net/u/modric)\ **Post date:** [November 13, 2009, 3:12pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/8 "2009-11-13T15:12:40Z")
Andy, Maybe your Citrix server is overloaded? In this case, however, lags should vary in time, depending of concurrent active user count… We use Citrix for reporting to HQ (not Navision, another system), corporate standards set MON 10am as deadline, and the hour before is thus VERY busy. Situation is as yours - very long logging in, even up to 5mins (!), but, as one gets connected, further work is going on at acceptable speed. Nobody managed to solve this up to now, server HW is really a “monster”, comm lines are high bandwidth, all in vain… ---
**Author:** ![Andy\_Malkin](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@Andy\_Malkin](https://www.dynamicsuser.net/u/Andy_Malkin)\ **Post date:** [November 19, 2009, 4:20pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/9 "2009-11-19T16:20:10Z")
Modris, We have got our support company to investigate this with Microsoft, and the current suggestion is that we change the Security Model of the database from Enhanced to Standard. From reading this post: [http://dynamicsuser.net/forums/t/19622.aspx](http://dynamicsuser.net/forums/t/19622.aspx) I think the Enhanced model can cause problems, and gives minimal advantages over the Standard one. I’ll let you know the results. Andy ---
**Author:** ![MattTrax](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/matttrax/32/9408_2.png) [@MattTrax](https://www.dynamicsuser.net/u/MattTrax)\ **Post date:** [November 19, 2009, 4:32pm UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/10 "2009-11-19T16:32:16Z")
If your Citrix servers are overloaded and / or you are running on VMs then you can have serious slowness. We had Citrix servers designed for 20 users that were supporting 30 - 35. And on VMs that were constantly migrating between servers to “improve performance”. Needless to say, adding extra servers to support the VMs and extra servers for Citrix sped things up significantly. ---
**Author:** ![TonyH](https://avatars.discourse-cdn.com/v4/letter/t/71c47a/32.png) [@TonyH](https://www.dynamicsuser.net/u/TonyH)\ **Post date:** [November 20, 2009, 12:34am UTC](https://www.dynamicsuser.net/t/dynamics-5-01-sql-open-database-too-slow/23493/11 "2009-11-20T00:34:34Z")
I switch off all Enhanced security for my customers, pain in the behind if you ask me. My personal prefrence is for TS over Citrix, I have had issues with Critirx and NAV before. Can you try getting a user to use TS instead and see if the improves the login time? t