Factors That Impact Performance
Application Architecture
Application Design
Transactions and Isolation Levels
Transact-SQL Code
Hardware Resources
SQL Server Configuration
Saturday, November 8, 2008
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.
Subscribe to:
Posts (Atom)