T

T-SQL

agent profiles, 510–511

data types, 440–443

event classes, 242

performance, 70

table data type, 443

Table Lock Escalations/sec counter, 233

TABLE resource, locks for, 128

table scans in query plans, 86

tables

checking, 306–307

fragmentation, 102–105, 102–103, 108–111

hints, 139–140

TABLOCK hint, 140

TABLOCK option, 302

TABLOCKX hint, 140

tail-log backups, 185

Target Server Memory (KB) counter, 238

target servers (TSX), 322

Task Manager utility, 6, 23

Temp Tables Creation Rate counter, 232

Temp Tables For Destruction counter, 233

tempdb database, troubleshooting, 45–47

TEMPLATE plan guides, 93

templates, SQL Server Profiler, 9–12

temporary snapshots, 349

Term Extraction transforms, 377

Term Lookup transforms, 377

test servers, 525

thresholds, monitoring, 234

database engine, 237–238

disk I/O, 236–237

memory, 236

network I/O, 237

processors, 235–236

Replication Monitor, 499–500

throughput baselines, 513

timely data, 402

Timeout event class, 133, 241

timestamp data type, 443

tinyint data type, 440

Top Transactions reports, 27, 49

TornPageDetection option, 424–425

Total Latch Wait Time (ms) counter, 234

%Total Processor Time counter, 21

@@TOTAL_READ function, 32

_TOTAL resource, locks for, 127

Total Server Memory (KB) counter, 238

TRACEOFF command, 33, 51

TRACEON command, 33, 51

tracer tokens, 500–501, 501

traces

default, 29

events, 256–257, 278–279

flags, 33, 143–144

logs, 346–347

Performance Logs and Alerts, 12–18, 13–15, 17–18

for poorly performing queries, 78

server monitoring, 238–242

SQL, 18–19

SQL Server Profiler, 9

TRACESTATUS command, 33

tracking changes, 539

Transact-SQL

agent profiles, 510–511

data types, 440–443

event classes, 242

performance, 70

TRANSACTION entity, locks for, 127

Transaction Log Shipping Status report, 27

transaction logs

backups, 184–185, 191–193

restoring, 200–201

transactional consistency, 480

transactional replication, 175–176, 476–477

configuring, 481–485, 482–485

conflicts, 505–506, 506

with updating subscribers, 431–432

transactions

DMVs, 56

isolation levels, 123–126

reports, 27, 49

Transactions/sec counter, 232

Transfer Database task, 374

Transfer Error Messages task, 374

Transfer Jobs task, 374

Transfer Logins task, 374

Transfer Master Stored Procedures task, 374

Transfer SQL Server Objects task, 374

transforms, 376–377, 426

Transition Faults/sec counter, 230

TRC_ events, 256–257, 278–279

trend analysis requirements, 222–223

triggers, 262

vs. constraints, 445

DDL, 270–274, 542–545

DML, 263–269, 265

vs. event notifications, 276

replication, 493–494

troubleshooting, 2–4, 38–39, 47–48

concurrency issues, 116–118

latches, 118–122

locks. See locks

replication baselines, 513

database-level DMVs for, 52–56

DBCC commands for, 50–51, 52

deadlocks, 147–151, 150

DMVs for, 19–20, 19

DTA for, 52

exam essentials, 57–58

instance. See instance performance

I/O bottlenecks, 23–24, 44–45

memory, 22–23, 42–44

methodology, 4–5, 20–21

physical servers, 20–24

processors, 21–22, 39–42, 41

review questions, 59–68

SQL Server 2005 tools, 9–12, 10

summary, 57

Summary Report pane for, 48–50, 48–50

tempdb problems, 45–47

traces for, 18–19

Windows tools, 6–9, 7–8, 12–18, 13–15, 17–18

TRUNCATEONLY option

DBCC SHRINKFILE, 316

SHRINKDATABASE, 315

TRY/CATCH construct, 114–115

TSQL template, 10

TSQL_Duration template, 11

TSQL_Grouped template, 11

TSQL_Replay template, 11

TSQL_SPs template, 12

TSX (target servers), 322

Tuning Options tab, 73, 73

Tuning template, 12

two-phase commits, 429