mibuso.com

Microsoft Business Solutions online community
It is currently Thu Oct 02, 2014 4:22 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Navision Performance Issue
PostPosted: Mon Feb 20, 2012 3:58 am 
Offline

Joined: Wed Jun 29, 2011 3:26 am
Posts: 384
Country: Singapore (sg)
hi guys,

we have feedback from user about sudden slow in navision performance (v4 sp1). initially user was unable to post, they would get and error message: "the g/l table is lock by another user, please try again." our initial findings was multiple user was doing posting concurrently (eg: finance closing, whse transfering stocks/ adjustments stocks, operations doing sales) so we had to advise user to hold on for a little while and try again.

however recently the situation gotten worse that even looked up an item, quantity etc etc takes a sec or two! i checked database session, and found some stuffs idle time

as far as i know (from F1) idle time its the time after output from sql performed, so i had checked with the user, which said they had finished churning out the report already and yet the memory usage still pretty high. how is it possible that after running report, memory is not return back to navision?

can someone kindly enlighten me please?

PS: i have no background in SQL, so pardon if this posts sounds stupid to you


Top
 Profile E-mail  
 
 Post subject: Re: Navision Performance Issue
PostPosted: Tue Feb 21, 2012 6:50 pm 
Offline

Joined: Fri Aug 06, 2004 9:30 pm
Posts: 1062
Location: Richardson
Country: United States (us)
If this change in performance suddenly happened, then you probably either introduced new code or your database needs performance tuning.
Other problems are hardware problems and more users creating more memory pressure.
Take a look using the various tools Microsoft provides for monitoring performance - Windows and SQL Server.
If you are new to SQL Server, get some books, and use SQL Server book online, msdn, etc.

If your budget allows for it, get some help from one of the performance tuning consultants who frequent this site.

_________________
David Machanick
http://mibuso.com/blogs/davidmachanick/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: