mibuso.com

Microsoft Business Solutions online community
It is currently Tue Jul 29, 2014 2:33 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: NAV 5SP1 Very Slow on SQL Server 2008
PostPosted: Thu Sep 02, 2010 10:16 am 
Offline

Joined: Fri Jun 02, 2006 9:09 am
Posts: 58
Location: Nairobi; KENYA
Country: Kenya (ke)
Hi guyz;
I don't know whether anyone has experienced this problem. We have implemented NAV5SP1 running on SQL 2008 to one of our
clients and the system has become very slow 1 year down the line.
We have implemented Financials,Sale & Marketing, Purchases, Warehouse, Manufacturing, Inventory
Management and Human Resources.
Retrieving any of the inventory reports has also become a major challenge.
Am wondering how we can improve the speed since we have tried to optimize sql and also ensuring the transaction log file does not grow that much and there appears to be no change.


Top
 Profile  
 
 Post subject: Re: NAV 5SP1 Very Slow on SQL Server 2008
PostPosted: Thu Sep 02, 2010 11:24 am 
Offline

Joined: Mon Jul 28, 2008 2:37 pm
Posts: 674
Location: AT
Country: Austria (at)
The size of the transaction log has nothing to do with the responsiveness of any app. What matters on the server side is the size of tables, number of indexes (keys) and quantity of transactions (any).
What matters on the client side (NAV) is the quantity of modifications made and their quality.

In your case my guess would be that the DB has grown over the year and your keys/indexes are not set up or used according to data query needs.

You should consult a nav/sql pro to look into your case.


Top
 Profile  
 
 Post subject: Re: NAV 5SP1 Very Slow on SQL Server 2008
PostPosted: Thu Sep 02, 2010 11:31 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Jul 19, 2005 4:49 pm
Posts: 4175
Location: Olst
Country: Netherlands (nl)
http://www.amazon.com/NAV-SQL-Performan ... pd_sim_b_3

_________________
Mark Brummel | Freelance Dynamics NAV (Navision) Specialist

Author of the book : Microsoft Dynamics NAV Application Design

MY BLOG : http://markbrummel.wordpress.com


Top
 Profile E-mail WWW  
 
 Post subject: Re: NAV 5SP1 Very Slow on SQL Server 2008
PostPosted: Thu Sep 02, 2010 1:47 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7683
Location: Milan
Country: Italy (it)
[Topic moved from 'NAV/Navision Classic Client' forum to 'SQL Performance' forum]

Search this forum for some ideas.

To start : do you do a regular rebuild index?

_________________
Regards,Alain Krikilion
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title! || Read Forum Rules before making a posting

»»» Mark your calendar: NAV TechDays 2014 - 20 & 21 November 2014 ««« Visit the conference website: http://www.navtechdays.com


Top
 Profile  
 
 Post subject: Re: NAV 5SP1 Very Slow on SQL Server 2008
PostPosted: Thu Sep 02, 2010 6:56 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 11, 2004 9:05 pm
Posts: 5011
Location: Los Angeles, CA
Country: United States (us)
Kim wrote:
Hi guyz;
I don't know whether anyone has experienced this problem. We have implemented NAV5SP1 running on SQL 2008 to one of our
clients and the system has become very slow 1 year down the line.
We have implemented Financials,Sale & Marketing, Purchases, Warehouse, Manufacturing, Inventory
Management and Human Resources.
Retrieving any of the inventory reports has also become a major challenge.
Am wondering how we can improve the speed since we have tried to optimize sql and also ensuring the transaction log file does not grow that much and there appears to be no change.


You can download SQL optimization manual on the Partnersource site. It has a lot of helpful ways to increase performance.

_________________
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


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: