Introduction to Microsoft SQL Server SQLOS 2012

Basic introduction to SQLOS scheduling

In the past, scalability of SQL server has always been questioned when it comes to large transactional volumes or VLDB’s (Very Large Databases). Businesses classified Microsoft SQL server as a database engine that can only service small to medium sized type workloads due to its engine capabilities. For this reason the Microsoft SQL Development Team had to make massive changes to cater for the large workload demands, which included:

• The way in SQL server manages system resources
• How SQL server adapts to ever changing hardware platforms
• How SQL server integrates into Windows Operating Systems

Microsoft has been investigating how to design Microsoft SQL server to be more scalable and adapted SQLOS since the release of Microsoft SQL Server 2005.

Download Complete PDF Article