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

Length: 34 Minutes 40 seconds

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

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

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

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

Length: 9 Minutes 14 seconds

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?