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

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