Home » Resource » Case Study » Optimizing Database Footprint in ServiceNow For a Healthcare Service Provider

CASE STUDY

Optimizing Database Footprint in ServiceNow For a Healthcare Service Provider

Industry | Healthcare

Technology | ServiceNow

Location | United States

The client is a mid-sized healthcare company operating in the south of the US. The client leveraged ServiceNow for its IT service management faced challenges related to database performance and manageability due to a growing database footprint. With a significant volume of data being generated daily, the organization recognized the need to streamline its instance database.

Challenges

As the database footprint grew, system performance suffered, leading to slower response times and increased lag in user activities.

A cluttered database resulted in complex management tasks, complicating routine maintenance and technical oversight.

Longer system clone times impacted disaster recovery efforts, delaying the organization’s ability to restore systems in emergencies.

The organization faced potential licensing implications as their database approached the 4 TB threshold.

Key Outcomes

Performance Improvement

System performance was noticeably enhanced, resulting in faster response times for users.

Simplified Management

The database became easier to manage, reducing the complexity of regular maintenance tasks.

Faster Backup and Cloning

Backup and system cloning times improved, allowing for quicker disaster recovery and less downtime.

Solutions

Established monitoring protocols to disable debugging and logging in custom scripts, which helped control the daily influx of logs.

Activated the OOTB (Out of the Box) Archive rule for the sys_email table to archive emails older than one year and delete related attachments.

Introduced a data management policy using a table cleaner job to delete entries in the sys_tiny_url table that had not been accessed in the last 12 months.

Implemented a one-time job to delete stale attachments from the sys_poll table and reduce clutter.

What Customers Say about Royal Cyber

Managing our vast database was a key challenge. Thanks to Royal Cyber, overall performance has gone up to perform better; allowing us to predict problems and identify anomalies easily. We can now record data more effectively.