Processing data allows for expansion of mobile options
The Moser Big Data team re-engineered the point of sale system of an international food services company at the main data warehouse, which allowed for double the data to be processed in a fraction of the time. This provided timely reporting with empowering analytics for the management team‘s daily decision making and enabled the company to move forward with increased mobile ordering and delivery options.
Health Check of Systems Reveal Gaps
Moser was engaged by a client with a critical performance issue. The Moser team started the engagement by running the Moser SQL Server Health Check, which identified numerous performance and configuration issues. Upon applying the recommended stability fixes, disaster recovery fixes and performance recommendations, the performance improved dramatically.
The graph above shows wait time on the database per day (wait times is on the vertical axis and the day is on the horizontal axis of the graph). The first set of recommendations were implemented on August 10; the second set on August 22. This resulted in a total 58% performance improvement.
IRIS Works
Delivered as a SaaS application, Iris provides independent photographers and small photography studios with a suite of tools helping them organize and run their businesses. Users can manage leads and create email marketing campaigns, create task workflows around customer photo shoots, build custom online surveys, execute work contracts with customers through online signatures and approvals, manage finances through an invoicing and billing module, and upload customer photos for review in online galleries.
An Ounce of Prevention is Worth a Pound of Cure
Moser Consulting was contracted by a health agency to ensure their systems were running as they should be, and to assist in moving databases. The client was not aware of any issues; however, on the first day of the engagement, Moser consultants ran a Moser SQL Server Health Check. The Health Check showed that one of the client’s main database servers was out of disk space, which was going to cause an outage to a central application that the hospital relied on. Moser presented this finding to the staff and the outage was prevented.
Saving Money by Organizing Databases
A local organization was spending $388,000 dollars to license SQL Server across their environment. Moser embarked on a Database Consolidation project to better utilize hardware and consolidate from 15 database servers to 3 database servers. After the project, the licensing cost was $62K. This is a savings of $325,000 dollars.
Regular System Outages Avoided
A company that monitors checkout areas in stores contracted Moser Consulting when their database application became unresponsive to the point the client was restarting their database 3-4 times a week. This caused lengthy outages and reduced productivity. Moser consultants came in and set up a Moser Health Check. While still in the monitoring phase, one of these events occurred allowing the team to identify the root cause of this issue as a segment of poor performing queries. The Moser team identified and implemented missing indexes, which fixed the performance of these queries. This stabilized the entire application as well as improved the overall performance.
Subscription Websites
A series of subscription websites leveraged a custom-developed framework to allow customers to sign up for recurring products and services. Online payment profiles, gift subscriptions and options for frequency allowed users complete control of their account. Tools for automating shipping, label creation and custom gift tag creation were constructed and provided to the customer admin. Additional tools allowed the client to project upcoming subscription levels for product fulfillment planning.
Missing Data
A national device component manufacturer approached Moser Consulting with an issue of critical sales data disappearing from their database. The company had verified that the data was in the database originally, but then the data disappeared. Moser quickly set up a few troubleshooting tasks. Moser accurately identified the area in the client code that was causing the data to go missing and immediately fixed the problem.