Other SQL Server Tuning
Has a general performance profiling tool
- Generates execution traces
Queries can give optimizer hints:
- Use loop, hash, or merge join
- Use hash or sort to do grouping
- Force use of an index
- Force a join ordering
- Optimize for time-to-nth-result-tuple
- Adjust lock granularities and concurrency (next week…)