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

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