6SQLServerWindowsNTWindows20006.1EnterpriseManagerSQLServerEnterpriseManager()(MicrosoftManagementConsoleMMC)EnterpriseManagerSQLServerEnterpriseManager6.1.1EnterpriseManagerEnterpriseManagerServerGroup()Management()CurrentActivity()ProcessInfo()(6-1)EnterpriseManagerCurrentActivityCurrentActivityRefresh()6-1EnterpriseManagerProcessInfo()ID(serverprocessIDSPID)SPIDSQLServer()•SPIDSQLServerID•SPID•SPID•SPID•SPIDSQLServer•SPID•SPID•SPID•SPIDSPIDCurrentActivity()BlockedBy()()6.1.2EnterpriseManagerManagerment()CurrentActivity()Locks/ProcessID(/ID)Locks/Object(/)SPIDSPID6.2(PerformanceMonitorPerfMon)SQLServerWindowsNTWindows2000CPUSQLServerSQLServerCPU(6-2)(6-3)669I/O6-26-36.2.13060G1570WindowsNT4Windows2000Windows20001)2)3)(+)4)5)6)7)ProcessorMon8)1)2)1)2)3)()ProcessorMon4)5)6)(+)1)Edit()TimeWindow()2)InputLogFileTimeFrame()(6-4)6-46716.2.2WindowsNT(DiskAdministor)RAIDRAID(DiskPerfService)DiskPerfDiskPerfDiskPerfWindowsNTdiskperf-yDiskPerfServicesapplet()I/OWindowsNT4I/O(I/ORequestPacketsIPR)IRPWindowsNT4IRPDiskPerfIRPIRPI/O(SpinLock)(SpinLockSpinLock)SpinLockCPUCPUDiskPerfIRP1CPUI/OSpinLockWindowsNTIRP1)2)REGEDT32WindowsNT(WindowsNTRegistryEditor)3)HKEY_LOCAL_MACHINE4)System()CurrentControlSet()Control()SessionManager()5)6)I/OSystem7)I/OSystemLargeIrpStackLocationsREG_DWORD8)59)6.2.3SQLServer721.(ProcessorObject)CPUCPU909090•(ProcessorTime)100CPU•(PrivilegedTime)(I/O)CPU(CPU)(DPC)•(UserTime)•(InterruptTime)CPUWindowsNT•/(Interrupts/sec)DPCDPC2.(SystemObject)•(ProcessorQueueLength)•/(ContextSwitches/sec)()/3.SQLServer(BufferManagerObject)SQLServer673•(BufferCacheHitRatio)SQLServerI/OI/O80SQLServerSQLServer•()(CacheSize)SQLServer8KB•(FreeBuffer)SQLServer•/(PageReads/sec)I/O•(StolenPageCount)SQLServerWindowsNT•/(PageWrites/sec)SQLServer4.SQLServer(DatabaseObject)SQLServer•/(LogFlushWait/sec)•(PercentLogUsed)SQLServer5.SQLServer(GeneralStatisticsObject)•(UserConnections)6.SQLServer(LatchesObject)SQLServer•()(AverageLatchWaitTime)•/(LatchWaits/sec)7.SQLServer(LocksObject)SQLServer•()(AverageWaitTime)•/(LockTimeouts/sec)•/(LockWaits/sec)•/(NumberofDeadlocks/sec)8.SQLServer(MemoryManagerObject)74SQLServerSQLServer•(MemoryGrantsPending)•SQL(KB)(SQLCacheMemory)SQLServerSQL•(KB)(TargetServerMemory)SQLServer•(KB)(TotalServerMemory)SQLServer9.SQLServerSQL(SQLStatisticsObject)SQL•/(BatchRequests/sec)SQL•SQL/(SQLCompilations/sec)SQLServerSQL•SQL/(SQLRe-Compilations/sec)SQLServerSQL10.(LogicalDiskObject)I/OWindowsNT•(DiskReadTime)•(DiskWriteTime)•(DiskTime)•(IdleTime)•(Avg.DiskQueueLength)•(Avg.DiskReadQueueLength)•(Avg.DiskWriteQueueLength)•/(Avg.Disksec/Read)•/(Avg.Disksec/Write)•/((Avg.Disksec/Transfer)•/(DiskReads/sec)•/(DiskWrites/sec)•/(DiskTransfers/sec)11.(PhysicalDiskObject)I/O675DiskPerf•(DiskReadTime)•(DiskWriteTime)•(DiskTime)•(IdleTime)•(Avg.DiskQueueLength)•(Avg.DiskReadQueueLength)•(Avg.DiskWriteQueueLength)•/(Avg.Disksec/Read)•/(Avg.Disksec/Write)•/(Avg.Disksec/Transfer)•/(DiskReads/sec)•/(DiskWrites/sec)•/(DiskTransfers/sec)12.WindowsNTWindowsNTWindowsNT()•/(PageFaults/sec)()()()•/(PageReads/sec)()()•/(PageWrites/sec)•/(Pages/sec)/76/6.2.4I/O1.(ProcessorObject)I/OI/O/I/O3I/O2.(SystemObject)/10000SQLServer(lightweightpooling)1(sp_configure)SQLServerWindowsNTI/O3I/O2CPU17183.SQLServer(BufferManagerObject)SQLServerBufferCacheHitRatio()SQLServer80SQLServerSQLServerSQLServerSQLServer(maxservermemory)2147483674SQLServerWindowsNT677SQLServerSQLServerCacheSize()SQLServer8-KBSQLServerCacheSizeStolenPage()8-KBSQLServerSQLServersp_configureminservermemory()0SQLServerWindowsNTPageReads/sec(/)SQLServer4.SQLServer(DatabaseObject)LogFlushWaits/sec(/)I/O5.SQLServer(LatchesObject)I/OI/OI/O6.SQLServer(LocksObject)SQLServerDeadlocks/sec(/)78SQLServer(DeadlockVictim)SQLServer1205SQLServerSQLServerProfiler(SQLServer)SQLServer•SupplierPartSupplier6-56-5••679()1SupplierPart2ParSupplier1SupplierPart2SupplierPart•(ReadCommitted)(Serializable)7.SQLServer(MemoryManagerObject)SQLServerMemoryGrantsPending()SQLServerSQLServer8.SQLServerSQL(SQLStatisticsObject)SQLBatchRequests/sec(/)SQLSQLSQLSQLSQLServerSQLServer9.(LogicalandPhysicalDiskObject)I/ORAIDI/OAvg.DiskQueueLength()RAID791.28(9/7)22I/OAvg.Disksec/Read(/)Avg.Disksec/Write(/)Avg.Disksec/Transfer(/)3/1248011~15SQLDiskTransfer/sec(/)60~80I/ORAIDI/ORAID(33.4.3)10.WindowsNTWindowsNT()WindowsNTCPUPages/sec(/)0(WindowsNT)SQLServerSQLServermaxServermemory()///SQLServerSQLServer/SQLServer6.3SQLServerWindowsNTSQLServerProfiler(SQLServer)681