Derdack

Targeted Alert Notifications – Anywhere Actions

Derdack
  • Use Cases
    • Overview
    • Enterprise IT Alerting
    • IT Managed Services
    • Mobile Alerting in Manufacuring
    • Critical Operations Alerting in Banking & Financial
    • Field Service Dispatching in Energy & Utilities
    • Use Cases in other Industries
  • Products
    • Overview
    • Enterprise Alert®
      • Overview
      • Alert Notifications
      • On-call Duty Scheduling
      • Collaboration
      • Anywhere Remediation
      • Incident Mgmt. App
      • Integrations
      • Technical Support
      • Derdack FAQ
    • SIGNL4® Cloud
    • References & More
  • How to Buy
    • Overview
    • Pricing and Quotes
    • Find a local Partner
    • Azure Marketplace
  • About Derdack
    • About
    • Careers
    • Partner Program
    • Strategic Partners
    • Contact Derdack
  • News & Blog
  • Request Demo
    • de de
  • News & Blog

    • Home
    • News & Blog
    • Technical
    • Database Maintenance in Enterprise Alert

    Database Maintenance in Enterprise Alert

    • January 24, 2017
    • Technical
    Database Maintenance in Enterprise Alert

    Database maintenance is integral to the speed of an application. An application’s speed is driven by many factors, one of which is database performance. In an application such as Enterprise Alert that is I/O intensive, database speed is a critical factor in its performance. As such, a solid database maintenance plan is needed to ensure that performance doesn’t lag for users, causing a poor user experience. Enterprise Alert doesn’t incorporate full database maintenance features, but it does integrate a good first step in that plan if you’re experiencing slowed performance.

    On average, how fast does Enterprise Alert’s database grow?

    Taking an average scenario, which includes around 500 events/day, 100 users spread across 10 teams, and each event creating two alerts, you can expect an average of about 3GB per month of database growth. (This will be on the high side for most use cases) This does show that a consistent plan is needed.

    In Enterprise Alert, we offer a quick, first line Database Maintenance option. This option, located in System–> General, allows for the most used tables to be trimmed. When the tables are trimmed, this can speed up performance a bit due to the time needed by the database to read and write to these tables. Larger tables obviously mean slower read and write times as the database pointer has to filter through more records.

    The effected tables are as follows:

    1. MMEVENTS (Incoming Events)
    2. EAEvents (Log Entries)
    3. MMINBOUND (Inbound Messages)
    4. MMOUTBOUND (Outbound Messages)
    5. MMTICKETS (Active and Closed Alerts)
    6. MMTICKETMESSAGES (Events)
    7. PolicyExecutionJournal (Executed Alert Policies)
    8. EmergencyCalloutAlerts (Closed Callouts)
    9. EmergencyCalloutInstances (Closed Callouts)
    10. RemoteActionsHistory (Executed Remote Actions)
    11. RemoteJobsHistory (Executed Remote Actions)

    When looking at the tables, in general, the most used tables are going to be associated with the log entries and events (both entries will have the largest totals for most users), and these are the ones you would want to look at first under Database Maintenance. Both sets of tables are written to often, basically every time something happens in Enterprise Alert. Because of this, these tables can get rather large, rather quickly (as can be seen in the image below).

    Our Database Maintenance option simplifies the process of deleting rows from these tables by allowing you to simply enter a date of the last record you’d like to have in the table. Everything prior to that date will be deleted from the table, and should help speed up performance a bit.

    As you can see in the image below, it’s a very quick and easy method. Simply click in the text field, select the date on the calendar, and then click the circled “X” to the right of the row.

    EnterpriseAlert - Database Maintenance option

    Derdack´s EnterpriseAlert offers a Database Maintenance option.

    Once the “X” is clicked beside the text box, the records in the appropriate tables will be deleted.

    Depending on the size of the files being deleted and the hardware you’re running, this process can take a bit of time. Just be patient and let the process run if you’re attempting to delete a large amount of entries. The other option is to select smaller “chunks” of time and delete the files in increments. But once done, you should be able to offer up a more pleasant experience for your users.

    This process can also be automated by setting up a script to run as a Window’s Task. To find out how, read here
    As mentioned, though, this is very small part of what should be a more thorough database maintenance plan, and simply a suggested first place to look when you’re experiencing a slow user experience. Some suggested reading on database maintenance plans and their importance can be found at the following links:

    1. https://technet.microsoft.com/en-us/library/2008.08.database.aspx
    2. http://www.sqlshack.com/tips-and-tricks-for-sql-server-database-maintenance-optimization/
    3. https://msdn.microsoft.com/en-us/library/ms177500(v=sql.105).aspx

    For further reading on Enterprise Alert’s features, please visit us here.

    Tagged

    DatabaseEnterprise Alert 2016MaintenanceWindows

    Share

    Related Posts

    Integration with 3rd Party Systems

    February 26, 2021

    Alert Escalation in Enterprise Alert

    February 16, 2021

    Empowering Remote Users

    December 9, 2020

    Tips & Tricks: Keeping track of user profile changes

    December 3, 2020

    About

    DERDACK products combine automated alert notification workflows, 24/7 duty scheduling, ad-hoc collaboration and anywhere IT troubleshooting – reducing unexpected IT downtimes at large enterprises and organizations by 60%.

    Most popular

    • Derdack Company Take your ITIL incident management to the next level with Enterprise Alert
    • Mobile alert notifications for HP Service Manager (HPSM)
    • How to forward alerts to Microsoft Teams
    • Oncall Scheduling On-Call Schedule Management with Auto-Rotation
    • Announcing Enterprise Alert 2019
    • checking-mobile Enhancing SCOM alert notifications
    • Even, Alert, Incident, Notification Definition of Event, Alert, Incident and Notification
    • message master xsp message master® xsp – mobile text messaging platform

    Categories

    • Business (35)
    • Cloud Services (1)
    • Consultancy (1)
    • Customers (14)
    • Energy & Utilities (7)
    • Events (23)
    • Financial & Banking (4)
    • IT Ops (17)
    • Manufacturing (6)
    • News (43)
    • Software (1)
    • Staffing (1)
    • Technical (106)
    • Transport & Logistics (4)

    Tags

    alert alert notification alert notifications Anywhere Resolution Anywhere Response Azure azure customer reference Database derdack enterprise alert Enterprise Alert Enterprise Alert 2016 Enterprise Alert 2019 HPE HPE ITSM incident Incident resolution incident response Industrie 4.0 Integration IT Alerting IT Operations Maintenance microsoft Mobile App monitoring OMS on-call on-call schedule phone PowerShell rapid response release REST API SCADA SCOM scsm security SMTP SolarWinds NPM System Center update User Group voice

    Follow us

    • Twitter
    • Facebook
    • LinkedIn
    • XING
    • YouTube
    • Vimeo
    • Home
    • News & Blog
    • Technical
    • Database Maintenance in Enterprise Alert

    CONTACT US:
    Intl: +49 331 29878-0

    US: +1 (202) 470-0885
    UK: +44 (20) 88167095

    CONTACT VIA EMAIL:
    info@derdack.com

    OFFICES:
    US & Europe

    NEWSLETTER:
    Sign up here

    CAREER:
    Latest job offers

    EVENTS

    • No Upcoming Events
    • Who we help
    • Products
    • How to Buy
    • About Derdack
    • News & Blog
    • Free Trial
    • Twitter
    • Facebook
    • LinkedIn
    • XING
    • YouTube
    • Vimeo

     © 1999-2021 Derdack – Imprint, Privacy policy

    • Use Cases
      • Overview
      • Enterprise IT Alerting
      • IT Managed Services
      • Mobile Alerting in Manufacuring
      • Critical Operations Alerting in Banking & Financial
      • Field Service Dispatching in Energy & Utilities
      • Use Cases in other Industries
    • Products
      • Overview
      • Enterprise Alert®
        • Overview
        • Alert Notifications
        • On-call Duty Scheduling
        • Collaboration
        • Anywhere Remediation
        • Incident Mgmt. App
        • Integrations
        • Technical Support
        • Derdack FAQ
      • SIGNL4® Cloud
      • References & More
    • How to Buy
      • Overview
      • Pricing and Quotes
      • Find a local Partner
      • Azure Marketplace
    • About Derdack
      • About
      • Careers
      • Partner Program
      • Strategic Partners
      • Contact Derdack
    • News & Blog
    • Request Demo