Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 (Certificate)

New Horizons Malaysia
Kuala Lumpur, Kuantan, Penang, Petaling Jaya, Malaysia

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.

Phone:+ 603-26946455

School Address:

3rd Floor, Wisma Thakurdas
Kuala Lumpur,16-1, Jalan Raja Laut 50350
Malaysia


Jobs & Resumes: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Houses & Roommates: Kuala Lumpur, Kuantan, Penang, Petaling Jaya
Travel Agencies: Kuala Lumpur,

Search other schools for Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 training resources.

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: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.