Page 180 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes View and manage the Windows application log by using Event Viewer in Microsoft Windows
NT® 4.0 or Windows 2000.

There are three logs that can be viewed with Event Viewer.
Windows log type Description
System log Records events logged by the Windows NT 4.0 or Windows 2000 system
components. For example, the failure of a driver or other system component to
load during startup is recorded in the system log.
Security log Records security events, such as failed login attempts. This helps track changes to
the security system and identify possible breaches to security. For example,
attempts to log on to the system may be recorded in the security log, depending
on the audit settings in the User Manager.
Only members of the sysadmin fixed server role can view the security log.
Application log Records events that are logged by applications. For example, a database
application might record a file error in the application log.

12.9 Monitoring with Transact – SQL Statements

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. For example:
Current locks.
Current user activity.

Last command batch submitted by a user.
Data space used by a table or database.
Space used by a transaction log.
Oldest active transaction (including replicated transactions) in the database.

Performance information relating to I/O, memory, and network throughput.
Procedure cache usage.
General statistics about SQL Server activity and usage, such as the amount of time the CPU
has been performing SQL Server operations or the amount of time SQL Server has spent
performing I/O operations.
Most of this information can also be monitored using SQL Server Enterprise Manager, SQL-
DMO, or System Monitor (Performance Monitor in Microsoft Windows NT® 4.0).

12.10 Monitoring with SNMP

Simple Network Management Protocol (SNMP) is an application protocol that offers network
management services. Using SNMP, you can monitor an instance of Microsoft® SQL Server™
across different platforms (for example, Microsoft Windows NT® 4.0, Microsoft Windows® 98,
and UNIX).
With SQL Server and the Microsoft SQL Server Management Information Base (MSSQL-MIB),
you can use SNMP applications to:

Monitor the status of SQL Server installations. SNMP can only be used to monitor the
default instances of SQL Server.

Monitor performance information.

174 LOVELY PROFESSIONAL UNIVERSITY