Search
Subscribe
Categories
- Backup and Restore
- Configure
- Contact me
- CPU
- Data Architecture
- Data Import and Export
- Database Mirroring
- DBA
- DBA Scripts
- Deadlocks
- Development
- Disaster Recovery
- Disk Storage
- DMV
- Documentation
- Event Log
- Function
- High Availability
- Indexes
- Install & Setup
- Interviews
- IO Subsystem
- Jobs
- Links
- Locking
- Memory
- Monitor Performance
- MSDB
- Network
- Object Management
- Pagination
- Partitioning
- Performance
- Powershell
- Security Management
- SQL Agent
- SQL Azure
- SQL Cachestore
- SQL Error Logs
- SQL Optimizer
- SQL problems
- SQL Server Error Tips
- SQL Server Management Studio
- SQL Server Profiler
- SQL Server Tuning
- SQL View
- SQLServer-DBA News
- SSIS
- Statistics
- T-SQL
- TempDB
- Tools
- TPC-H
- Transaction Logs
- Virtualization
- Wait Stats
Recent Posts
- Powershell Get-EventLog and Event Log messages
- SQL Server - DBA Team FAQ
- SQL Server – Powershell Active Directory search
- SQL Server – read only database status
- SQL Server – DBA productivity and less is more
- Powershell default start directory
- SQL Server Product Life Cycle
- Not enough storage is available to complete this operation
- Send email from Powershell with attachment
- List failed SQL server Jobs with Powershell
Different queries are optimized for different objectives
Response Times and Throughput are two standard objectives.
Response Time is about retrieving the hits as quickly as possible. In a search engine , that would mean returning the first few rows immediately
Throughput is about returning ALL the hits (rows) in the smallest time frame
Factors to consider in improving Response Time
1) Parallelism
2) Partitioning
3) Data types – such as CLOBs in the table
4) Sorting
5) Memory
See Also
Waitstats CXPACKET wait type and how to reduce it
SQL Server Performance ,memory pressure and memory usage
SQL Server Buffer Cache Hit Ratio and memory pressure
Author: Jack Vamvas (http://www.sqlserver-dba.com)Author: Jack Vamvas (http://www.sqlserver-dba.com)
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |