Performance and Concurrency problems can be caused by many SQL Server environmental and development variables. Symtex work with many clients commonly experiencing a 'slow down' on systems which have, up-until now, behaved as required and responded in a timely and efficient manner, giving no rhyme or reason for such a significant degradation in performance.
Symtex are skilled in the techniques used to obtain the biggest gains in performance and scalability, creating efficient data access code and using correct development techniques. You do not usually get such big gains in performance and scalability by changing SQL Server configuration settings.
A common resolution is to throw tin at a problem suppressing the underlying issue; this often hides the problem for a few weeks or months when you are in the same situation of users complaining, potentially lost revenue or service outages and the awkward position of justifying the previous big spend on a new disk subsystem or server.
Common problems we find include not knowing the performance and scalability characteristics of the system, retrieving too much data, misuse of transactions, misuse of indexes, Missing OLTP, OLAP and reporting workloads, inefficient schemas and using inefficient disk subsystems.
Good efficient schema design is essential for high performanace data access and concurrency of use. Symtex have worked for many UK FTSE 250 companies and of the UKs largest community web sites servicing fifty thousand consecutive users, three thousand transactions per second all day, every day 24*7, contact Symtex today to resolve your performance woes.