SQL Server Essentials for Oracle DBAs: (13) Performance Tuning
- Posted: Dec 28, 2012 at 9:11 AM
- 2,481 Views
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?