Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

Introduction to SQL Server Clustering - Terms and Concepts (Video Series)

Video Image Video Category: Disaster Recovery: Backup, Recovery, Log Shipping, Clustering and Database Mirroring

Skill Level: 400 (Intermediate - Advanced)

Versions/Editions Covered: SQL Server 2005
This video series is designed to help you understand the goals of SQL Server clustering as well as the different types of clusters. This series is lecture-based and will serve as a solid introduction to Active/Passive, Single Instance, Active/Active and Multiple Instance cluster technologies.

This series is a pre-requisite for the cluster installation and management videos

Videos in this Series:


Miscellaneous Bits & Pieces:
Book You Should Probably Own: Joe Celko's "SQL Puzzles and Answers"
Management Tip: Automation is your friend. Make good use of SQL Server jobs and alerts to build a proactive solution. Configure alerts for common scenarios such as backup failures, log filling up, deadlocks and more. Have these alerts fire off jobs that protect and react to the situation. For example, configure an alert that fires off a log backup job if the log of database "MyDb" gets 90% full
Performance Tip: Know your hot set. The "hot set" is the amount of data that your users are currently working with in the database. You want to ensure that you have enough memory in the system to cover (a) the OS requirements, (b) the SQL Server process requirements, (c) the hot set, and (d) a little extra in the event that you need it.

Other Websites We Offer
LearnCSharp.com
Don't Forget!
Become a Guru
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/6/2009 2:12:02 AM