-
Database file grown and performance decreased after Optimize
Hi! We run Windows 2003 Server with SQL Server 2000 and Navision 3.70. All this is in virtual environment VMWare ESX Server and EMC SAN. We have a production database which is 123 Gb size and a test database which is a copy of production database. We have run a Table Optimizer from Navision on test database and we've…
-
Database Performance
Dear concern one of my client using Navision SQL Database and their database size is 35GB.They have 2GB RAM in server and their Database performance is too slow.Plzz guide me that if I will increase my RAM.Will it improve the performance?
-
Effective Troubleshooting
Hi All A general question about troubleshooting sql-performance... Let's say you have a database with lots of users and a lot of Full Scans / s... according to the Windows Performance Monitor. What's the fastest / most effective way to find out, where the trouble actually comes from? I guess the first thing to find out is…
-
Slow FIND/FILTER on 3.60 SQL under 50SP1 client
Hi: We have a few fairly large tables - Vendor Ledger Entry (1.2 million records) and Job Ledger Entry (3.1 million records). When using a non-primary key (e.g. "Document No, Document Type, Vendor No." for Vend Ledg Entry), FINDs and FILTERs under the 5.0SP1 SQL client are very slow - e.g. 20 seconds to find one document…
-
No. of concurrent users caused of locking?
Hi Guys, Good Day! I face a problem right now on Table Locking which is unusual to me, when I post one sales invoice it's fast when i'm the only one who login in database, but if there some user's logins the posting of invoice is too long then it will cause the locking because of long process. please advice. we use SQL…
-
Performance - NAV 3.7
Hi, One of our client is using Dynamics Nav 3.7 (HF(IN) – 5IN, HF(WW) -19 ) in SQL Server 2000. There are 85 Licenced users.When concurrent users posting the Transactions(Order,Invoice) we face Stand still situation in the application. Can u help me to solve this? Thanx in Advance. :D Regards, Sujatha
-
NAV 3.7 with SQL 2000 - Performance issue
Hi, One my client using Nav 3.7 with SQL 2000 (No Service Pack). No of users are 85, out of which around 55 users are online. Volume of sales invoice is 1000 per day and total transaction is 1500 per day. Posting process is very slower as well its blocking (lock) frequent ( one or two times a day). Could u please suggest…
-
Inventory Valuation to SQL report Performance
Hello I decided to write the Inventory Valuation report on sql server. I translated the report into sql query. The data returned is correct and I've run multiple test and compared the numbers as of certain dates. I did all the testing in Cronus and then tried to run the report on bigger database. The query was going 100%…
-
SQL 2005 64bit- Nav 5sp1 SLOW
Hi, I am implementing Nav 5ps1 with Tectura Life Science add on. Golive is in April 2009. I have been having slow performnce on a beefy SQL server 2005 box where, when I refresh a Production Order, it was taking 5 minutes to run! ouch. The same db on the Native Nav db took 10sec on a laptop! The consultant cannot provide…
-
Typical SQL tuning problem.
So Still on Version 3.6 (5,00) here. The questions I have before you read the following are: 1) What else can I try and 2) How can I tell what index SQL is actually using in the live system, to see if it matches what the execution guide tells me it will be using? Having a bit of trouble with performance on tables 17. From…
-
Performance improvement from 3.7 to 4
Hi, It is said that there will be performance improvement in 4.0 compared to 3.7. How can i prove this point?? please help :?
-
Archiving or Date Compression of large tables
Hi, happy new year 8) We have an pretty large db on SQL (approx 330 gig). And after about a year of postings we are looking into either archiving (moving) or std. Date Compression i NAV. Its now primarely the AdjustCost routine that is taking too much time... Has anyone any suggestions about how these things are solved? ex…
-
SQL Server 2005 Database sudden Growth
Happy New Year all! Hope some can shed some light on this problem. I've been investigating a NAV 4.02 SQL server system (2005). As a first pass I altered the Maintance Plan. I added an Index defrag nightly task (and update stats), also rebuild the index with 10% free space. The database has since gone from about 30Gb to…
-
NAVISION 4.0 SP3 WITH SQL SERVER 2005 SP3
HELLO. WE HAVE UPGRADED SQL SERVER 2005 SP2 WITH HOTFIX 11 TO SQL SERVER 2005 SP3 AND THE PERFORMANCE OF THE SQL HAVE FALLEN IN A WAY THAT IS ALARMING (WITH ONE USER, IT TAKES MORE THAN 1 MINUTE REGISTERING A TRANSFER BETWEEN WAREHOUSES). ANY SUGGESTIONS???????
-
Deadlock encounterd
Hi, please help me understand this ERRORLOG: Deadlock encountered .... Printing deadlock information 2008-12-26 10:28:52.17 spid1 2008-12-26 10:28:52.17 spid1 Wait-for graph 2008-12-26 10:28:52.17 spid1 2008-12-26 10:28:52.17 spid1 Node:1 2008-12-26 10:28:52.17 spid1 KEY: 7:177904201:1 (ffffffffffff) CleanCnt:2 Mode:…
-
Database size increasing hugely
Is any one experienced this problem Client using Nav 4.0 SP3 & SQL Server 2005. For every 1 to 2 months the database size increasing drastically (last month it reached to 30GB). When we do Navision restore from proprietary backup (not SQL backup), database size shrink to 3 or 4 GB and works fine. But when we do SQL restore…
-
SQL 2005 performance on WMware
Hi Does any one have experience with running SQL 2005 on WMware? My problem is DynamicsNAV is running slow, the database is installed on SQL 2005 on WMware and I don’t know anything of how to increase performance on the SQL server in this environment. It takes the NAV database is five times longer to do a job on the SQL on…
-
Disabling SIFTLevelsToMaintain
Hi, Our Client is running on 3.7. We face performance issues quite often now. I went tru most of the posts here and learnt that If I have keys defined as below: 1.Key: G/L Account No.,Posting Date. SIF : Amount,Debit Amount,Credit Amount,Additional-Currency Amount,Add.-Currency Debit Amount,Add.-Currency Credit Amount.…
-
Sql Server Performance
Hi, In Sale order/Sale Invoice when using lookup to select a customer the application is getting hanged. can any help me out to find a solution for this problem? :?
-
Nav 3.7 with Sql 2000 performance
One of my client using Nav 3.7 with Sql 2000 database. Frequently database getting hang while positng sale invoices. Number of users is around 50, around 30 users loging through VPN connectivity. Volume of transaction is huge at anytime. Is anyone tell me any problem with SQL 2000 database while using huge transaction at…
-
Multiple SQL Data Files and NAV
We have a RAID 10 Array that is almost full. We would like to add an additional RAID 10 array to the drive enclosure and add another secondary data file to store on this array. We haven't split the NAV database into multiple data files before and are not sure if this is recommended or supported. Has anyone done this before?
-
SQL problem
Dear concern Now one of my client using NAVSQL database,firstly they were using Native database,now there speed is too slow then earlier.what can I do to increase their speed??????????????? _________________ Vikram Dabas Navision Technical Consultant
-
Cores Vs Sockets
Has anyone done any specific comparisons between Cores and Sockets and SQL specifically related to NAV. For example comparing one server with 2 Dual Core CPUs to a similarly configured machine with a Single Quad core, or even four single core processors. basically in a NAV environment, does 1x4 = 2x2 = 4x1. 4 sockets in…
-
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…
-
Error when trying to create a backup
Here is a situation: i am trying to backup a SQL based NAV database. But getting this error There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1
-
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…
-
SQL Database fine tuning
Hi, We are using Nav4.0 SP#3, with SQL database. we are Electronics Manufacturing Co., Inventory transaction is very huge. In our Item master there is 12k to 15k item, BOM is approx 4k and each BOM has approx 400 lines, we have multiple Prod. Floor. We are using Manufacturing, Inventory, Purchase, Sales. In item ledger…
-
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
-
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…