203 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 162
The Domino roadmap has been and is straight out of the OS/2 playbook !
Fri, Oct 27th 2017 4
If Domino 10 spat out gold nuggets would they buy it ?
Fri, Oct 27th 2017 5
Domino Database Optimizer Health Check
Tue, Jun 27th 2017 6
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 4
A simple way to reduce backup times by 55%
Wed, Mar 29th 2017 3
Top 10
Get those Domino System Databases back in shape with Defrag.NSF
Mon, Nov 20th 2017 162
How to make DBMT 50%+ more efficient
Thu, Aug 28th 2014 13
How to set up Database Maintenance Tool (DBMT) Optimisation 1-2-3
Tue, Feb 24th 2015 13
Fully automate DAOS enabling database - set and forget, save diskspace, time and money
Thu, Jul 21st 2016 10
New product - The Domino Database Optimizer – DDO.
Thu, Dec 1st 2016 8
Do you have more then 7,792,058 fragments on your data volume?
Tue, Nov 4th 2014 7
How healthy are your Domino System Databases?
Mon, Mar 27th 2017 7
Does it really make sense to defrag Domino data on a SAN or in a VM ?
Thu, Oct 30th 2014 6
Enabling DAOS, LZ1 and Document Compression in two clicks - The Details
Thu, Dec 11th 2014 6
Notes/Domino futures from Connect 2016
Wed, Feb 3rd 2016 6


How to make DBMT 50%+ more efficient
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
   

DBMT is a wonderful new feature in Domino 9, but it has a nasty habit of doing more work than it needs to.

Our tests show that it can spend a considerable amount of time compacting databases that just DON'T need to be compacted. Even if there is no space to recover in a given database DBMT will still compact it according to the -compactNdays setting. In production this could equate to a huge number of databases and possibly hours of processing.

Why do all the work of manufacturing new "copies" of possibly hundreds of databases for no gain? On top of that resource wastage, all those databases will undergo DBIID changes and now require backing up to maintain a usable Transaction Log, the backing up process will then take longer because files that may have been contiguous will now be fragmented, if you are NOT running Defrag.NSF you now also have substantially increased server I/O and read times during the necessary backup process.

We know there a boundary cases, but in general you'd think it's best to do the compact part of a DBMT run only when there are disk space savings to be made. That's why IBM invented the Compact -S switch, and that's why we have now added the functionality to Defrag.NSF's  DBMT tab.

On the DBMT Schedule tab integrated with Defrag.NSF you can now specify what percentage of freespace a database should have before it is considered to be a candidate for compacting. A simple and yet super effective improvement.




DBMT Settings

With this new option in place, DBMT spends significantly less time compacting databases that just don't need compacting - less I/O, less load, less fragmentation and less changes to Database Instance Identifiers requiring backups. Any databases that do get out of shape with fragmentation are automatically defragged immediately after DBMT has completed it's work.

For more information on Defrag.NSF check out our Website at www.preemptive.com.au/defrag

---------------------
http://ab1osborne.blogspot.com/2014/08/how-to-make-dbmt-50-more-efficient.html
Aug 28, 2014
14 hits



Recent Blog Posts
162
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
4
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
5
If Domino 10 spat out gold nuggets would they buy it ?
Fri, Oct 27th 2017 5:46a   Adam Osborne
What do you reckon ?
6
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
4
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
3
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
7
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
6
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
3
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