In 2012, EmpireCLS needed a way to keep track of the overall health of all the applications that we were writing. We developed a series of database queries that would notify the MIS team of certain events throughout the entire back office suite.
This service would basically poll dozens of SQL tables looking for queue backups, delayed processing, process errors, etc.
Technologies… C#, SQL Server