Skip to main content

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