Page 182 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes SNMP table Description
MssqlSrvTable Contains a description of the SQL Server installation. Has a single row
for each installation of SQL Server version 6.5 or earlier or multiple
rows for each instance of SQL Server version 7.0 or SQL Server 2000
running on the server.
MssqlSrvInfoTable Contains general information about the active SQL Server process,
including performance counters.
MssqlSrvConfigParamTable Lists SQL Server configuration parameters.
MssqlSrvDeviceTable Contains an entry for each SQL Server database file defined on the
system.
MssqlDbTable Lists defined SQL Server databases. Contains a single row for each
database.
MssqlDbOptionTable Lists database options set for each SQL Server database.

Task Define the following terms:
1. SNMP
2. SNMP agent

12.14 Summary

Microsoft® SQL Server™ 2000 provides a variety of tools that can be used to monitor the
performance of an instance of SQL Server and the user activity that occurs in databases.
Monitoring allows you to determine whether your database application is working
efficiently and as expected, even as your application, database, and environment change.
Microsoft® SQL Server™ provides a comprehensive set of tools for monitoring events in
SQL Server such as SQL profiler, system monitor, SQL server enterprise manager, etc.

System Monitor makes it possible to obtain up-to-the-second SQL Server activity and
performance statistics.

The database controlled by an SNMP agent is known as SNMP Management Information
Base (MIB). The values contained in an SNMP MIB can be shared with the SNMP MIB of
another application.
System Monitor makes it possible to obtain up-to-the-second SQL Server activity and
performance statistics.

Microsoft® SQL Server™ provides several Transact-SQL statements and system stored
procedures that allow ad hoc monitoring of an instance of SQL Server. Use these statements
when you want to gather, at a glance, information about server performance and activity.

12.15 Keywords

Data Columns: The data columns describe the data collected for each of the event classes captured
in the trace.
Event Category: An event category defines the way events are grouped.

Event Class: An event class is the column that describes the event that was produced by the
server.

176 LOVELY PROFESSIONAL UNIVERSITY