SQL 2014 Admin, Part 1 of 5: Configuring and Testing

SQL 2014 Admin, Part 1 of 5: Configuring and Testing

Biz Library
Updated Feb 04, 2020

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.

Lesson 1:

  • A Quick Dive Inside SQL Server
  • A Simple Query
  • A Simple Update
  • Dirty Pages
  • Demo: Dirty Pages
  • Three Main Resources - CPU
  • Demo: Parallelism.

Lesson 2:

  • Three Main Resources - Memory
  • Three Main Resources - I/O
  • Three Main Resources - Other
  • Planning For Growth - CPU
  • Planning For Growth - Memory
  • Demo: Memory Settings.

Lesson 3:

  • Planning For Growth - I/O & Files
  • Demo: Identifying I/O
  • Planning for Growth - Network
  • Planning For Growth - Instances.

Lesson 4:

  • Testing SQL Server with SQLIO
  • SQLIOStress
  • Demo: SQLIO
  • Demo: Running SQLIO
  • Demo: Testing The Drives
  • Demo: Write Functions
  • Demo: SQL Tests.

Lesson 5:

  • Partitioning
  • Partitioning - Benefits
  • Partitioning - Components
  • Creating a Partition
  • Demo: Partitioning
  • Demo: Viewing Partitions.