-
Flowfield slow for count type on NAV5SP1 SQL Server 2008
I have a customer database running under NAV 5 SP1 and SQL Server 2008. When I ran a table to analyze data, it was extremely slow to come up - about 15 minutes, then a 10 second wait to move to a new line. The table has a number of flowfields including several that use flowfilters. By process of elimination using a list…
-
SQL Server Cofiguration
Hello Experts, I am running Navision 5.0. Over the past few months, it has been running very slow. I am going to make a new configuration of the db Server in order to resolve make it running quickly. Data Base Info: Database Used (KB): 38,810,624 (47%) Database Size (KB): 81,960,960 With licence of 30 users. Server Specs:…
-
Slow delete from Reservation Entry Table
We have a client that receives and ships using Lot numbers. Over the years, the Reservation Entry has become quite large. Now it takes forever to run the Requisition Worksheet. When using the client monitor in addition to the SQL Server Profiler, this statement seems to be taking a long time. DELETE FROM…
-
Performance degrade of a report after upgarde frm 3.7 to 5.1
Hi Experts, I had a DB which was in 3.7 (SQL 2000), which was recently upgarded to 5.1(SQL 2005) Now there is this customized report which was running without any issues in the 3.7 version, which now when imported into the 5.1 version without making any code or property changes has a severe performance issue. It is taking…
-
Technical Upgrade NAV5.0/Native -> NAV5.1/SQL
We have a customer that currently runs NAV 5.0 with native db. Now they want to switch to SQL2005. Wouldn't it be worth the effort to do a technical upgrade to NAV 5.0 SP1 at the same time to take advantage of the new enhancements in 5.0 SP1 regarding to SQL performance (e.g bulk inserts, indexed views etc.)? The customer…
-
Multiple NAV SQL dbs on Production server setup
We are a large international company and use multiple production Navision SQL instances (NAV 4, 5 and 2009). We have about 500 users evenly deployed across mainland Europe and the Americas. The usage time is during normal business hours locally. We have 12 instances ranging from 2GB to 100GB. We are migrating to a new SAN…
-
List form selecting every field causing slow performance?
We have a database that is on version 3.7B but the executables are upgraded to NAV2009 SP1. Everywhere in the system, the performance has increased except for the item card and the item list. The performance on the item card and list has severly decreased in performance, it takes roughly 3-4 seconds when I click on each…
-
Dynamic cursor behaviour
I just wondered about something: We know that NAV (the latest NAV version and we have some exceptions anyway. But I am not going into this now.) uses dynamic cursors for getting records. And we know that SQL in this case looks more at the ORDER BY clause to decide which index to use. And we also know that SQL looks more at…
-
SETCURRENTKEY, SETFILTER
I'm upgrading to Client v5.0. Is it still recommended to SETCURRENTKEY & SETFILTER for all key fields for optimal SQL performance or is Nav/SQL now smart enough to figure that stuff out? Thanks, Mega
-
Developers Toolkit Performance Tuning
At a customer they run the DevTookit DB on a SQL2005 Server. The ToolkitDB runs since several years in different versions. Currently the Toolkit is V3.01.0410 and the DB was updated to NAV2009 (no SP) coming from 4.03. I checked all objects in the DB and they do match the objects from the FOB MS packages with the current…
-
Specific Tables on Specific Drives
Please bare with me as I am not a SQL or hardware expert by any stretch. Hoping to learn as we go through this, though. We are currently on SQL2000 and Navision 3.7 but will be moving to SQL2008 and NAV2009SP1 very shortly. We have 125+ users and a 100GB+ database. Currently the data all resides on a single disk. We have…
-
Strange Navision reactions on SQL2000
Hello, We are sometimes facing a problem with performance of retrieving open Purch.Rcp.Lines in Form 51 Purchase Invoice. The most of the time it works fine, performance is good, but in some cases (could not identify any logic) Navision begins to read thru all Receipt Lines witouth using the right key set in setcurrentkey.…
-
Nav 2009 vs 5.0Sp1. performance
Hi, I have simple question about performance in NAV 2009 with New client (RTC i think). Is it working faster than standard client in NAV 5.o SP1? I mean, If some report generate 30 minute can I expect it will be faster?
-
SQL2008 – Results from Activity Monitor
I have only one SQL customer using SQL2008, so I tried the new Activity Monitor which shows several interesting figures about the server. I especially noted the Resource Waits area, which lists statistics from 10 different wait categories. I’m currently optimizing a heavily customized NAV solution where a few central…
-
SQL Uprade from 2000 to 2005 on NAV 4.0 SP3 YES OR NO
Hello All, in the past few weeks i went all over this forum to search any topics related to upgrade/don’t upgrade the SQL server that my organizations has, we use now NAV 4.0 SP3 with sql 2000 and everything works pretty much fine...we plan now a hardware upgrade and i was thinking that its a good opportunity to upgrade…
-
Slow response time through TSE
Hi, We have the following installation : 4 companies, 2 databases (2x2 companies) Each SQL DB is hosted on a different SQL Server. SQL1 has 16 gb RAM SQL2 has 4 gb RAM Both SQL Servers runs : Windows Server 2003 R2 SP2 Microsoft SQL Enterprise Manager V8.0 NAV 3.70 The Network cards are the same, with the same driver. The…
-
Deleting Keys
Does any one know how I can delete keys from tables other than designing the table in object designer and deleting it from there? I know there is a Key virtual table where you can see all the keys of all the tables. But I can't delete keys from there, I am getting permission errors. At the same time I can run Field virtual…
-
SQL Server Profiler - sp_cursorexecute - High read values
Hello, We have a little preformance issue with a navision db. The Navision has a own written querry that shows all historical data of a customer purchases. When we open this querry it can last up to more than a minute before the screen starts to build up. When we look with SQL Profiler to the made reads/writes we see that…
-
NAV 2009, Indexed Views and SQL Server 2008 Standard
The Edition Comparison chart at Microsoft says that SQL Server 2008 Standard does not support Indexed Views. http://www.microsoft.com/sqlserver/2008 ... mpare.aspx I am running NAV2009 on SQL Server 2008 standard and wondering if this is impacting my performance. The same comparison chart for SQL Server 2005…
-
SQL 2005 & 2008, same data & SELECT -> Diff. Execution Plan
I’m currently optimizing a solution which is used by different customers on both Native and SQL2005 and SQL2008. My focus so far has only been to ensure that Native and SQL both performed fine, but now I just encountered a difference between SQL2005 and SQL2008. I have two databases with the same data and same statistics…
-
Transaction LOG Backup getting locked?
Hello, I have been monitoring blocks in SQL server to try to understand what queries are creation blocks. I see that the Transaction Log Backups are getting blocked. I have a maintenance plan that creates Transaction Log Backups every 30 minutes. Does those backups can create locks or get locked by another user. In my…
-
Alter Database Settings Issue
hi, Our Client systems are reported to be slow these days. i think its due to very low free space. Currently database Used :88-90%. We are working on nav 5.0 with sql server 2005, DB settings are : Primary datafile is 120MB, File Growth -1280% & unrestricted growth TRUE Secondary datafile 1699MB, File Growth -10240KB &…
-
Why would NAVIGATE cause a block/deadlock
Hi Everyone, Like many of us, we're starting to have record blocking issues, particularly during posting, e.g. "The G/L Entry table is locked by another user...". However, my users are now getting this same message when they click "Navigate" on a posted item. e.g. go to particular vendor ledger entry and click "Navigate".…
-
Speedup performance of database
Hi, We are a Navision customer for 4 years and started with the classic version and are now using the 5.0 SQL version. We do most of our development ourselves (just changing/creating reports). Our database is growing by the minute with on average 400/500 orders a day (5/20 lines). Are there consultants we can help with…
-
Very slow NAV 5.0 with SQL2005
Hello, I'am working with Dynamics Nav 5.0 with SQL Server 2005,it's going very slow with a lot of Lock error!!! :-k For more information about our System: Hard: Intel Xeon Quad 2,5GH 6GB RAM Network 100MB of speed 3 logic partition of HD 400GB Soft: Widows server 2003 R2 Our DB has: Used Space:94,2GB Reserved Space:104,2GB…
-
Poor performance of SQL view
I've created a view which joins Item, Item Variant and Stock keeping unit tables. When running it from SQL 2005, the performance seems ok but from the object designer you can almost see each record being fetched. Has anyone else experienced the same issue? (System is based on NAV 5 sp1) Thanks Simon
-
SP1 List form performance
Since upgrading from 4.0 SP1 to 2009 SP1, my customer list form is performing HORRIBLY. We are a retail company so customer lookup performance is critical. The lookup form is sorted on the Searchname key. We use SQL2005, the classic client. Not sure if this is part of the problem but we use a SQL Collation- Binary sort…
-
SQL Server Optimization for nav2009
Just found this, thanks to RSS if you didn't already know about it https://mbs.microsoft.com/partnersource/communities/training/trainingmaterials/student/course80156.htm However, i haven't read it yet...
-
Extremely slow ISEMPTY, even with a good index???
SQL2008 (build 10.0.1600) with NAV5SP1-Upd1 (build 27191) I have a lot of ISEMPTYs that shows up in the Profiler as very expensive which I find rather strange. Example: SELECT TOP 1 NULL FROM "MyDatabase"."dbo"."MyCompany$Item Ledger Entry" WITH (READUNCOMMITTED) WHERE (("Prod_ Order No_"=@P1)) AND (("Prod_ Order Line…
-
SQLIndex
Hi everyone, i tried to search mibuso and google, too for a post of stryk, about a little trick to reduce index size: if i remember well, he told that for large tables sometimes he copy the field list of the key in nav in the SQLIndex field, too. in this way he can cut out the trailing PK fields that are automatically…