Page 166 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes Windows NT 4.0 and Windows 2000 also provides these monitoring tools:
Task Manager: Shows a synopsis of the processes and applications running on the system.

Network Monitor Agent: Assists in monitoring network traffic.
There are also some third-party tools such as BMC DBXray, Embarcadero Performance
Center, HybridX SQL Spy, Intrinsic Design Coefficient, Mercury Interactive SiteScope,
NetIQ DiagnosticManager, Zero Impact SQL Monitor, NetIQ AppManager, SQL Server
Monitor, etc.

!
Caution Keep in mind that you probably don’t want these products running against your
SQL Server machine 24x7, since they may take resources away and actually contribute to
the problem

11.6 Choosing a Monitoring Tool

Microsoft® SQL Server™ provides a comprehensive set of tools for monitoring events in SQL
Server. Your choice of tool will depend on the type of monitoring and the events to be monitored.
For example, ad hoc monitoring to determine the number of users currently connected to an
instance of SQL Server can be accomplished by using the sp_who system stored procedure,
rather than creating a trace and using SQL Profiler.
The choice of a monitoring tool depends on the type of events and activity to be monitored.

Event or activity SQL System Current Activity Transact-SQL Error
Profiler Monitor Window logs
Trend analysis Yes Yes
Replaying captured events Yes
Ad hoc monitoring Yes Yes Yes Yes
Generating alerts Yes
Graphical interface Yes Yes Yes Yes
Using within custom application Yes 1 Yes

Self Assessment

Give one word for the following:
6. Time required for the first row of the result set to be returned to the user in the form of
visual confirmation that a query is being processed.

7. A time measure of the total number of queries handled by the server during a given time.
8. A monitoring tool that enables you to monitor server and database activity
9. A monitoring tool that enables you to monitor server performance and activity using
predefined objects and counters or user-defined counters.
10. A windows monitoring tool that shows a synopsis of the processes and applications
running on the system.

11. A tool which enables you to check performance statistics and the logical and physical
consistency of a database.

160 LOVELY PROFESSIONAL UNIVERSITY