SQL Server 2000 Management PackThis management pack is designed to monitor SQL Server. SQL Server runs the back-end components of many of Microsoft's technologies. In terms of the contents of this book, SQL Server can be found running the databases for SMS and MOM. This management pack will help you maintain the availability of SQL Server as it watches for problematic events and measures useful counters. InstallationThe SQL Server 2000 management pack consists of the following files: As of this writing, the latest version number is 05.0.3100.0000. After downloading the management pack, extract the contents to a common location and follow the steps in Chapter 8 to import the management pack. After importing the management pack, check the version number against the version number stated in the Management Pack and Product Connector Catalog. You can get additional information on the SQL Server 2000 management pack at http://www.microsoft.com/technet/prodtechnol/mom/MOM2005/Library/.mspx or in the SQL Server MP Guide.doc included with the management pack. ConfigurationAlthough the SQL Server 2000 management pack monitors your environment out of the box, some additional configuration changes can help fine tune monitoring to match your SQL Server environment. All of the configuration changes are made with native components of MOM. The "Scripts" section later in this chapter has all the scripts of this management pack with definable parameters. These parameters can be adjusted as required. Remote Connectivity MonitoringRemote Connectivity Monitoring verifies connectivity and responsiveness of SQL instances by issuing simple select statements from a remote client. This ensures that all the components necessary for responding to these requests are working properly on the SQL Server. In order to implement this, a few things need to be done.
The remote client must match the following requirements:
ComponentsThis management pack consists of the following:
The Microsoft SQL Server 2000 Computer Group is formula-based and will populate the computer membership based on an attribute match on Microsoft SQL Server 2000. This should make up the majority of SQL Servers in an organization. Computers can be added manually to Microsoft SQL Server 2000 Agentless Server or Microsoft SQL Server 2000 Client-Side Monitoring statically where required. ScriptsThis section lists all of the SQL Server 2000 management pack scripts that contain definable parameters. Many of these scripts contain the parameter InformationEvent. As with other management packs, this parameter is valuable only as a method for troubleshooting. Enable it if you're not certain that scripts are running. Reviewing the following scripts will help you better understand how the scripts support the management of the SQL Server 2000 infrastructure in your environment. SQL Server 2000 Block AnalysisThis script watches system process IDs for any potential blocking.
SQL Server 2000 Database Configuration MonitoringThis script examines all the databases on a SQL Server and determines if the configuration is aligned with best practices. Other than the InformationEvent parameter, the True/False values in this table do not enable or disable the script option. Instead, it defines whether or not an option is turned on. In other words, all values listed are examined. For example, if AutoClose is set to True, the script checks to see if the option is enabled. If it's set to False, the script checks to see if the option is disabled.
SQL Server 2000 Database HealthThis script checks databases to determine if they're healthy. If the database is in Emergency Mode, Recovering, or Suspect state, the script generates an event.
SQL Server 2000 Long Running Agent JobsThis script watches all SQL agent jobs running on the SQL Server. If any jobs exceed the specified value in the ThresholdInMinutes parameter, an alert is raised.
SQL Server 2000 Remote ConnectivityThe Remote Connectivity script performs Transact-SQL queries from a remote machine against the SQL Server. If queries run too long or do not succeed, an alert is raised.
SQL Server 2000 Replication MonitoringThis script looks for replication failures.
SQL Server 2000 Service AvailabilityThis script monitors the following services: SQL Server, SQL Agent, and Full Text Search.
SQL Server 2000 Service DiscoveryThis is the discovery script for the SQL Server 2000 management pack. It discovers the installed instances of SQL Server.
SQL Server 2000 Service Pack ComplianceThis script checks each instance of SQL Server to determine if the version of SQL is compliant. The version of SQL it checks for is based on the parameter VersionString. SQL Server 2000 Space AnalysisThis script checks for database free space. It raises alerts at error or warning based on the parameters in the script. If a database is set to autogrow, the script will account for this and generate an event specifying that an alert would have been raised if one or more of the database files had not been set to autogrow.
TasksThe following table lists the available tasks in this management pack. It also states the context that the task runs in.
|