Understanding Memory, Process, Thread Architectuure and Resource Governor in SQL Server 2008

Register Login

Friday, May 24, 2013

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos Advanced Architecture and Configurations

Understanding Advanced SQL Server 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

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

Configuring SQL Server 2008 Server

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

Memory Configuration in SQL Server 2008

In this tutorial you will see how to:

Review instance memory via T-SQL

Understanding Memory, Process, Thread Architecture, and Resource Governor in SQL Server 2008 (Advanced Architecture)

In this module you learn about configuring 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, and background processes/threads and their functions.

Tracking SQL Server Memory Performance

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

Tracking Processor Usage using SQL Server DMVs

In this demonstration you will see how to:

Use Dynamic Management Views to see processor usage

Privacy Statement

Terms Of Use