Storage for SQL Server DBAs

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

Storage for SQL Server DBAs

DB-206

Database administrators and storage administrators have always been in different camps. They don’t speak the same language, they don’t have the same point of view, and they don’t use the same tools.

It is quite common to witness a debate between a database administrator and a storage administrator about where the problem is – the database or the storage. These two camps need to work together in order to troubleshoot performance problems and improve throughput. When the database administrator and the storage administrator work well together, the system can get so much more from its storage in terms of capacity, redundancy and performance. The main problem is that each side doesn’t really understand the field of the other.

Most DBAs don’t really understand storage, and most storage administrators don’t really understand databases. The goal of this course is to teach DBAs the language of the storage administrators, the way they look at storage and the tools they use in order to measure capacity and performance.

After this course, a DBA will be able to work together with the storage administrator in order to achieve better results for the system. In small companies, where the DBA is also responsible for the storage, the DBA will be able to see the whole picture and maximize the utilization of the storage.

Audience

The course is intended for database administrators who need to deal with storage (any type of storage) as part of their work. It is relevant for DBAs who need to work with storage administrators as well as DBAs who are responsible for the storage themselves.

Students should have some experience with SQL Server administration, but are not required to have any experience with storage

Course Objectives
  • Be familiar with the different storage types
  • Understand the terminology used by storage administrators
  • Learn how to monitor storage capacity and performance
  • Be able to plan and optimize the storage layout for SQL Server databases
Course Topics
  • Course Introduction
  • Introduction to Storage
  • Spindles
  • RAID
  • Non-Shared Storage
  • Shared Storage
  • Disk
  • Tiered Storage
  • Storage Monitoring
  • SAN Challenges for DBAs
  • Summary
© Copyright - Skilit - Site by Dweb