object counters. See performance object counters
Object Execution Statistics reports, 49
OBJECT plan guides, 92
OBJECT resource, locks for, 128
objective data, 402
Office SharePoint Server 2007 server, 404
OLE DB Command transforms, 377
OLE DB destination, 378
OLE DB providers, 457–458
configuring, 461–464
for distributed queries, 469–470, 470
OPENDATASOURCE statement, 471
OPENQUERY statement, 469
OPENROWSET statement, 471
OPENTRAN statement, 51
operating system
DMVs, 36–38
monitoring, 227–228
in performance, 3
operators, SQL Server Agent for, 245–246, 245
OPTIMIZE FOR query hint, 91
Optimizer Memory (KB) counter, 234
optimizing. See performance
Options page, 109, 109
order
DML trigger execution, 264
in query plans, 84
outputs
job dependency diagrams, 320
query plans, 84
OutputVerboseLevel parameter, 509
overhead, 222–223