-
After upgrading a 3.7 - to 5.0 I have a performance issue during restore on SQL. After upgrade a restore to a navtive db takes 6 min. When I do the same on my SQL server - the restore takes 4 hours! This is a db with 110 companies, but not very many transactions in each. Next weekend I will do the same...
-
Dear All, We have created 2 databases (one is in Nav5, other is in Nav6) in SQL Server 2005 (Window Server 2003). We have installed business notification server for Nav5 and trying to connect BN server. But it is showing the error: We have checked the dotnet framework version used for Business notification...
-
Hi Guys I am working in Navision 5.0 and we are looking in for a database migration from NAV to the SQL server . Can you let me know the procedure and method involved in it. As such i know how to restore database in SQL front and start working with a fresh database , but i have no idea on the migration...
-
Hello, In order to update Nav 3.6 sql option to Nav 5.0, my customer technician install the sql 2005 on the server on which are installed the old database(sql server 2000). he doesn't make a parallel installation but a upgrade. he doesn't make the backup of old database before. Now the old database...
-
this may help you. It is a stored proc that I developed to kill idle sessions: USE [YOUR DATABASE NAME HERE] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo] . [sp_KillIdleSpids] @sec int = 3600 as --1 hours DECLARE @ERR INT , @SPID INT , @CMD CHAR ( 255 ), @HOSTNAME CHAR ( 255...
-
Hi! Uhh ... so you have NAV Logins on instance xxx-xxx-1 even though there is not NAV database installed? To which database are these processes connected then, "master" I suppose? Can't you simply deny the login to this instance? And all these sessions are inactive, means AWAITING COMMAND...
-
Hi, the table is too long so some col just missing, actually when run sp_who2 there is a column name ProgramName this column will show you which app connect to the DB. The windows log looks OK. this problem just happened last week. the strange thing is NAV5 on the SQL server is in a different instance...
-
How did you determine that those sessions are established by NAV? It looks to me like there is a user called 'SQLService', which would indicate a service that is trying to connect. Is that a NAS instance perhaps, that is not able to log in? Did you check the Windows Event Log?
-
SPID Status Login BlkBy Command CPUTime DiskIO ProgramName SPID1 1000 sleeping XX\SQLService . AWAITING COMMAND 16 0 Microsoft Dynamics NAV Application Server 1000 1001 sleeping XX\SQLService . AWAITING COMMAND 16 0 Microsoft Dynamics NAV Application Server 1001 1002 sleeping XX\SQLService . AWAITING...
-
Hi, all I've got an interesting problem, current we are using NAV5.0, and Sql2005, the problem is these days I found out there are more than 1000 session established by NAV to the DB, however We only have around 45 users. When I use sp_who2 I found out the problem and the Command is awaiting command...