|
 |
        
|
|
Wisely, Hilton management decided to seek the advice of SQL Server performance experts regarding the scalability issues they might encounter and to optimize application performance before opening up access to many more users than the application was originally designed to support. SQL Consulting, Inc. was called in and identified many potential problems in hardware, application code, indexing and server configuration. We resolved many of the issues and provided assistance to Hilton's development team in resolving others. This pro-active and collaborative approach made for a much smoother transition than otherwise might have occurred.
The budget for the project was small. Our first task was to identify specific optimizations that would result in the greatest performance benefits at the least cost. Our second was to leverage the expertise in their own IT group to aid in the project. The results pleased everyone. Users were pleased because, in some critical areas, we were able to reduce application response times from minutes to seconds. In general, application performance was improved dramatically across the board. Managers were pleased because user productivity was improved to a corresponding degree and because all of this was accomplished within tight budget constraints. In the real world, there is always a budget constraint. Solving a performance problem within the budget requires careful analysis to determine where efforts can be applied in the most cost-effective manner. That, in turn, requires the kind of experience and knowledge we acquired by years of specialization.
The web has become an increasingly important part of the New York Philharmonic’s reservation and ticketing operations. More patrons are coming to their website to find out what’s happening with one of the world’s finest and most renowned symphony orchestras. Concerts sometimes sell out very quickly after being announced and that leads to intense bursts of activity on their website. Looking ahead to the anticipated growth in this area of their operations, they wanted to make sure they were ready for more frequent bursts of activity involving higher numbers of web users. They called in SQL Consulting to work with their IT staff and vendors to make sure their system could handle projected loads. We also assisted their staff in creating a robust disaster recovery plan. Working in concert, we achieved our goal of enabling web patrons to enjoy world-class web performance and to complete their event reservations prestissimo.
SQL Consulting, Inc. was originally called in to solve performance problems in their ecommerce and warehouse management systems caused by their rapid increase in business volume. In a short time, we had the database systems performing well again. The management team then asked us to help them address longer term issues. These included data security, future scalability and high availability. We are currently engaged in a collaborative effort with US Auto Parts to insure ongoing performance and stability in their database environment.
Although Intier’s SQL Server database was performing adequately for the existing load, they wanted some assurance that it would scale to handle higher volumes of traffic. They called us in for performance analysis and tuning. We also examined and made recommendations concerning their high availability and data redundancy architecture to ensure that a hardware failure would not shut down their assembly line and that their data was safe and easily recoverable in the event of disaster.
The budget was small and our first priority was to identify areas where we could make the most difference in the least amount of time. We identified the most poorly performing application code. Working with the vendor, we created new indexing schemes and reworked a relatively small amount of SQL code. The result was dramatic performance improvements in many critical areas of the application. The limited budget did not allow for a perfect solution but both we
and our client are very happy with the results achieved within the budget
constraints.
With offices around the world accessing the corporate SQL Server database, they have a large transaction volume around the clock. SQL Consulting, Inc. worked alongside NCS Pearson's own IT staff to tune the data systems to operate at optimum levels.
Under the demands of thousands of students completing on-line assignments and professors analyzing student performance, the SQL Server database supporting Aplia's website is often under heavy load. SQL Consulting works with Aplia's own development team to insure that the database performs at peak efficiency around the clock and that it will scale to meet growing demand.
By early 2004, the demands of their rapidly growing business had exceeded the capacity of their legacy data system. The system that had worked well for a small company was simply too slow and unstable for the company they had become. They called on SQL Consulting, Inc. to help them make a rapid transition to a faster and more robust database environment built on SQL Server. The entire process was completed quickly and the benefits were immediate. Speed and stability were impoved dramatically. No user re-training was necessary because their existing database applications were re-used with very little modification.
Columbia Ultimate Software, Vancouver WA For the last 25 years Columbia Ultimate has been an industry leader providing collections and receivables software. SQL Consulting, Inc. assists them in performance tuning and troubleshooting their new generation of software. Working beside their development team, we provide the additional SQL Server expertise that has allowed them to realize optimum performance from their applications.
home  
about us
services and support
client list
contact us
email
Link to this site
Copyright © 2008 SQL Consulting All rights reserved |
