Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

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.

  • + Share This
  • 🔖 Save To Your Account