June 30, 2009 at 8:21 am
Hi there
We have a 64bit sql 2005 server
We have two 64bit Citrix server with the navision apllication running on it.
Sometimes the navision is running very very slow performance. But when we monitor through the task manager of the SQL 2005 and the citrixes none of them are running high.
What can be the issue ?
Kind regards.
El Jefe
JV
June 30, 2009 at 2:40 pm
With this little information it could be anything...
What have you done so far to catch the bottleneck?
Did you try to catch long running queries with profiler?
Did you run system counters to narrow your search?
Are ther blocking queries?
What about disk queue?
Help us help you with some information.
-- Gianluca Sartori
June 30, 2009 at 3:13 pm
What about network traffic?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 30, 2009 at 3:15 pm
jvElecenter (6/30/2009)
What can be the issue ?
In all honestly, just about anything.
Is there blocking?
Are the queries waiting for a resource?
Is there IO contention?
Is there memory contention?
Are there any unusual queries running that could be hogging resources?
Are there jobs running longer than usual?
Has anyone changed any indexes?
Are the indexes excessively fragmented?
Are the statistics up to date?
....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 30, 2009 at 3:16 pm
I used to work at a place where Navision was used.
It always sucked from a performance point of view - and it wasn't helped by their database schema, which was, er, novel.
No doubt all issues are fixed in Microsoft Dynamics NAV 😀
July 1, 2009 at 1:37 am
Hi there
I know I give few info and I am asking a lot.
We are not running big queries. There are no deadlocks.
Database is running on disk, transaction log is running on other disks.
Update stats en reindexing is running in the weekend.
A problem for example is when asking for a new ordernr. The first time it takes 10 seconds. The second time it takes 3 seconds.
What should I monitor exactly on SQL ?
Regarding netword traffic. We have ordered a new Cisco switch since now there is a 3com which is pushing it to the limit.
Thx in advance guyz and ladiez
JV
July 1, 2009 at 3:14 am
First use SQLProfiler to find out which query is long running.
http://www.developer.com/db/article.php/3482216
Then see gails article on how to post performance issues
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
It will stop all the guess work
July 2, 2009 at 7:28 am
jvElecenter (7/1/2009)
Hi thereI know I give few info and I am asking a lot.
We are not running big queries. There are no deadlocks.
Database is running on disk, transaction log is running on other disks.
Update stats en reindexing is running in the weekend.
A problem for example is when asking for a new ordernr. The first time it takes 10 seconds. The second time it takes 3 seconds.
What should I monitor exactly on SQL ?
Regarding netword traffic. We have ordered a new Cisco switch since now there is a 3com which is pushing it to the limit.
Thx in advance guyz and ladiez
That sounds to me like poor indexing leading to a table scan (or multiple scans). First time you have to read a LOT of data from disk, which gets left in RAM cache. Second time it still hits way too much data but it is in RAM thus the speed improvement.
I highly recommend you engage a performance tuning professional to remote in to your system and help you out here. Hunting and pecking on this forum could take days or weeks where a good consultant could identify and fix problems in hours or even minutes. There are a number of perf-tuning gurus here that could help.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
July 15, 2009 at 1:58 pm
Worked with Navision for 3 years.
The performance issue is mostly front-end.
Because in the end, I had the db rebuilt onto a new server, clean OS, and completely configured as I desired.
I ended up having to tell the accounting staff if they were having issues start with just restarting their own app GUI.
You don't have to reboot the system, there seems to be some type of memory leak through just the client interface.
Large-scale reporting, I ended up asking the lead-accountants to run their major reports on a medium-older server,
setup with the Navision application, this way the dedicated server would take most of the hit,
and it wouldn't interfere with other users work. (especially at end of month when everyone was playing)
The server doesn't need storage space, just a touch of CPU and decent amount of memory.
These issues may have change with the newer version when Microsoft bought them out,
and turned it into MS Dynamics (NAV)...but I didn't get the chance to see that in play...they went to the AX version.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply