Home > Kurse - Seminare > Microsoft > Online > Kurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 - Online

Kurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 - Online

Unverbindlich in kontakt treten Zentraler Informatikdienst

Um die Anfrage zu senden, müssen sie die Datenschutzpolitik akzeptieren

Informationen über Kurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 - Online

  • Ziele
    - Identify guidelines for configuring SQL Server Agent. - Identify guidelines for using SQLAgentMail and SQL Mail. - Configure a Microsoft Outlook Exchange profile for your administrative account. - Identify the goals of SQL Server 2000 monitoring. - Identify guidelines for performance tuning. - Identify the factors to consider when detecting database performance problems.
  • Anforderungen
    The Audience for this course include system administrators, database administrators, application developers, systems analysts, and software engineers. A prerequisite skill for this course is an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax.
  • Titel
    Kurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000
  • Inhalt
    Course Overview

    This is the last course in a five part series that deals with managing, monitoring, and troubleshooting SQL Server 2000.

    Deployment Options

    Self-Study

    Accreditation

    CEU credits: 0.70 CEUs

    Total Learning Time

    6 to 8 hours

    Objectives

    Unit 1: Automating Routine Administrative Tasks 3 - 4 hours

    - Identify guidelines for using SQLAgentMail and SQL Mail.
    - Configure a Microsoft Outlook Exchange profile for your administrative account.
    - Configure a Microsoft Outlook Exchange profile for the SQL Service account.
    - Verify that SQL Server Agent has been configured to use a specific mail profile.
    - Configure SQL Mail.
    - Identify guidelines for creating jobs.
    - Identify the factors that determine the permissions required for executing jobs.
    - Identify guidelines for defining job steps.
    - Identify the options for scheduling jobs.
    - Identify guidelines for notifying operators.
    - Identify considerations for managing job history.
    - Create an operator to receive notifications from SQL Server Agent.
    - Create a job by using the Create Job Wizard.
    - Create a job consisting of multiple steps.
    - Identify the process for using alerts to respond to problems.
    - Identify the conditions for SQL Server 2000 to write events to the Windows application log.
    - Identify considerations for creating alerts to respond to SQL Server 2000 errors.
    - Identify the guidelines for creating alerts on a user-defined error.
    - Identify the options available when responding to performance condition alerts.
    - Identify the guidelines for assigning a fail-safe operator.
    - Identify the guidelines for troubleshooting alerts.
    - Create an alert by using the Create Alert Wizard.
    - Create a user-defined error message for use in an alert.
    - Create a performance condition alert.
    - Identify guidelines for troubleshooting automated tasks.

    Unit 2: Monitoring SQL Server 2000 3 - 4 hours

    - Identify the goals of SQL Server 2000 monitoring.
    - Identify guidelines for performance tuning.
    - Identify the factors to consider when detecting database performance problems.
    - Match common monitoring tasks with their features.
    - Identify guidelines for monitoring SQL Server 2000.
    - Identify the monitoring features of the Windows 2000 Event Viewer.
    - Identify the characteristics of the Windows System Monitor.
    - Monitor SQL Server 2000 and Windows resources by adding performance counters.
    - Identify the features and functions of the SQL Query Analyzer.
    - Generate performance statistics and a graphical execution plan by using SQL Query Analyzer.
    - Identify the characteristics of SQL Profiler.
    - Configure SQL Profiler to detect login attempts.
    - Configure a new trace to detect long running queries by using SQL Profiler.
    - Identify the information you can monitor by using the Current Activity Details Pane.
    - Identify the functions and features of Transact-SQL (T-SQL) monitoring tools.
    - Identify guidelines for monitoring memory usage.
    - Identify guidelines for monitoring threads and processor usage.
    - Identify guidelines for monitoring physical disk I/O.
    - Identify how different types of locks affect performance.
    - View locking information.
    - Detect lock blocking.
    - Identify the causes of poorly performing queries.

    Course Access


    Each student has access to the course for a period of 6 months from the day of enrollment in the course.

Ähnliche Angebote die in Bezug zu Ihrer Anfrage "Microsoft" stehen

Diese Webseite verwendet Cookies. Wenn Sie weiterhin navigieren, verstehen wir das Sie der Nutzung einverstanden sind. Vehr sehen  |