-
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.
-
Navision - DB files placement
Hello, can you tell me what you think about this? We are gonna to buy som new HDDs and will completely reinstall server .... We will have 66 HDDs. 6 of them will be spares, so I have 60 disks available. Server is HP DL 380 , 2xXeon (6core),72GB RAM, p812 controller, 16 int. HDDs, 2xD2700 external cages for 50 HDDs I was…
-
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.
-
optimize for ad hoc workloads
Any experience out there with this SQL option? I troubleshooting some performance issues that have cropped up in a larger system. One thing I noticed was a high plan count on a number of queries. Thinkign this may help alleviate that problem. Thoughts? NAV 5.01 Database NAV 2009 SP1 clients SQL 2008 SP1 Windows 2008 R2
-
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…
-
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…
-
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…
-
Serializable vs. Repeatable Read
Hi, has someone changed the default locking level from serializable to repeatable read? What are your experiences with repeatable read? Does it really reduce blocking? Did you have problems with phantom reads? Do you use it as a default for your customers (if you are working for a nsc)? How can I check in a test…
-
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…
-
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…
-
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…
-
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.…
-
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
-
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?…
-
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
-
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:…
-
Query Optimization
hi all, When I run the below query in the query analyzer and show the execution plan it is as follows: select <- sort <- clus. index Seek. SELECT * FROM "testdb$Prod_ Order Routing Line" WITH (READUNCOMMITTED) WHERE (("Status"=3)) and "Ending Date"<'2010-06-01 00:00:00' ORDER BY "Ending Date" DESC,"Ending Time"…
-
[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…
-
Frequent blocking in Nav on SQL Server
Our client has started experiencing lots of blocking, which is slowing down their system. They only noticed this on Tuesday, it wasn’t an issue before that. The blocking happens several times a minute, for just a few seconds each time. It is experienced by many different users, in different areas of Navision, with no…
-
SQL tuning - keys
Hi all, We have just migrated from 5.01 Native to 5.01 SQL, and probably have a lot of SQL tuning to do. I have a question about low/high selectivity and SQLIndex property. E. g on the Sales Header table we have a key: Document Type,Status,Sell-to Customer No.,Settlement Type,Week No.,Month No. that in my understanding has…
-
"Searching" dialogue box gone after Migration to SQL
Hi, I just migrated my client's database from Navision 5.01 Native to Navision 5.01 SQL. We are using SQL 2005 server. With binary code page 437 collation. Whenever we try to apply filter that is not in sync with the key set on the form, system shows "Not Responding" for some time and then it shows the data. Actually in…