SQL Server Essentials for Oracle DBAs: (13) Performance Tuning
- Posted: Dec 28, 2012 at 9:11 AM
- 2,017 Views
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…”
Module 13 is divided into two sections: tuning an instance and tuning an application. Tuning the instance involves taking steps to ensure that system resources such as memory, CPU and I/O are used efficiently. Tuning an application starts with the design and architecture of the application and involves tuning database operations and access paths.
- [04:53] - Application tuning
- [11:40] - Instance tuning
- [23:20] - Data compression
- [40:31] - T-SQL hints
- [52:05] - Plan guides
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
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
Oops, something didn't work.
What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.sign up for email notifications?