NAVISION DATABASE PERFORMANCE & LIFE

kpsingh_mca

Hi,

I am facing a problem with my new database.
Scenario: In one month we have 22 Lac GL Entries,10 Lac entries in ILE & 12 Lac entries in VLE.
We are using SQL database and all indexes & maintanence plan already maintain on SQL.
1. Main problem is adjust is not completing in time(36 Hrs) and system stor working in this time frame.
2. Worry is this database will continue for how much time.

Please suggest me what are the best possible way out for the above scenario.

Sog

So that everybody can follow
ILE:= Item Ledger Entry
VLE:= Value Entry

Wikipedia wrote:

A lakh ( /ˈlæk/ lak or /ˈlɑːk/ lahk; also lac) is a unit in the Indian numbering system equal to one hundred thousand (100,000; 105). It is widely used both in official and other contexts in Bangladesh, India, Maldives, Nepal, Sri Lanka, Myanmar and Pakistan, and is often used in Indian English.

I would run adjust more often then just once a month.

For a company to generate that much information in one month. I'd think that NAV is not the best choice for that particular company. Dynamics AX seems the better choice at first glance.

Marije_Brummel

I would check out why you are generating this much data. The system might be configured wrongly or setup to maintain to much details. Check out how Dimensions are configured.

Then you can check the queries that are executed on SQL Server by running SQL Profiler. There is information on this website how to do that. You might have slow queries that need additional indexing, or your database is overindexed.

Good luck

Alex_Chow

The number seems consistent if you're generating 10 lac ILE transactions.