-
run adjust cost item entries are very slow on NAV2009
Does anyone have a good way to speed up adjust cost item entries process? I have upgrade from NAV5Sp1 native to SQL NAV2009 and it take 5 times double from the old version.
-
new trace flag 4119 for sql 2008
Hello When I do sql 2005 installation, in addition to T4616 trace flag, I set trace flag T4119 This is mentioned in the link below. http://blogs.msdn.com/microsoft_dynamic ... 5-sp2.aspx Is this needed in sql 2008? tnx
-
Restore Very Slow - SQL 2008 - NAV 4.0SP2
I am preparing for a migration from Nav 4.0sp2 to NAV 2009. I have backed up our live database (SQL 2005) and it has created 29 fbk files total 56.6gb. Our database has 4 companies. The backup took 3 hours. I can live with that. Destination server is a DELL R7100 - 64bit dual quad core server with 40gb ram. Server 2008…
-
Best Pratices
Hi guys! Can you send me a compilation of topics that you think that are very important to anaylise SQL Performance. I´m newbie in this area an i want to read more about this subject. For example on the instalation: Should i limit the MEmory used by the SQL Server? When i create/Attach a database what is the best pratice…
-
cursorfetch problem or query plans need hinting?
First post so please bear with me ;) We used to have a lot of Navision performance problems but that changed when we a. upgraded our san array's disk speeds from 10K to 15K. b. stopped running perfmon and profiler directly on the SQL 2K5. However the problems are still around, just less frequently. I've begun to think it's…
-
Bad performance / unable to restore
Hi – I’m not sure if this is the correct forum, but I have a serious problem restoring a 5.0 NAV database on SQL. It is just a small db, but it contains 510 companies. When I do the restore on a native server it takes app. 2 hours. Now I have tried restoring this several times on SQL, but after 30 -35 hours the process…
-
ask about database engine tuning advisor sql server2005
Hi, I use database engine tuning advisor for my query and the tool recommend me to apply some indexes and statistic. the tools said if I apply the thing it will improvent my performance for 99%. my questions is, if i apply database engine tuning adviosr.from navision side,is there any impact if I apply their…
-
Disk Storage
We are planning to upgrade to Dynamics Nav 2009 and we are spec’ing out a new SQL Server and we are exploring the options in regards to disk storage. Along with the traditional SAN we were looking at the IBM XIV storage system (http://www-03.ibm.com/systems/storage/disk/xiv/http://www-03.ibm.com/systems/storage/disk/xiv/).…
-
Filtering On a Flowfield
Hi all, I have a requirement where a customer has an overview screen for all Sales Order Lines. There is a flowfield that has been added to the Blanket Order Subform of "Qty. on Sales Order", which they wish to see as a column on this overview. However, and this is where it starts to fall apart, it that it is also required…
-
dbcc FREEPROCCHACE
I'm contemplating on clearing the Query Execution Plan cache. Or db was now gone from a test to go live condition, and I want to be sure to be sure that the plans been used are up to date and reflect real life data. I have some basic knowledge of the qep's that could be generated, and I am looking for reassurace that if I…
-
Slow SQL after updating to SP3
Hello, we have a problem at hand - after updating from 4.0 SP2 to 4.0 SP3 and disabling index hinting the whole database turned to crawl. So much, in fact, that it takes 10 minutes to open for example detailed customer ledger entries. Monitoring shows heavy tempdb usage. Otherwise, neither other disks nor CPU are…
-
Poor performance due to wrong setup on sql
Hi! I'm lookin into the solution for one of our customer. I am not very familiar with setting up and configurate NAV on sql server, but this time I have got to find out why the customers database is running very slow. They complain about bad performance, sometimes the whole system hangs for about 10 seconds and all…
-
Multiple DB accesses overhead
Hello everyone, I am trying to optimize an existing system which is currently using LINQ. I have a section where LINQ makes 4-7 database queries for different sections of data based on a primary key. Each query is obviously very fast (1-10ms on SQL Server Profiler), but I am concerned that there may be overhead in making…
-
Navision is Running Very Slow
Hi, I'm running Navision 3.70. Over the past few months, it has been running very, very slow. I'm getting numerous locks in SQL server more and more often - doesn't seem to release as quickly? A maximum of 81 sessions are able to log on to Navision to access the data. My database information is as follows: Database Used…
-
Read/Write Cache on RAID Controller
We are trying to figure out the best setting for our Read/Write Cache. It is currently set to 50/50. Anyone have thoughts as to the best setting when it comes to NAV on SQL? SOme background info: We are running on SQL 2008, NAV Exectuables NAV 2009. Our database is 120 gb, we have 10 NAS's running 24 hours a day and will…
-
Verify Backup Checkbox
We are mving to SQL 2008 Thursday evening. I have done much testing an I now realize something very weird when setting up the backup jobs. First off a regular backup takes about 25 minutes. As soon as I click the "Verify Backup When Finished" checkbox it causes the backup to take 2 hours! You can actually run the "Verify…
-
Performance/speed degradation
Hi, We have a client who is experiencing a gradual decrease in speed on a particular process. There has been no recent changes to the code. They are using Navision 3.70B with SQL Server. Has anyone encountered a similar problem? A few things they have done is rebuilt the indexes (using SQL maintenance). Last year the…
-
LOCKING at INSERT with VSIFT
Hello out there. I like the RECORDLEVELLOCKING of the NAV-SQL. I also like the new SQL-views VSIFTS inside the SQL with NAV-SQL 5.1 and up. But: Can you explain to me WHY the INSERT of a single RECORD LOCKS almost the whole table if there is a SIFT on a KEY? I thought that next to the actual RECORD and the update of the…
-
How to improve posting process time
How can I improve posting process time on NAV 5.0 SP1 SQL database? :-k
-
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.
-
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…
-
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…
-
Event-ID 17401 on SQL Express
We have a customer who uses Entrepreneur with a SQL Express database server. The customer complains that the response time is, at times, very slow. I checked the eventviewer of the server and it contained the ID 17401 "Server resumed execution after being idle <number> seconds: user activity awakened the server. This is an…
-
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,…
-
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…
-
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…
-
Migration: SQL 2008 To SQL 2005
Hi All, What are prerequisites for the migration from Nav2009[ SQL 2008 ] to Nav2009 [SQL 2005] ? Kindly reply.
-
VM Ware with Navision / SQL Server Performance
Hi Experts! How is the performace of Nav SQL in VM Ware Environement, as one of our customer is requesting for this solution. Any issues are there?? Any one experienced any Issues or enjoying with Nav SQL in VM Ware environment. Please share your experience. Best Regards
-
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…
-
Dynamic Cursor trouble (WAS: How-to re-create NAV SQL?)
NAV5SP1 introduces prepared SQL statements to prevent parameter sniffing, but how do I re-create it in a SSMS Query Window? I have used the T-SQL statement from http://blogs.msdn.com/microsoft_dynamic ... story.aspx and found several statements with “room for improvements”. One of the queries seems quite simple: (@P1…