-
Plan Freezing feature in sql 2k8
Hello I read that sql 2k8 has a new feature called "Plan Freezing". SQL Server 2008 enables greater query performance stability and predictability by providing new functionality to lock down query plans. I was wondering if anybody has implemented this for a NAV db. thanks.
-
Slow Sales Order entry
Hi, We are implementing Nav 5 sp1 with SQL 2005 sp3 (64 bit). The server has 10G of ram and has no load on. It has a couple of users at best and even with no users its still slow. It has been a clean install with the platform 1 update KB956161 applied. I'm creating a Sales order and when I type in the customer number,…
-
Transaction Log File- Monitoring
Hi, How do I identify the transaction log file been extended in SQL 2005? I know this is not a god thing to happen and can be prevented by making it big enough and backing it up etc, but I'l like to know how fast it grows and heaven forbid, when it gets extended. How do I defrag the TL? Can I do it online, or do I need to…
-
SAN or NAS (Network Attached Storage) for SQL
We are going to implement SQL on out HO database and we are looking to see what platform is better for Navision, SAN or NAS (of course to add to confusion this is not the NAS we all know and love but rather Network Attached Storage :D ) Anyway it appears that SAN and NAS are very similar - has anybody out there got SQL…
-
Performance problem
Hi, I am having problems when searching my database. I can choose to search in any combination of: Title, Description or Tags. Searching for any combination except Description and Tags gives subsecond response times. However, when searching in Description and Tags (or Title, Description, and Tags) I get 14-15 second query…
-
What's wrong with this query? What makes it inefficient?
(@P1 varchar(20))SELECT TOP 1 * FROM "customerdatabase"."dbo"."Company$CustomEntryTable" WHERE (("Source Document No_"=@P1)) ORDER BY "Source Document No_","Line Identifier","Quote Quantity","Entry No_" It looks perfect to me - the ORDER BY cause seems to suggest we are using the correct SETCURRENTKEY. Still I got…
-
Migration: SQL 2008 To SQL 2005
Hi All, What are prerequisites for the migration from Nav2009[ SQL 2008 ] to Nav2009 [SQL 2005] ? Kindly reply.
-
IC partner code in Microsoft Dynamics Nav 5.01
Hi I have just upgraded a client's system from Navision 4.03 to Microsoft Dynamics Nav 5.01 using Developer's Toolkit and then migrated all their data on this new version. While running form Sales Invoice, I'm getting an error message " Reference to the member of IC partner code of the variable could not be solved" Can you…
-
Contact Search can take up to 30 minutes
In the Contact Search Form, I put the following in the Find What field: @regina|@kim (search area: Contact, contact type: Person, Exact Match not checked) I turned client monitor on, and 30 minutes later it returned the result set. Client Monitor (had every monitoring option turned on) returned nearly 1 million records. I…
-
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…
-
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…
-
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?
-
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
-
Navision Performance
HI My Client is having a Navision 4.0 with SQL Server 2000 And they have very serious problem with performance i was studying the Pdf that is related with performance issue they suggest some fobs Like Session Monitor (Navision Server) Session Monitor (SQL Server) Activity Log Sample use of activity log Client Monitor From…
-
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 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…
-
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…
-
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…
-
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 :?
-
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…
-
The NAV/SQL Performance Field Guide
Hi all! Even though I already "blogged" about my little book, I would like to boldly announce it here, as well: I published a little booklet named "The NAV/SQL Performance Field Guide" which should be availabel by now; e.g. via Amazon, etc.…
-
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…
-
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…
-
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…
-
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? :?
-
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…
-
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