Factors That Impact Performance

 
Factors That Impact Performance
Application Architecture
Application Design
Transactions and Isolation Levels
Transact-SQL Code
Hardware Resources
SQL Server Configuration

Read Full Post »

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 [...]

Read Full Post »