Module 3: Instance Architecture

In this module, you will learn the following:

Configure a Database Server
Memory Architecture Overview
Memory Areas and Their Functions
Process and Thread Architecture
Controlling Resources in SQL Server 2008
Client and RDBMS Interactions
Background Processes/Threads and Their Functions

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 34 Minutes 40 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 3: Demo 1

In this demonstration you will see how to:

Manage instance configurations through SSMS
Manage instance configurations through T-SQL scripts
Manage instance configurations through PowerShell

Video Download
WMV

Length: 8 Minutes 8 seconds

Module 3: Demo 2

In this demonstration you will see how to:

Review instance memory via T-SQL

Video Download
WMV

Length: 6 Minutes 13 seconds

Module 3: Demo 3

In this demonstration you will see how to:

View the setting for the Instance though SSMS
Use the Task Manager for quick Memory allocations
Track memory performance though counters
Improve memory usage in a 32-bit system

Video Download
WMV

Length: 7 Minutes 39 seconds

Module 3: Demo 4

In this demonstration you will see how to:

Use Dynamic Management Views to see processor usage

Video Download
WMV

Length: 9 Minutes 14 seconds