Kurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000
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.
AnforderungenThe 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.
TitelKurs 73479 - Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000
InhaltCourse 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