PL  |  NL  |  FR  |  ES  |  PT  |  IT  |  DE  |  DK  |  NO  |  SE  |  FI  |  GR  |  JP  |  CN  |  KR  |  RU  |  AE

  Report this article

More information

Introduction to SQL

What Is a Database

Installing MySQL Server

Basic SQL syntax: Creating and Modifying tables and databases

Joining SQL Tables

Relational SQL Databases

SQL Data Import Methods

SQL Data Manipulation: Select Insert Delete and Modify SQL data

Setting the Color of a Movie Clip

SQL Server 2005`s Design Goals

A Brief History of Microsoft SQL Server

SQL Server Service Broker Architecture

BI Development Studio in SQL Server 2005

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.