Skip to Main Content
SEI Idea Portal
Status Submitted
Created by Sue Waters
Created on Jun 19, 2023

Enhancement needed to support growth of ATR DB.

No description provided
Description

UPMC recently added another 22 EAs to their system. It increased the amount of ATR messages by 3x and the database growth went from around 100 gbs to almost 300 gbs. Customer is having issues finishing database maintenance and speed of queries are effected.

Customer would like to see Partitioning on the ATR database and I believe ATR is a candidate for SQL Server DB Warehousing for historic data since most searches are on date-time. Breaking out the data would allow current searches to speed up while making for better reporting.