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) / DELAYED_DURABILITY SQL...
Microsoft Dynamics NAV (Archived)

DELAYED_DURABILITY SQL at database level parameter?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi there, I am questioning myself about either use or not use this setting in live. We are suffering low performance and tempdb contention (already applied tempdb split strategy) and memory pressure (lots of cursors created, alerts on SQL Server Error Log) as well as locks generated per linked servers and lots of connections at the same time.

As per my understanding if you activate this parameter you can reduce the latency when you are writing against the transaction log of the database affected. is it so? I also read that if you have a high proportion of transactions smaller than 60 kb and when you don't have either shared or full flash SSD behind, it could bring you benefits.

How can I figure out the average size of my transactions?

Thanks a lot,

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DELAYED_DURABILITY SQL at database level parameter?

    It depends on the transactions. For e.g. Sales Order posting would create the entries in 8-10 tables. You can derive the transaction size accordingly.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DELAYED_DURABILITY SQL at database level parameter?

    Hi Vishal, thanks for your reply. I was talkin' about average transaction size rather than average size of tables.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: DELAYED_DURABILITY SQL at database level parameter?

    You can go to NAV > FILE > Database > Information > Click Table

    Here, you can check the average size of any particular table (Record Size Column - In Bytes),

    There are N numbers of other parameters, which can also help you to improvise the performance. You can find various blogs here on the same.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans