Most Recent Articles

Query Execution Plans
Maximise your value to customers by learn how to interpret query execution plans quickly and correctly, to find and eliminate key bottlenecks without spending hours chasing minor problems.


Caching Correctly
A poorly cached application will either cache too much or too little data leaving your multiuser system seemingly in need of an upgrade.
 
WANT DATABASE PERFORMANCE?

We provide specialist consulting and optimisation services for companies and enterprises seeking to improve their systems performance, without necessarily adding hardware. We assist corporates and development companies with database and application design, as well as performance tuning and hardware sizing. We are experts in Web, Database and Client/Server technologies and use these technologies assist you with the development and implementation of high performance systems.

GET AWESOME PERFORMANCE TODAY

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.

Please call us today on 09 636 4728 or email ewart@scalablesolutions.co.nz

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!