mibuso.com

Microsoft Business Solutions online community
It is currently Fri May 24, 2013 9:45 pm

View unanswered posts | View active topics


Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]



Post new topic Reply to topic  Page 1 of 1
  [ 5 posts ] 
  What's this MUID? [MUID:YTEK] Previous topic | Next topic 
Author Message
vikram7_dabas
 Post subject: Optimization Problem
PostPosted: Wed Nov 19, 2008 7:43 am 
Offline

Joined: Mon Feb 19, 2007 8:51 am
Posts: 448
Location: delhi
Country: India (in)
My clients Database increases too much Day By Day.Database is in SQL.Database size is 19 GB with in 8 months.If I will optimize that DB then wht will happen?What r advantages and Disadvantages of optimization?When I go in File->Database->Information there it shows me size 19 GB.Is it contains size of .mdf,.ndf and.ldf files?or separately?

_________________
Vikram Dabas
Navision Technical Consultant

Top
 Profile E-mail  
 
navuser1
 Post subject: Re: Optimization Problem
PostPosted: Wed Nov 19, 2008 8:08 am 
Offline

Joined: Wed Mar 19, 2008 9:08 am
Posts: 872
Location: XYZ
The optimization process performs two functions:

• For each Dynamics NAV table, the SQL Server indexes, other than the primary key,
are rebuilt to optimize their layout and usage.
• For each SIFT structure, any entries that contain zero values in all numeric fields are
removed. The removal of these redundant entries will free space and provide more
efficient updating and summing of SIFT information.




from w1w1isql

_________________
Now or Never

Top
 Profile E-mail  
 
garak
 Post subject: Re: Optimization Problem
PostPosted: Wed Nov 19, 2008 9:43 am 
Offline

Joined: Mon Mar 08, 2004 2:42 pm
Posts: 3255
Location: Hannover
Country: Germany (de)
which file is the larges? The Log file?
Read for example this post and search the forum for LOG File Or Transaction Log or Maintenance.

Regards

_________________
Do you make it right, it works too!

Top
 Profile  
 
kriki
 Post subject: Re: Optimization Problem
PostPosted: Mon Nov 24, 2008 7:11 pm 
Offline
Moderator
MVP Microsoft Dynamics NAV
NAV TechDays 2013 attendee

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

_________________
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  
 
stryk
 Post subject: Re: Optimization Problem
PostPosted: Tue Nov 25, 2008 10:14 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
Hi!

First of all I'd like to encourage you to search this forum for "SQL Performance" - and maybe especially about SIFT and INdexes - and you'll get TONS of useful advices, hints and recommendations!

To measure the growth precisely you should check out the SQL procedure sp_spaceused (see "Books Online" for details) or the NDST (NAV Database Sizing Tool, part of SQL Resource Kit) - which is actually also using the sp_spaceused ...

Besides the technical aspects like SIFT and Indexes you should also look into the application/business logic itself: limit the number of "Dimensions", limit the number of "Analysis Views", use "Date Compression" etc. ...

Regards,
Jörg

_________________
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  Page 1 of 1
  [ 5 posts ] 

Board index » Other » SQL General

All times are UTC + 1 hour [ DST ]

Who is online

Users browsing this forum: No registered users and 5 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: