Magical Compression? - A Case Study
ZipTracker.com
ZipTracker.com relies upon SQL Server for back-end processing.
ZipTracker is still growing, and therefore doesn't have dedicated
hardware. Instead a certain amount of SQL Server disk space is leased on a shared server on a month-by-month basis.
Account Over Quota - Suspension Immenent
As is the case with most companies that provide shared SQL Server space, certain contraints are put in
place to ensure that clients aren't able to gobble up too much CPU or disk activity - as it would negatively
impact other clients and users.
Sadly, ZipTracker hit a point one day where it was gobbling up system resources, and the
owner was notified that they had to reign in this problem with their account or it would be suspended as per their terms of service.
Upgrade or Die?
Even if ZipTracker's owner decided to spring for dedicated SQL Server hosting (which would have completely ruined
the current business model by requiring too much money for hosting), there still would have been a period of downtime while
the back-end database was transitioned on to a new platform.
Even worse, if the owner did nothing, the shared account would be suspended, and existing customers using the application
would have seen costly business interruptions.
SQL Server Audits to the Rescue
SQL Server Audits was called in to take a look at the situation. After a quick, live, analysis of the situation, I was able to
dramatically cut back on CPU and disk utilization by cleaning up heavy index and table fragmentation. Not only
did this stop the application from 'hogging' too many resources on the shared SQL Server, but it recovered enough drive space
to provide additional growth opportunities for the growing web application at current hosting prices (rather than requiring additional
hosting fees for increased disk/storage quotas).
Best of all, the entire nightmare was cleared-up in less than an hour, and end-users noticed dramatic performance
benefits across the entire application - proving that SQL Server Audits can help organizations of any size meet their SQL Server needs.
SQL Server Expertise
At SQL Server Audits, I can help save you money and help solve your complex SQL Server problems and concerns.
Contact me today to help put the power of SQL
Server Audits to work for you.