Moser Consulting has a highly skilled and talented team of SQL Server DBAs. We are experienced in large and small environments, 24x7 and 8-5 shops covering a wide variety of industries including government, healthcare, finance, eCommerce, energy, education, non-profit, technology and manufacturing.
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. The first set of recommendations were implemented on August 10; the second set on August 22. This resulted in a total 58% performance impovement.
Improve performance, reliability, stability and scalability of SQL Server database environments by implementing the MOSER SQL Server Health Check recommendations.
The MOSER SQL Server Checkup is an analysis on a SQL Server Database Environment. We analyze the setup, health and performance of all database servers and recommend changes based on our experience and knowledge of SQL Server Best Practices
Are users complaining about sluggish performance? Is there a query that just won’t perform well? Do your hardware metrics indicate no issue but things are still slow? Moser has a team of expert performance tuners that will identify, recommend and in many cases, fix the issue.
Don’t have a need for a full-time (and backup) DBA? Many environments in this situation rely upon a developer or systems admin to also do database administration duties. This is a scary proposition because your data is one of your most valuable assets. It is very common for database environments to be at risk due to the limited Database Administration knowledge.
An alternative solution is to utilize Moser’s DBA as a Service. You will have highly skilled and experienced DBAs you can trust with your data.
What are the benefits of AWS and Azure? What is the difference between PaaS and IaaS? Which is a better fit for your database environment? We have experience in many different cloud computing providers and have worked with the different platforms. We can help you determine the best decision for your needs and help with the transition to the cloud or elsewhere.
SQL Server 2012 is out of mainstream support after June 2017. All databases should be upgraded to SQL Server 2014 or SQL Server 2016 to keep your data on vendor supported software.
Save HUNDREDS of THOUSANDS or even MILLIONS of dollars!! Many database environments are scattered on a varying array of hardware. Sometimes databases share hardware resources with other applications or processes. SQL Server Licensing can get expensive in situations like this. Moser Consulting has helped clients save MILLIONS of dollars by consolidating databases.
SQL Server Technology Lead
18 years IT experience
14 years working with SQL Server in a variety of roles: Report Writer, Database Developer , DBA, Lead DBA, Manager, Consultant
Passion for making databases run faster
A local hospital 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.
A national bicycling 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.
Moser Consulting was contracted by a local hospital 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.
An international manufacturer that serves the poultry industry had a sales application that would take up to 15 minutes to respond to different customized levels within the product. The client believed this was causing issues and hired consultants from other firms to help them. After each of the previous companies reported no performance issues, they called Moser Consulting. The Moser team ran the Moser Health Check and provided a 12-page document with performance and best practice issues. After implementing the fixes, the wait per level went from 15 minutes to 3 minutes, which is still too long. Moser consultants then identified what the third-party application was doing and recommended how it should do things in order to perform the operations in a reasonable timeframe. The client took the Moser recommendations and worked with the vendor to get a new version implemented, which included the recommended improvements.
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.