SQL Server Essentials for Oracle DBAs: (08) Server Management

Download

How do I download the videos?

• To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

• It's an easy way to save the videos you like locally.
• You can save the videos in order to watch them offline.
• If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

• If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
• If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
• If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
• If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

• MP3 (Audio only)

  File size

  27.1 MB
• MP4 (iPod, Zune HD)

  File size

  162.0 MB
• Mid Quality WMV (Lo-band, Mobile)

  File size

  74.6 MB
• High Quality MP4 (iPad, PC)

  File size

  355.1 MB
• Mid Quality MP4 (WP7, HTML5)

  File size

  247.7 MB
• High Quality WMV (PC, Xbox, MCE)

  File size

  363.1 MB

Module 8 discusses the administration of various types of resources such as system resources (such as memory, processes, storage, and so on) as well as low-level database resources (such as lock, latches, queues, and so on). As these resources are consumed by transactions, it is pertinent to be able to relate user sessions to the transactions they are running and to the resources they are consuming or requesting. Given the significant difference in how resources are managed and utilized in SQL Server compared to Oracle, it is important for the Oracle DBA to get a firm understanding of what is under the SQL Server hood in order to appreciate and best leverage the technology.

• [05:35] - Using the performance monitor
• [11:34] - Managing storage
• [16:15] - Locks and latches
• [21:44] - Capturing deadlock information

Full course outline:

• Mod 01: Database and Instance
• Mod 02: Database Architecture
• Mod 03a: Instance Architecture Part 1
• Mod 03b: Instance Architecture Part 2
• Mod 04: Data Objects
• Mod 05: Data Access
• Mod 06: Data Protection
• Mod 07: Basic Administration
• Mod 08: Server Management
• Mod 09: Schema Management
• Mod 10: Database Security
• Mod 11: Data Movement
• Mod 12: Backup and Recovery
• Mod 13: Performance Tuning
• Mod 14: Scalability and High Availability
• Mod 15: Monitoring