Factors That Impact Performance

 

Factors That Impact Performance

Application Architecture

Application Design

Transactions and Isolation Levels

Transact-SQL Code

Hardware Resources

SQL Server Configuration

What does database performance means?

What does database performance means?

Database performance enhancement refers to below terms.

Response time: Refers to the interval between the time when a request is submitted and when the first character of the response is received.

Throughput: Refers to the number of transactions that can be processed in a fixed unit of time.

Scalability: Refers to how the throughput and/or the response time changes as we add more hardware resources. In simple terms, scalability means that if you are hitting a hardware bottleneck, you can alleviate it simply by adding more resources.