{"id":59011,"date":"2023-02-21T09:30:36","date_gmt":"2023-02-21T01:30:36","guid":{"rendered":"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/troubleshooting-sentinel-issues\/enhancing-sentinel-performance\/"},"modified":"2024-08-13T16:16:07","modified_gmt":"2024-08-13T08:16:07","slug":"enhancing-sentinel-performance","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/sentinel\/troubleshooting-sentinel-issues\/enhancing-sentinel-performance\/","title":{"rendered":"Enhancing Sentinel Performance"},"content":{"rendered":"\n

The following sections discuss several ways to enhance performance in Sentinel.<\/p>\n

Optimising the Database<\/h2>\n

Important: It is strongly recommended that you regularly optimise the Sentinel database. Either routinely submit the re-indexing script, or add the script as a regular database maintenance task.<\/p>\n

You can optimise the Sentinel database by submitting a re-indexing script. This could be a regular database maintenance task to ensure continual optimal database performance, or you could perform the optimisation procedure only when required, for example if Sentinel is slower than usual.<\/p>\n

The script is called RebuildIndexes.sql<\/strong> and is located on the Sentinel server at:<\/p>\n

C:\\Program Files\\ISS\\BabelFish Sentinel\\Seed Data\\<\/em><\/p>\n

Note: The location drive may differ from the default location given above, depending on the drive selected during installation. Contact your system administrator for further assistance.<\/p>\n

To optimise the database, you need to take the following steps:<\/p>\n

    \n
  1. Stop the Sentinel Processing Engine service and the Sentinel Service:\n
      \n
    1. Go to Control Panel > Administration Tools > Services<\/em>.<\/li>\n
    2. Select P2 Sentinel Processing Engine<\/strong>, right-click, and select Stop<\/strong>.<\/li>\n
    3. Select P2 Sentinel Service<\/strong>, right-click, and select Stop<\/strong>.<\/li>\n<\/ol>\n<\/li>\n
    4. Submit the script against the Sentinel database.<\/li>\n
    5. The script may take several minutes to run.<\/li>\n
    6. Restart the Sentinel Service.<\/li>\n
    7. Restart the Sentinel Processing Engine service.<\/li>\n<\/ol>\n

      Note: Monitors will continue processing as normal, as soon as the services are restarted.<\/p>\n

      \n

      Database Recovery Modes<\/h2>\n

      Note that setting the transaction mode to Full<\/strong> on the Sentinel database will likely cause a large amount of disk space to be used for transaction logs, due to the fact that Sentinel's database interaction is transaction-intensive.<\/p>\n

      If transaction mode is set to Full<\/strong>, we recommend that the database administrator sets up a maintenance plan to back up the transaction log and control the size of the logs.<\/p>\n

      \n

      Different Cache Drive for Optimisation<\/h2>\n

      Sentinel can be further optimised if you specify a separate hard drive for caching.<\/p>\n

      There is an optional registry setting, \u201cCachePath\u201d which can be added, to move the cache file paths onto a different hard drive to improve performance.<\/p>\n

      \"Graphical<\/p>\n

      \n

      Server Hierarchy Caching<\/h2>\n

      When a monitor process uses an item within an Explorer hierarchy, Sentinel can query a local cache of the Data Dictionary for hierarchy details, rather than running a query against the Data Dictionary to resolve the hierarchy every time the monitor has to process for a period.<\/p>\n

      This means that the Explorer machine and Database are not overloaded with requests and, in addition, Sentinel processing is faster. Overall performance is greatly enhanced.<\/p>\n

      The hierarchy cache is refreshed periodically, according to the value of the CacheExpiryMinutes<\/strong> parameter in the Sentinel Configuration file<\/a>, thus collecting any changes made to the Data Dictionary in the interim. The default expiry time for the cache is 30 minutes.<\/p>\n

      Note: If you choose not to cache the hierarchies, you need to update the Cache<\/strong> parameter in the Sentinel Configuration file.<\/p>\n

      \n

      Anti-Virus Software<\/h2>\n

      Anti-virus programs such as Windows Defender will by default scan the Sentinel cache folder. This can severely impact CPU and disk performance.<\/p>\n

      We strongly recommend that the cache folder is added to the anti-virus software\u2019s exclusion list so that the folder is ignored from virus scanning.<\/p>\n

      \u00a0<\/p>\n

       <\/p>\n","protected":false},"excerpt":{"rendered":"

      This article discusses several ways to enhance system performance in Sentinel.<\/p>\n

      Read more<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":67943,"parent":58772,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[1],"tags":[931,1065,930,933,936,935,934,932],"class_list":["post-59011","page","type-page","status-publish","has-post-thumbnail","hentry","category-uncategorized","tag-anti-virus","tag-cacheexpiryminutes","tag-caching","tag-database-recovery","tag-indexing","tag-rebuildindexes","tag-recovery-mode","tag-transaction-mode","Product-sen"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/59011","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=59011"}],"version-history":[{"count":8,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/59011\/revisions"}],"predecessor-version":[{"id":68359,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/59011\/revisions\/68359"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/58772"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/67943"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=59011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=59011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=59011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}