Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
optimize for ad hoc workloads
bbrown
Member Posts: 3,268
Any experience out there with this SQL option? I troubleshooting some performance issues that have cropped up in a larger system. One thing I noticed was a high plan count on a number of queries. Thinkign this may help alleviate that problem.
Thoughts?
NAV 5.01 Database
NAV 2009 SP1 clients
SQL 2008 SP1
Windows 2008 R2
Thoughts?
NAV 5.01 Database
NAV 2009 SP1 clients
SQL 2008 SP1
Windows 2008 R2
There are no bugs - only undocumented features.
0
Comments
Also info such as RAM and have you looked at hard disk read/write buffer sizes?
Also does 5.01 utilize the new function findset,findfirst,isempty?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I definitely have some bad queries here. That's what I was chasing when I came across this issue. The client recently merged produciton operations from 4 locations into 1 and since we've seen performance on a few forms drop to less then desirable. Trying to address them before they get bad enough that I have a user revolt.
The record sizes for the tables where I am seeing multiple plans are all over the place. A few examples are Record Link (3 records), Customer (535 records), Sales Shipment Header (~1,000,000 records) and Value Entry (87 million records). The database is 450 GB (~350 used).
The SQL instance has 90 GB of memory. (when the client offers memory you don't say no). I have not looked at the buffer sizes. What are you thinking here?
Yes, 5.01 does support the newer FIND commands. I think it was the first release that did. Anyways we're using NAV 2009 SP1 clients.
There is one query, seems to be system generated, that has 648 plans.
Hame Lame,
zetaclear | breast actives