-
Problem with Automatic Block Detection (SSI Version)
Hi, I have a problem with the Automatic Block Detection tool, maybe someone encountered the same problems. (http://dynamicsuser.net/blogs/stryk/default.aspx) It is running fine for a while but all of the sudden it is not writing anymore the tables and idexed into the log-table. There were no changes on the server during…
-
MaintainSIFTIndex in primary key
The customer runs 3.70SQL version with approx. 50 users logged in on average at a time, database size fast approaching 100Gb. Some time ago they suddenly complained that one of bespoke routines (exporting Sales Invoices) runs very slowly. I debugged the code and discovered that it takes almost a minute to perform a line of…
-
Database Sessions, NAV performance
Hello all, When we experience performance issues with NAV I usually check database information, sessions, current sessions to check if a user is performing some task that is bogging down the system. Are there other ways to identify processes that slow the system? I'm relatively new to NAV admin. Any advice is much…
-
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…
-
Index Hinting - Default Setting
I'm having a bit of a brain cramp this morning. In version 5.0 SP1 is IndexHinting ON or OFF by default? I'm chasing a performance issue in a 4.0 to 5.0 upgrade and the process keeps running back to the clustered index.
-
Stripe disk for more perfomance?
Hi We have a 40GB db and some 75GB disk with RAID 1. The file is small enough for one pair and it grows not much. Should we stripe other 75GB pairs to spread the data over? Does it bring more performance or is it negative while large tables are splitted up? Thanks for a tip Jan
-
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…
-
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…
-
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…
-
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…
-
running NAV & SQL 2005 in Virtual Server for Life
Is it recommend to run Life NAV with SQL 2005 in a Virtual Server ?
-
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…
-
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…
-
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 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-[
-
SIFT on SQL in 5.0 SP1
Checked around, saw folks referring to the SIFT change to index views, but wasn't sure there was a good thread outlining the changes. Since I came across a blog that did just that, reposting / linking here. From: http://blogs.msdn.com/ukdynsupport/arch ... 0-sp1.aspx There's also a Webcast on May 6th covering this topic -…
-
SQL 2005 Performance Issue
Experiencing random system hangs when scrolling thru list forms. Example: 1. Open Customer Card and press F5 to open Customer List. Scroll to buttom of list then start to scroll up. Sometimes it works fine, others it will take 30 seconds+ to move up 1 customer. Also similar behavior in other list forms with larger record…
-
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…
-
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…
-
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…
-
SQL Performance while Posting Item Tracking in Output Journa
Hi, when we are posting one Output Journal line with 5000 pieces and item tracking is active (means 5000 serial no. are linked to the Output Journal line) the system needs round about 2.5 hours time to do the posting. We are using SQL 2000 and NAV 4.00 SP3. Does anyone have any idea why NAV takes this huge amount of time…
-
Performance problem
Hi. I'm working with version 4.0 SP3 with SQL Server database. Sometimesn, I found in some clients very slow performance. When this happens nobody is doing any special process in the database as we are just beginnig the user trainning and the rest of users are not working with Navision yet. Checking Database information ->…
-
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…