SQL 2014 Admin, Part 1: Configuring and Testing

with expert Chris Bell

In this course you’ll start on configuring and testing SQL Server, you will be introduced to the SQL Server engines and learn how they process incoming requests to the database to get the results you expect in the most efficient ways possible. You will take a good look at the 3 main resources that SQL Server uses, the CPU, Memory, Disk I/O, and a 4th resource that that is commonly forgotten about. You will see how each of these affects the way SQL Server performs, and how the proper configuration of each helps to ensure a stable environment. Then you will cover planning for your SQL Server database’s growth. Then you will use Microsoft’s free SQLIO tool to test the I/O of our SQL Server’s hard drives. You will then see how to determine where performance maxes out based on the results of SQLIO.

Course Outline