- The Concept of Software Scalabililty
- Factors Affecting Application Performance
- Steps Involved in Tuning
- Summary
Factors Affecting Application Performance
Database design and code can affect performance greatly, so the next four articles in this series will teach you how to optimize this part of your application. However, performance tuning doesn't start or end at the database level. Application performance problems can be caused and mitigated at any of the following areas:
Network topology and throughput
Server hardware configuration (for database and web servers)
Front-end application code developed in Active Server Pages, Visual Basic, C++, PowerBuilder, Cold Fusion, or other languages
Middle-tier components, typically written in Visual Basic or C++
Database code, typically developed in T-SQL or PL-SQL
SQL Server (or other RDBMS) configuration settings
Logical and physical database design
Operating system settings
Client hardware
Overall application architecture
Any combination of the items above
As you might guess, performance tuning is not an easy exercise and might take the efforts of a fairly large team.