mibuso.com

Microsoft Business Solutions online community
It is currently Thu May 23, 2013 10:07 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: Key Information Tool for the Classic NAV 6.0 - SQL Server
PostPosted: Tue Jul 17, 2012 2:38 pm 
Offline

Joined: Mon Feb 08, 2010 10:47 am
Posts: 2
Country: Spain (es)
Hello,

I'm having SQL Performance problems with NAV 6.0 and after reading a lot (including Jörg Stryk blog) I've decided to check mi VSIFT Buckets in order to reduce their maintenance as suggested (or al least I understood).

The article link is attached here

The White Paper named "Microsoft Business Solutions - Navision SQL server Option Resource Kit" refers to a pair of tools that I managed to download: Index Degrag Tool.fob and Key Information Tool.fob

Once installed, their objects appear on the Object Designer window as: "SQL Key Information 2.30" and "Index Defrag 2.0"

I'm quite sure that those objects are "so" old for the NAV 6.0 version (based on VSIFT instead of SIFT Tables). So I can't manage to disable the maintenance of some sumindex buckets.

Is there a newer version available to download. I'll be glad if anyone could help me with this issue.

Thanks. Jorge.


Top
 Profile E-mail  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Tue Jul 17, 2012 2:56 pm 
Online
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

Joined: Wed Jul 02, 2003 10:13 am
Posts: 7499
Location: Milan
Country: Italy (it)
Starting with NAV50SP1, the bucket-thing does not exist anymore because indexed views are used for the SIFT instead of extra tables (+triggers in original table) in which the bucket-totals are stored.

_________________
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


Top
 Profile  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Tue Jul 17, 2012 4:36 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
Thanks for reading my BLOG & stuff :wink:

As kriki said, with 6.0 there's no more SIFT, replaced by VSIFT which is not much of a problem today ...

I suggest to use SQL Profiler to investigate problematic queries and to establish processes to monitor blocks and deadlocks - this should reveal the application-related problems!
And of course you need to make sure your server sizing & configuration is optimized; plus you should have sufficient maintenance installed!

The "NAV Performance Troubleshooting Tools" incl. "SQL Key Information 2.30" and "Index Defrag 2.0" are ... uh, let's be polite and say "they are outdatetd and insufficient" :thumbsdown: ... don't use that, there are way better tools around 8)

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Tue Jul 17, 2012 5:52 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Tue Aug 14, 2001 7:01 am
Posts: 5315
Location: Prague
Country: Czech Republic (cz)
kriki wrote:
Starting with NAV50SP1, the bucket-thing does not exist anymore because indexed views are used for the SIFT instead of extra tables (+triggers in original table) in which the bucket-totals are stored.


Just to add that even though buckets no longer exist, you can still create your own buckets when needed. This is often needed where you have Indexes created of many fields in records with many rows.

Also note that if you have 5.00 with the latest service packs applied then you are also using VSIFT, they hid that one in there as a nice quiet surprise.

_________________
David Singleton
Dynamics NAV Freelancer
Dynamics Book
Go-Live International


Top
 Profile E-mail WWW  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Wed Jul 18, 2012 9:02 am 
Offline

Joined: Mon Feb 08, 2010 10:47 am
Posts: 2
Country: Spain (es)
Thanks for your answers.

stryk, not only reading your blog but expecting the shipment of your book!

So, can I consider than the previously mentioned tools are still the last versions available?

Thanks again to all.
Jorge.


Top
 Profile E-mail  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Fri Jul 20, 2012 4:20 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
Thanks a lot (have in mind the book is somewhat old not fully accurate today :oops:

Regarding the "tools": well, from NAV site there's not much, and the few things available are insufficient. For troubleshooting the best tool ist SQL Server itself, e.g. the SQL Profiler and more.
Plus, in the internet (my BLOG and many others as well!) you find tons of useful stuff which could help you!

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Mon Jan 28, 2013 9:35 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Sat Jul 15, 2006 3:00 pm
Posts: 84
Location: Gurgaon
Country: India (in)
Hi All,
What is the best way to get Locking information during a period of time? For example, I want to create a log file/ table of all the locking issues in the database during a day (on NAV2009 R2 database on SQL Server 2008 server). Is SQL Profiler the right tool? Will it not increase the load of server significantly?

Is there any other tool for this purpose?
Looking forward for your reply.

_________________
-Dhan Raj Bansal
Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal


Top
 Profile  
 
 Post subject: Re: Key Information Tool for the Classic NAV 6.0 - SQL Serve
PostPosted: Mon Jan 28, 2013 2:47 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
Maybe check this out: http://dynamicsuser.net/blogs/stryk/archive/tags/Locking/default.aspx

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 8 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: