Scalable Solutions are also producing
Server Analyzer- a .NET based
tool that analyses both the configuration of database servers and your databases
design as part of the optimisation process. Server Analyzer can be used by consultancies
or DBAs performing Health Checks on SfL installations or by development staff checking
database design.
Server Analyzer can analyse your database designs, database
queries and server configuration in one hit and tell you how to reconfigure your
system to remove the bottlenecks.
If you have sql server performance issues or website performance issues our team can solve them. How confident are we? Well, WE HAVE NEVER HAD AN UNSATISFIED CLIENT, EVER. We guarentee you will get improved performance or there is no cost. We deal with any sql situations where you need high performance - from complex realtime multiuser systems with locking escalation issues, to replication or reporting servers or bulk batch processes processing millions of records that need optimising.
Andy Robertson, Managing Director, Chelmer Limited
"We had a very large, complex system which was originally written for a SQLServer
6.5 database that after porting to SQLServer 2000 wasn't performing to business
requirements. After two other expensive specialist database company reviews and
recommendations and hardware upgrades failed to deliver meaningful results, Scalable
Solutions were invited to look at our systems. With the help of their new beta product
Server Analyzer they have really transformed the performance of our systems. We've
seen a 73% reduction in disk I/O, a 50 fold increase in performance of some procedures
and by implementing Server Analysers index and structural changes our database is
now smaller than it was a year ago ? despite significant transaction growth. We're
very happy with the cost effectiveness and the results delivered by Scalable Solutions."
Richard Newson, IT Manager, ABN AMRO Craigs
Our support staff had been complaining bitterly about the responsiveness of a particular
application which frequently took 60 seconds to retrieve customer details. Despite
the problem lingering for weeks, other consultants and even the company that originally
developed the software were unable to find a solution. Scalable Solutions however
really nailed the problem in unbelievable time. 15 minutes on site and the problem
was located and verified. 5 minutes later, after consultation with the original
development company, a solution was implemented in production!