Thursday, 18 October 2018

Domino 10 - New Administrator Feature: Dynamic Indexing of High-Usage Views


In my previous blog posts I described already some really cool new Administrator features in Domino 10. In this blog post a brief description of the new Domino 10 Administrator feature Dynamic Indexing of High-Usage Views. Domino 10 can now dynamically assign dedicated view indexing threads to views with content that is frequently updated. This feature keeps busy views up-to-date and enables them to be opened more quickly. There is no need to manually identify and manage view indexing for active views. When the feature is enabled on the Domino server the Domino server regularly monitors the level of update activity for all views in all open databases and assigns them an update activity score. The views that are designated as high usage can change as view update patterns change. The benefits of this feature are greatest for views with frequent document updates but relatively infrequent view updates shows an improvement in response time. End users notice this improvement when opening a view from Notes and applications see a performance improvement on UpdateCollection calls. Overall another very cool and very useful feature. Below a short description on how to enable dynamic indexing of high usage views and some commands to monitor indexing of high usage views.

This dynamic indexing of high usage views feature is enabled by default on the Domino server. The feature can be disabled by changing the value of the following setting in the server notes.ini file to 0: NIF_VIEW_USAGE_ENABLED=0


To see which views are designated as high usage use the Show Tasks server console command. In the console output there are new View Indexer lines. See the examples below.

View Indexer  applications\nifnsfndx.nsf "Contact Person\Contact Person by Company Name" 10 sec. high usage read
View Indexer  applications\nifnsfndx.nsf "Company\Company by Category" 10 sec. high usage read
View Indexer  applications\nifnsfndx.nsf "Company\All" 10 sec. high usage read

For monitoring indexing of high-usage views use the Show Tasks and Show Stats commands. For statistics about high-usage views use the following statistics with the Show Stat server console command.

Statistic Description
Database.ViewUsage.Calls Number of calls to update
code that added to the
cumulative update activity
score for views.
Database.ViewUsage.HighUsageDisables Number of times that high
usage views were disabled
(no longer high usage).
Database.ViewUsage.HighUsageEnables Number of times that high
usage views were enabled
(made high usage).
Database.ViewUsage.HighUsageUpdateChecks Number of times dedicated
high usage view threads
checked whether views were
stale.
Database.ViewUsage.HighUsageUpdates Number of times dedicated
high usage view threads
updated views.
Database.ViewUsage.Skipped Number of times that
updating the update activity
scores for views was skipped
to avoid semaphore
contention.
Database.ViewUsage.HighUsageCurrent Current number of high
usage views.
Update.View.<db-file-name>.<view-name>.Score Current score for a view.
Update.View.<db-file-name>.<view-name>.<statistic>
where <statistic> is one of the following:
TotalInserts
TotalRemoves
TotalNew
TotalReplace
TotalNonReplace
TotalNodataReplace
Count of specified NIF
primitive update operations
done by dedicating indexing
for a specific high usage
view. Use to verify specific
actions resulting from
dedicating view indexing of a
view.

In my next blog post more about the new Administrator features in Domino 10.

No comments:

Post a Comment