202 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
Get those Domino System Databases back in shape with Defrag.NSF
Mon, Nov 20th 2017 7
The Domino roadmap has been and is straight out of the OS/2 playbook !
Fri, Oct 27th 2017 8
If Domino 10 spat out gold nuggets would they buy it ?
Fri, Oct 27th 2017 9
Domino Database Optimizer Health Check
Tue, Jun 27th 2017 4
DBMT still creates fragmented NSF files on volumes that are fragmented
Thu, Apr 6th 2017 4
Virtualizing Domino is NOT a "Get Out Of Jail Free" card
Thu, Mar 30th 2017 8
A simple way to reduce backup times by 55%
Wed, Mar 29th 2017 5
Top 10
How to set up Database Maintenance Tool (DBMT) Optimisation 1-2-3
Tue, Feb 24th 2015 15
How to make DBMT 50%+ more efficient
Thu, Aug 28th 2014 14
Fully automate DAOS enabling database - set and forget, save diskspace, time and money
Thu, Jul 21st 2016 11
If you ever needed proof that Notes on eclipse is a work of magic (and madness)
Wed, Oct 26th 2016 11
Does it really make sense to defrag Domino data on a SAN or in a VM ?
Thu, Oct 30th 2014 10
The things you find while cleaning - OS/2 Warp mouse mat
Fri, Nov 20th 2015 9
Arriving soon.. The Domino Database Optimizer.
Thu, Jun 23rd 2016 9
What are the stages of optimization in DDO?
Fri, Dec 2nd 2016 9
How healthy are your Domino System Databases?
Mon, Mar 27th 2017 9
If Domino 10 spat out gold nuggets would they buy it ?
Fri, Oct 27th 2017 9


DBMT Optimizations in DDO that can reduce its workload by over 90%
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

DDO includes three optimizations to DBMT that make a dramatic difference in its workload:



The first and most powerful setting is the “Only Compact when Freespace exceeds” fields on the Optimization Schedule.

By setting this field a database can only become a candidate for DBMT compacting when the freespace within it exceed the amount specified. This avoids potentially processing hundreds of database where little, or no, freespace can be recovered. This dramatically reduces DBMT processing times, prevents fragmenting those databases, and prevents unnecessary DBIID changes, which also reduces backup requirements.

Here is an example where only 12 databases exceed the Freespace exceeds setting:



As a result when DBMT runs all other databases are excluded from the compact sub-task of DBMT



DBMT therefore only compacts 12 of the 280+ databases


You can further fine-tune the databases that are excluded from compact processing by adding them to the “Exclude the following databases from DBMT processing field” or adding the directory to the “Exclude the following directories from DBMT processing field”

The end result is significantly less time “compacting for the sake of compacting” and the benefits from there are substantial.

One final note, the DBMT optimizations discussed here are only available in DDO.

Why not try DDO for yourself with a free 30 day trial?






---------------------
http://ab1osborne.blogspot.com/2016/12/dbmt-optimizations-in-ddo-that-can.html
Dec 08, 2016
7 hits



Recent Blog Posts
7
Get those Domino System Databases back in shape with Defrag.NSF
Mon, Nov 20th 2017 3:52a   Adam Osborne
We often see Domino servers with bloated System databases that never seem to get compacted/maintained (you know the ones.... log.nsf, etc) because.....well it's just always been a hassle for many admins to shut down and manually do it. As a result, these databases are missing out on some much needed maintenance and can get pretty huge and often respond sluggishly when they do need to be opened. Usually with many GB of disk space trapped inside they are just wasting disk space too, it all adds u
8
The Domino roadmap has been and is straight out of the OS/2 playbook !
Fri, Oct 27th 2017 5:58a   Adam Osborne
Want to know more... https://www.stardock.com/stardock/articles/article_sdos2.html https://en.wikipedia.org/wiki/EComStation https://en.wikipedia.org/wiki/ArcaOS
9
If Domino 10 spat out gold nuggets would they buy it ?
Fri, Oct 27th 2017 5:46a   Adam Osborne
What do you reckon ?
4
Domino Database Optimizer Health Check
Tue, Jun 27th 2017 4:29a   Adam Osborne
One of the first things we suggest you do when you install the Domino Database Optimizer is run a Health Check and below is a typical example of what we find. These screenshot shows a selection of some of the less than optimal results revealed on a Domino 9.0.1 server during the initial DDO Health Check. A simple button click in DDO will activate the optimizations with no further administrator effort. Then on schedule, DDO performs tasks according to the administrator's configuration fo
4
DBMT still creates fragmented NSF files on volumes that are fragmented
Thu, Apr 6th 2017 8:12p   Adam Osborne
On a busy server Compact -C fragments NSF files left, right and center. It sprays bits of the file all over the place. The only thing we have seen in Domino that does a worse job are full text indexes. As previously discussed and referenced by others and IBM, DBMT does a much better job. It tries to create a contiguous NSF file, but it can ONLY do that it the freespace on the server is not highly fragmented, and the only way that is going to happen is if you have taken steps to keep it in sha
8
Virtualizing Domino is NOT a "Get Out Of Jail Free" card
Thu, Mar 30th 2017 7:49p   Adam Osborne
Further to yesterday's blog we wanted to point out that recently VMware updated their latest documentation for VSphere 6.5, included is the recommendation to "Defragment the file system on all guests" to enhance Disk I/O performance. It is so often not understood that fragmentation in the virtualized environment can have a devastating impact on Domino server performance and also the O/S, and yep, we see this a LOT. This negative impact happens because as far as the Guest O/S (Windows) is co
5
A simple way to reduce backup times by 55%
Wed, Mar 29th 2017 9:26a   Adam Osborne
Last week DDO went into action at an Australian Coal mining organisation. The server was a mess, with exceptionally long backup times. It is a VM, running on a high powered SAN, but none of that matters, because if Windows sees fragmentation it acts accordingly, it slows down and in this case was issuing millions of additional I/Os to get backups done. DDO ran and optimised the files. In the chart below you can see the positive effect of removing 742,289 fragments from just 144 databases. Back
9
How healthy are your Domino System Databases?
Mon, Mar 27th 2017 9:20p   Adam Osborne
Are the System Databases on your Domino servers optimized and healthy? You know, the really important ones that seem to never get maintenance, log.nsf, names.nsf, mailjrn.nsf etc, are they getting huge, sluggish to open, slow to backup, wasting GB of disk space? DDO makes this often never done Domino and database maintenance as simple as ticking a few boxes, set and forget,. If this is scheduled once a week the difference it makes to Domino is quite amazing. Here are some screen shots from a c
3
The easiest way to enable Feature Pack 8 View Separation
Mon, Mar 20th 2017 1:17a   Adam Osborne
In this 2 minute video, we will show how to use DDO to: - Enable Feature Pack 8 View Separation (NIFNSF) with a single selection - Direct the View NDX files into their own directory - Schedule View Separation for all Mail 9 databases - Schedule a Domino restart at 12:05 am to enable View Separation. Just for good measure, we'll run DBMT over all the System Databases at the same time. - Schedule DBMT to run at 2:30 am for 2 hours, during which View separation will occur on Mail 9 databases. On
1
IBM Patents out-of-office email.
Thu, Mar 2nd 2017 9:33p   Adam Osborne
Interesting... http://www.theregister.co.uk/2017/03/01/ibm_out_of_office_email/




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition