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. |