MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

qrdrsvc.exe (Queue Reader Agent), 175, 480

Quality assurance (QA), 537

quality management tools, 403–404

queries, 70–71

concurrency issues, 116–118

latches, 118–122

locks. See locks

replication baselines, 513

Database Tuning Advisor, 71–76, 73–76

distributed, 469–474, 470, 472–473

DMVs, 35, 54–55

exam essentials, 152

hints, 90–92

indexes. See indexes

iterative processes for, 116

performance issues, 87–88

plan guides for, 92–94

plans, 81

analyzing, 86–87

generating, 81–86, 82–83, 85

troubleshooting, 41

poorly performing, 76–77

DMVs, 79–81

plans for, 77–78, 77

traces for, 78

for quality data, 403

recompiling, 89–90

review questions, 153–162

summary, 151

for validation. See joins

Query Timeout option, 464

Queue Length counter, 229, 235

Queue Reader Agent (qrdrsvc.exe), 175, 480

queued updating subscriptions, 176, 429, 505

queues, Service Broker, 276