Microsoft SQL Server Monitor
SQL Server object
Microsoft SQL Server provides objects and decisters to monitor the processing of the SQL Server system. The object can be a resource of Microsoft Windows or SQL Server, each of which contains one or more memo, which can be determined on different levels of the object. This appendix lists the names of these objects, as for details of each of the objects, enter "Use SQL Server Items" in the "Line Book" search page, and click on the subject, click to enter the object, Details of each curler can be obtained.
SQL Server SQL Server: Access Methods Search and measuring the configuration of the SQL Server library object. SQL Server: Backup Device Defines a single meter that provides a backup device to perform performance, and each item has a record of its own record. SQL Server: Buffer Manager This object's record provides information about the memory buffer used by SQL Server. SQL Server: Cache Manager This object is used to review the information. SQL Server: Databases This object provides that the records provided by this object can be used to monitor each of the system, and the selected object executes an individual represents the monitored database. Monitable database includes Master, Model, MSDB, Tempdb, Northwind, Pubs, and database established by all users. SQL Server: General Statistics provides activities related information about a general server range, such as the number of users who are currently connected to SQL Server execute individuals. SQL Server: Latches provides latch-related information for internal resources used by SQL Server. The latch is the lock mechanism used inside the SQL Server. SQL Server: Locks provides information on individual locks required by SQL Server, such as locking overtime and deadlock. This object contains multiple execution individuals. SQL Server: Memory Manager provides information about the SQL Server Memory except for buffering and quick access. SQL Server: Replication Agents Uniquely provided records are related information about the process of executing the proxy program. SQL Server: Replication Dist provides information about distributors and subscribers. SQL Server: Replication LogReader provides information about distributors and issuers. SQL Server: Replication Merge provides information about SQL Server consolidated multiplexing. SQL Server: Replication Snapshot provides information about SQL Server snapshot. SQL Server: SQL Statistics provides information about SQL query. SQL Server: User SetTable Executes Self-order. Each counter can be custom programs, or any transact-sql statement that can be sent back to the value. DBCC command
