Configuring SQL Server Instances

Configuring SQL Server Instances. This presentation covers the following topics :

  • SQL Server Instances
  • Instance-Level Settings
  • Memory Allocation
  • Using sys.sp_configure
  • Memory management
  • Processor and I/O Affinity
  • priority boost option
  • lightweight pooling
  • Configuring Fill Factor
  • The model database
  • Installing Additional Instances
  • Instance Names
  • Deploying Software Updates
  • Resource Governor
  • Cycle SQL Server Error Logs

For more presentations regarding this subject, use this link.

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…