-
Slow After Upgrade
Dear All, I upgraded nav from v3 to v5. Now my nav db is in v5 and i noted for certain customized form that i created b4 is running slow after upgraded and this is not happen in older version. As an example: i got Form A and when the time i click on menu button on the form itself to called another form(Form B) by apply…
-
Locking Issue again
Hello experts. Trust me, I have searched but I'm not sure that I've found (or understood) the answer I'm looking for. :? I have Navision 4.0Sp3, running on 64-bit SQL Server 2005, with about 60 users. I am having problems (as most seem to) with records (or tables) being locked and causing user problems. Most often it seems…
-
Performance problems in NAV 5.00 SP1 on SQL2005
Hi all, we are experiencing a great performance problem in NAV 5.00 SP1 running on a SQL 2005 database. The problem arises when a user applies a filter on any standard form. Sometimes it has to wait more that 100 seconds in order to see the next record list when it press PagUp or PagDown or simply using the mouse…
-
NAV 5.0 ACIE TAKE 20H OR MORE!
HI , the situation is NAV 5.0 ,SQL 2000 (sp4), all mdf,ndf,ldf files' size is total 2G,Runing ACIE would take 20Hours or more ,even down . but when I restore the same backup file to NATIVE database ,it just would take 18 Min. to runing ACIE for same data. As I know ,the special option is That:Warehouse -> Setup->Inventory…
-
running NAV & SQL 2005 in Virtual Server for Life
Is it recommend to run Life NAV with SQL 2005 in a Virtual Server ?
-
Navision Keys <> SQL Index's
Hello All, In version 4.x we were told that creating sql index's independent from Navision. (That is we would have 5 keys in Navision that were created and managed inside Navision and those 5 plus lets say 2 others created specifically inside SQL manager.) that Navision could become "out of sync" and require an object to…
-
Doubletake
Is anyone using this software or anything like it? It makes a mirror copy of the server on a disk block by block basis on to another server, so it can be used in case of failure. It seems to me that a block level disk transfer has to have a noticeable affect on performance. Unfortunately the server being protected is RAID…
-
Nav 5 generated Sql Query very slow
The following change between 3.7 and 5.0 is causing reports to run massively slower. Navision 5 is generating the following query (90,000 reads average) :- SELECT TOP 985 * FROM "CPNAVISION020708"."dbo"."Company$Project Job Ledger Entry" WITH (READUNCOMMITTED, INDEX("Company$Project Job Ledger Entry$0")) WHERE (("Job…
-
SQL 2000 to SQL 2005 migration - vey slow
Hi, I have restored the SQL backup of NAV database from SQL 2000 into SQL 2005. It has become very slow. Posting is now taking 15 minutes, earlier it was lass than 1 min.........please help 8-[
-
Performance Matrix For Navision
Dear All, Can any body give me the performance matrix for navision. Please advice
-
Navision SQL Slow On v5.00 After Upgrade From 3.70
Hi, After upgrading a SQL 3.70 database to 5.00 we are finding several custom reports are running considerably slower. Looking at one individual report, the table structure and all indexes are identical in both versions, but the speed is much slower running on the same SQL 2000 server under the version 5 client. I know…
-
Select converts WHERE '3687712' to LIKE '[3³]6877[1¹][2²]%'
Hi, i'Ve got a strange behavior of my SQL2000 Server with german Navision 4 SP3 (logical 3.70). on 2 "big" tables (687.208 / 727.736records) (110 Sales Shipment Header & 112 Sales Invoice Header) with code(20) as primary key, i've got since some weeks a strange rise of answertime. The Steps: open the posted Sale shipment…
-
question about SQL-MDF-Files
Hi all, i have a SQL 2005 64bit machine running. All Navision-data are in one single MDF-File on a 14-Disk SAN. the size is qurrently about 160GB would it improve performance if the data would be stored in smaller data files (but on the same SAN) or is the file size no reason for low performance? if yes: how can i sparse…
-
Pageiolatch
One customer have problems with occasional several pageiolatch_ex and pageiolatch_sh causing blocks in the database. I can see in activity monitor several wait type pageiolatch. SQL-server 2005 (9.0.3200) Navision klient 4.03 no hotfix Users is around 140 logged in. DB contains 27Gb data. Where do I begin?
-
MaintainSQLIndex
Base on Resource Kit I read "dont maintain indexes that are only for sorting purpose because sql server just need the indexes for data-retrieval". rec.setcurrentkey(A,B,C); rec.setrange(A,1); rec.setrange(B,2); rec.setrange(C,3); if rec.findset then repeat until.... for this key(A,B,C), I set MaintainSQLindex = No. from…
-
SAN and disk virtualization - does it really work ?
Hi All, I've got recently quite nice SAN in my hand and tried to configure it for SQL. The SAN is equipped with 24xSATA 500 GB disk. I had many chats with vendor's technical support guys. They always tried to convince me - create just one big array across all 24 disks, and then create two separate volumes as this allows…
-
Optimise Navision
Hi guys, i'm not an expert in SQL, but i need to stop runnig Optimise Tables from Navision and relpace it with something else that will be run at the SQL server side as scheduled Job. So i found Stryk SP ssi_delzerosift, but i read in the Mibuso site that deleting SIFT record may cause Flowfield calculation troubles. So…
-
Performance issue with 5.0 sp1
Hi, I've upgraded my Navision installation from 4.0 sp3 to 5.0 without performance issue, then from 5.0 to 5.0 sp1 with very very performance issue... I've read that 5.0 sp1 uses Index Hint by default, but by trace from my Database I don't see any hint. Can this issue caused by new sql Pre-Processing way to execute…
-
NAV5 SP1 SQLindex property - all entries removed from NA
When I first downloaded NAV 5 SP1, there were almost 220 SQLindex entries (where NAV had changed the SQL index from the NAV fields). I complained to an ISV that there release had removed the SQLindex entries. They explained to me that Navision had removed them. I downloaded the release again for North America and all the…
-
Nav client uses network different to SQL Server
I'm a navision newbie, so I hope this question makes sense. If the query Select * from Sales Header is run in SSMS from a client, then I can see the 150MB of network traffic to give me all the fields for all the records from the SQL server to my pc, but when I open a list form based on the sales header table and jump to…
-
Performance in SQL
Hello. I have a customer working with Navision 4.0 SQL version for one year and a half. When database has become larger some tasks are getting too slow (such as displaying inventory in item's card). Is Optimize the only way to improve performance in SQL?. Is there any other options or whitepapers to read about?. Thanks so…
-
min memory per query on SQL
Has anybody have any experience with Navision and "min memory per query" on SQL server? Could you write your experience? Thanks.
-
Autoincrement in ledger tables
I have reviewed some of the previous posts about autoincrement. Also asked a Microsoft employee about it. His comment is the current locktable method will stay as long as there is a native database. Jörg A. Stryk wrote that he had implemented autoincrement, but added GUID as the clustered index to avoid locking problems.…
-
System Performance - SCSI vs SAS
Has anyone done any comparisons in the performance difference between SCSI and SAS drive systems? We are running two upgrades (of the same 160 GB SQL database) on two different servers. One server has SCSI drives the other has SAS drives. The SCSI machine has a lot more drives. The SAS machine is running at close to 3 time…
-
SQL Server hardware configuration
Our local Microsoft Navision SE (this is a Microsoft employee in the local sales office) is recommending RAID 10 for the log file. This is counter to every recommendation I have seen of using RAID1. He says RAID 10 is always better than RAID1. Since the log file is written sequentially, would RAID 10 actually help (and not…
-
NAV 4.0 SP3 hotfix 6 (build 25143)causes slow SELECT
NAV 4.0 SP3 hotfix 6 (build 25143) causes slow SELECT cursor on big table We have an issue with a simple cursor on a select query of a big table (700.000 rows) that has a very bad performance on NAV 4.0 SP 3 hotfix 6 (build 25143). It performs well with NAV 4.0 SP3 without hotfix. A simple NAV form with two columns of this…
-
Perfmon
In BOL, they refer you to Windows for explanation of the PERFMON counters. In Windows, they tell you they are SQL Server counters. Using google and technet, I can come up with some explanations of the various counters, but nothing that addresses everything. Has anyone seen an exhaustive explanation with examples that…
-
SQL Locking
Navision Version 4.0 SP3 I've a question about the locking in NAV 403 on a SQL2005 database Always rowlock = Yes If we look at the following code, we see that we want to change the record recWhseJnlLine. That's why we've used the findset(true,false) The result is a locking of 9 records. There are 9 records which comply to…
-
SQL Performance
We have 90GB database running in Native Database, we want to convert it into SQL server 2005 and we have also 41 user. Can any one sugest us what is the minimum hardware configuration for running and convert the database in SQl 2005 smoothly.
-
I've realized something important about performance
Say you are using 4 dimensions which can roughly be considered the average, common case... and you post a shipment & invoice. It inserts 10 Item Ledger Entries and then 40 Ledger Entry Dimension. Then 10 Value Entries and another 80 Ledger Entry Dimension. A couple of G/L Entries and, guess what, 4 times a couple of Ledger…