-
NAV 3.6 with 3.70b run time running on SQL 2000 enterprise
Good Morning, Just want to ask if anyone had similar issue: We are running NAV 3.6 with 3.70b run time on SQL 2000 enterprise. The size of the database is about 92GB, with 30GB log file, RAID 10. It was not super fast but steady as it goes until yesterday morning. Users in the system now experiencing slow down and delay…
-
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…
-
DELETEALL-SQL Profiler How to optimize high number of Reads
Hi guys, i have turn SQL Server Profiler to view a why Planning Worsheet was taking about 2 minutes to make calculations to a single item, on a CRONUS database. I had detect some lines with this parameters SQL Profiler CPU - 187 Reads - 66820 Duration - 186 The SQL StatementDELETE FROM "Demo Database NAV…
-
Table Locking became major issue!!!!
Dear all, Am getting a Table lock error. Following are the options that i have tried to resolve table locking but i have failed 1. Set the transaction type to "Update Locks" in Property 2. Removed unwanted code and tuned it well. 3. Checked Option like Updating Statistics , indexing the Objects in MS-SQLand it is updated…
-
SQL Server 2008 Memory Allocation
Hi Everyone, I am having an Issue with SQL 2008 on a NAV Server. Ths issue is 75% of the server (4GB 32 bit) memory is being used by SQL server even when NAV is not really being used. Also NAV is the only application usnig SQL. Can you help Please ADARTIHS
-
Tables still locking after SQL LOCK_ESCALATION = DISABLE
Hi everyone, We are having some trouble with the Item Ledger Entry, G/L Entry, and Reservation Entry tables locking at different points in the day. It occurs when posting consumption or output, posting trucks, etc. While these are locked of course we cannot update invoices, journal entries, or anything else. I have run the…
-
Slow GL Drilldown
We have a site experiencing unacceptable performance when drilling down on GL Accounts. The database is not that large (25 GB) and I'd consider table 17 (4 million entries) rather small. Drilling down on an account with about 200,000 entries can take 20 seconds or longer to open and display. Issue exist with both classic…
-
Adjust cost item entries takes hours to run
We have implemented NAV 2009 (No SP) with SQL server 2008 enterprise edition. It is installed on a server with 64 bit windows 2008 operating system. The server has 16 GB RAM. The client is into distribution business with 35k SKUs with FIFO costing. When we run the Adjust cost entries batch job, it takes minimum 2 hrs for…
-
Locking problems
I have some locking problems with a NAV 5 database. A lot of Clients (about 40 to 60) and 5 NAS are connected to the database. Since few days from time to time the users can not work because the table "Sales Shipment Header" is locked (sometimes other tables also affected but most of the time it is table 110). The fastest…
-
Deadlocking
Over the years I have resolved many deadlocking issues. Normally the problem stems from either an incorrect locking sequence of 2 processes or some bad code. There are all sorts of ways to solve deadlocking in NAV such as putting LockTables or Commits in the code, Optimzing the Code (using IsEmpty where possible so there…
-
Navision 4.0 SP3 is very slow in one company only
i am facing problem in 1 of our company data a database consist of 6 companies of navision, 1 company is facing slowness while opening gl total field in chart of accounts, any solution to the prolem.
-
UPDATE STATISTICS
Any ideas on ways to reduce the run time required for "UPDATE STATISTICS". Client is increasing their weekly operating hours and the maintenance windows are shrinking.
-
Passing a parameter from NAV into a SQL FUNCTION
Hello everyone, first of all I want to apologize if this problem is already solved in another Thread. I couldn't find any Posts neither discribing my problem nor giving a working answer for it. Also I am sorry if this Thread is posted in a false area in the forum. The situation: In NAV I have a table which is linked to a…
-
isolating tempdb vs. six-disk-setup raid10
Hi Community, in my company we use NAV V4 SP2 on a Windows 2003 Standard Server 32-bit with SQL Server 2005 SP2 Standard Edition 32-bit and the following hardware specs: DISK| C:\ RAID1; 2x 73GB (SCSI, 10k) -> OS, pagefile, SQL Server Installation with masterdb, modeldb, msdb and tempdb (mdf & ldf) D: \ RAID10; 4x 73GB…
-
Keys on Customer ledger entry
I am currently analyzing a database that has performance problems, and digging through the modified tables (i've not the availability of customer data, i'm just doing a first analysis) i've seen this keys in table 21: all maintained, No VSIFTS bold lines is a standard key my first thought was that the underlined keys could…
-
Performance slow after optimise table on SQL Server
Hi, I am using SQL Server 2005. I have a table that is used for reporting. This table is very big, and will probably grow to be the same size as a transaction table. This table has 29 keys. Out of which 1 is primary key, 20 is sorting keys and 9 are keys with sumindex. I have a report that takes about 3 hours to run based…
-
Key Performance Tool error
Hi, We're using NAV 4.0 without SP with SQL Option (SQL 2000 SP3a) I successfully installed "Key Information Tool".fob and setup SQL Connection (Test Connection succeeded) Load Text Objects didn't return any error but when we clicked "Get SIFT Info" threw an error like this: Any idea what's wrong? I tried with 2 tables…
-
Server Requirments
Hello Experts, We are going to implement Nav 2009 and to use Sql datatabase. We are reviewing hardware equipment if they support our transaction amount of data We do every day about 1500 sales orders with 10 lines( in total 15000 lines) and about 100 purchase orders with 30 lines in total (3000 lies). We have 40 concurrent…
-
Row Compression in SQL Server 2008
According to the MSFT SQL Server 2008 marketing material, row compression is supposed to help improve performance. I can see how it compresses the empty space out of the database, and reading Rashed's and Alain's blog entries can make a huge impact on file size, but I am skeptical about actual performance. If you are using…
-
SQL Options
Hi Chaps, Anyone seen this ? http://blogs.msdn.com/b/nav/archive/2010/09/28/microsoft-dynamics-nav-sql-server-configuration-recommendations.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+MicrosoftDynamicsNavTeamBlog+(Microsoft+Dynamics+NAV+Team+Blog) Only read a bit of it, but find it strange that Statistics…
-
Index Hinting
Hi All, Does Index hinting work in NAV 2009 Sp1 with Sql Server 2008. For Example see below: GLEntry.SETCURRENTKEY("G/L Account No.","Posting Date"); GLEntry.SETRANGE("G/L Account No.",'2910'); GLEntry.FIND('-'); the output in the profiler with index hint as below (IndexHint=Yes;Company=;Table="G/L Entry";Key="G/L Account…
-
Maintenance Plan - Rebuild Index Task and Update Statistics
Hi guys! I want to configure this 2 tasks on my Maitenance Plan. What configuration should i use on both tasks to improve Dynamics NAV performance? Best Regards
-
Running Large VLE
Hi All, I don't believe that there is a solution to this but would like to ask the question anyway. I have a customer that has a huge VLE that they would like to run from the object designer and then filter on the data to look for certain records. This simply hangs the system. I have just done a tech upgrade from 4 SP1 to…
-
NAV 5SP1 Very Slow on SQL Server 2008
Hi guyz; I don't know whether anyone has experienced this problem. We have implemented NAV5SP1 running on SQL 2008 to one of our clients and the system has become very slow 1 year down the line. We have implemented Financials,Sale & Marketing, Purchases, Warehouse, Manufacturing, Inventory Management and Human Resources.…
-
How to set up $ndo$dbconfig hint to get the desired result
Hi, In NAV2009 SQL on SQL2005, I'm having a performance problem in the Vendor Ledger "Apply Entries" screen. When the user clicks "Apply Entries" from the Vendor Ledger Entry card, it takes nearly 2 minutes for the "apply" screen to be fully populated and unlocked for entry. I've tried to read and understand the…
-
Execution time problem
Sorry for the title, i don't know how to name this topic, i'll rename it when i'll know something more: i have a strange behaviour of a funcition of mine in nav: i just finished to program it, and after testing it, i encountered some performance problems (i tested them by simply extracting the execution time before and…
-
Page Level Locking
Hi, Getting this error when trying to rebuild an index to a table. Executing the query "ALTER INDEX [IDX_Billto_SalesDate] ON [dbo].[Company..." failed with the following error: "The index "IDX_Billto_SalesDate" (partition 1) on table "Company$Sales Shipment Line" cannot be reorganized because page level locking is…
-
Vmware with NAV 2009 and SQL2008
Dear all, I've read the from the performance guide for NAV 2009 which based their testing on SQL2005 SP2 that results in some performance loss. Would there be any improvement of performance if NAV 2009 is used with SQL 2008 in a virtualised environment using VMware that would be on par with a physically hosted database?…
-
[HELP]Everyday performance issue
Hello! Everyday I face performance issues on Navision. I've read some posts about fragmentation and tried to look for it on the SQL Server Navision Database. My major issues are on the Warehouse entries and Item ledger entries tables. Every single day most of all keys have fragmentations over 70% or 80%, and for what i've…
-
Simple Question SQL Index
Nav 2009sp1, sql2005 hi everyone, i think this is a very simple question, i think: i want to create a new key on 2 fields, that are both option type --> not selective. There are no sumindexes on this index and i wanted to set the key like this: Key: OptionField1,Optionfield2 SQLIndex:…