web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Actually my question i...
Microsoft Dynamics NAV (Archived)

Actually my question if database used percentage reach until 100 % will make problem and if not what i will do

(0) ShareShare
ReportReport
Posted on by ahmed barbary 4,548

Hi guys

i have sql server 2005 connect with dynamic nav 2009 r2 i open file-database - information i found following :

database used kb 269440

database size kb 304896

object cache kb 32000

percentage used 88%

Are there are any problem if database used reach until 100% my license is client license and i don't using demo or Cronus

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at

    hi,

    if your database reach 100% system (sql) can't commit data from log  > error "pending transactions not committed etc.."

    you can add others files after db reached 100%,  but is not indicated for NAV (many tables fragmentation)

    you can set autoexpand properties on datafiles on sql server; only NAV native database need manul files expansions.

  • Suggested answer
    Aleksandar Totovic Profile Picture
    Aleksandar Totovic 16,765 on at

    Look at File->Database->Alter (classic client) on 'Database Files' and 'Transaction Log Files' tabs on 'File Growth' field. You can find percent of growth here. Database will automatic growth for configured percent. You can setup this on SQL, as well.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans