Managing Monitoring and Troubleshooting SQL Server 2000

by Andrew McLaren.
Share
|
Homepage | Submit your article | Contact | TOS
More articles on databases  

You are here: Categories » Computers and technology » Databases

SQL Server Agent Jobs SQL Server Agent is a job scheduling agent that aids in the management of a SQL server. SQL Server Agent can be started when the operating system starts and is configured through the SQL Service Manager or Enterprise Manager. The SQL Server Agent is responsible for the execution of jobs. Jobs are made up of multiple steps that have instructions on what to do depending on the success or failure of each step in the job. Jobs are assigned to an operator, a user who is responsible for that job.

Clients never directly interact with the SQL Server Agent to create or change scheduled jobs as it is controlled purely from data in SQL server tables. When the SQL Server Agent is started, it connects to its instance of SQL Server 2000 and retrieves scheduled jobs, the steps that encompass those jobs, and the possible alerts that may need to be sent.

Notification with SQL Server Agent The SQL Server Agent can be configured to send alerts to operators on the success or failure of a job. Alerts can be sent to operators through paging systems, via e-mail, or through the NET SEND command to operators. Instead of an alert, failed job results can be written to an application log. To send an e-mail notification, the SQL Server Agent must have a MAPI-1 compliant e-mail client and a valid e-mail profile. An operator for the job must be named and the SQL Server Agent must have access to contact information for that operator.

Alerts can be fired for reasons other than success or failure. The SQL Server Agent can be configured to alert an operator when designated events occur. Alerts can be sent when performance conditions, such as running out of disk space.

SQL Profiler The SQL Profiler is a tool that is useful for analyzing the performance of a SQL Server. The SQL Profiler can capture activity that takes place on the SQL server and play it back later for further analysis. SQL Profiler can also simulate load or stress testing. SQL Profiler can view all statements that are running on a system and display graphical information about them. The SQL profiler can be used to determine which SQL statements are consuming the most CPU time and I/O resources.

System Monitor The System monitor is the best tool to monitor overall system performance. SQL Server 2000 is able to export performance data to the System Monitor so a picture of the entire system can be seen. This is useful because an administrator can view the SQL server in the context of the entire system instead of by itself. Important counters to monitor are:

  • Disk Transfers/sec: measures the amount of read/writes that the system does per second
  • Pages/sec: measures RAM paging on the system
  • % Processor Time: measures CPU usage. There are two spearate instances of this counter. One measures CPU usage over the entire system and the other measures CPU usage for a particular process.
Share
Leave a comment or ask a question
Total comments: 0

Databases Disclaimer

  • The e-articles directory is not responsible for any and all copyright infringements by writers and authors. If you suspect the information contained by this page for any copyright infringements, please contact us to investigate the issue
Basic Terms of Structured Query Language (SQL) - The first questions to ask are what is SQL and how do you use it with databases? SQL has three main roles: 1. Creating a database and defining its structure 2. Querying the d (more...)
Extracting and Transforming Data in SQL Server 2000 - SQL Server 2000 has several components that support the import and export of data. Data Transformation Services (DTS) is used to import and export data between like OLE DB (more...)
Introduction to SQL - SQL is an acronym for Structured Query Language and is the standard language for interaction with databases. SQL is both an ISO (International Organization for Standardization) and ANSI (Americ (more...)
What Is a Database - A database is simply an organized collection of information. It allows many different types of data to be stored and retrieved in a highly efficient manner. Information within a database (more...)
Installing MySQL Server - Installing MySQL is relatively painless. First, you need the installation program for MySQL, which is available on the companion CD. You can also download the latest version from (more...)
Basic SQL syntax: Creating and Modifying tables and databases - This tutorial shows basic syntax and commands and of the SQL language. Creating and Dropping Databases First, let's see what databases already exist in the MySQL server. We (more...)
Joining SQL Tables - When accessing information within database tables, we may sometimes need to look at data from two or more different tables, as we saw in the previous example. There is another useful way to acc (more...)
Relational SQL Databases - Think of a database that related the players in a game to one another (for example, to determine who was a friend of each player and who was an enemy of each player). First let's create (more...)
SQL Data Import Methods - This article presents the most common ways of importing data to MySQL. Importing from a Text File To create a text file that contains several records to be added to ou (more...)
SQL Data Manipulation: Select Insert Delete and Modify SQL data - This tutoriald focuses on how to add, modify, and remove data from tables in the database using SQL Data Manipulation Language. Without this knowledge, we would not really have any use for a (more...)
 
free content
    Copyright © 2006 - 2012 e-articles.info.
The texts, articles and tutorials in the directory are property of their respective owners and authors.