Training Course:Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 (Certificate)School/Trainer:New Horizons Singapore
Singapore, Singapore
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL ServerT 2005. The primary focus of this workshop is to teach the overall process of troubleshooting.
Who Should Attend:
This course is intended for current professional database administrators who have three or more years of on-the-job experience administering SQL Server database solutions in an enterprise environment.
Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Prerequisite Comments:
Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential or equivalent experience
Outline: Top
Lesson 1: Building a Monitoring Solution for SQL Server Performance Issues
Narrowing Down a Performance Issue to an Environment Area.
Guidelines for Monitoring Database Servers and Instances by Using Profiler and Sysmon.
Guidelines for Auditing and Comparing Test Results.
Top
Lesson 2: Troubleshooting Database and Database Server Performance Issues
Narrowing Down a Performance Issue to a Database Object.
How the SQLdiag Tool Can Be Used to Analyze Outputs.
Lesson 3: Optimizing the Query Performance Environment
The Methodology of Optimizing a Query Environment.
The Query Performance Troubleshooting Process.
Use of Database Tuning Advisor to Troubleshoot the Query Environment.
Lesson 4: Troubleshooting SQL Server Connectivity Issues
The Methodology of Troubleshooting SQL Server Connectivity Issues.
Areas to Troubleshoot for Common Connectivity Issues.
What Are SQL Server 2005 Endpoints?
Lesson 5: Troubleshooting SQL Server Data Issues
The Methodology of Troubleshooting SQL Server Data Issues.
The Process of Troubleshooting Data Integrity Issues.
How Torn Pages Can Be Resolved using a Single-Page Restore.
Top
Lesson 6: Troubleshooting SQL Server Data Concurrency Issues
The Methodology of Troubleshooting Concurrency Issues.
What Are SQL Server Latches?
...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.newhorizons.com/
Phone:+65 6822 8282
School Address:
298 Tiong Bahru Road
Level 18 Central Plaza
Singapore 168730
Jobs & Resumes: Singapore
Houses & Roommates: Singapore
Travel Agencies: Singapore
Search other schools for Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 training resources.
Other training courses offered by New Horizons Singapore:
Maintaining a Microsoft SQL Server 2005 Database
Implementing a Microsoft SQL Server 2005 Database
Designing Microsoft SQL Server 2005 Server-Side Solutions
Designing Microsoft SQL Server 2005 Databases
designing the data tier for microsoft sql server 2005
tuning and optimizing queries using microsoft sql server 2005
Designing Microsoft SQL Server 2005 Infrastructure and Services
Designing Security for Microsoft SQL Server 2005
Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
Administering and Automating Microsoft SQL Server 2005 Databases and Servers
SQL Server 2008
Maintaining a Microsoft SQL Server 2008 Database
Implementing a Microsoft SQL Server 2008 Database
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
implementing and maintaining microsoft sql server 2008 reporting services
SQL Server Business Intelligence
oracle database 10g - introduction to sql
Oracle Database 10g: Program With PL/SQL
Oracle10g SQL and SQL Plus
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed. |
|
| 
