SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQLOS Basics - Chennai User Group Meet - Presentation File Download

Chennai SQL Server User Group (CSSUG) meet is happening tomorrow (15-Dec-2012) in Microsoft Training Centre, Chennai.

You can download presenation and demo scripts here

Tomorrow,  I am going take 2 hour session on SQLOS Basics (Skill level 200-300).

Topics to be covered:

SQL Server Architecture
SQLOS  - Basics
SQLOS – Responsibilities
    SMP vs. NUMA
    Preemptive vs. Non Preemptive Scheduling
    Requests – Tasks – Workers – Threads - Schedulers
    32 bit vs. 64 bit Architecture, /3GB, PAE, AWE, LPM
SQLOS & Memory

Here are some top reliable SQLOS related resources.
For technical accuracy, I have used the contents from below resources and mentioned the source almost in all slides.

Source, Reference & Countesy:

Bob Ward - PASS 2012  - Inside SQLOS 2012 Presentation (SMP/NUMA, SQLOS basics, journey, Scheduler etc)
Wrox Book: SQL Server 2008 Internals and Troubleshooting (CPU, Memory, SQLOS Memory Manager)
MS Press Book : SQL Server 2008 Internals (SQLOS responsibilities)
www.mssqlwiki.com (Memory Architecture and Memory related DMVs)

Slava Oks (SQLOS Memory Manager)
http://www.intellectualheaven.com/Articles/WinMM.pdf (Windows Memory Internals)

Thanks again. Will catch you in my next blog post !!!





I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer


No comments.

Leave a Comment

Please register or log in to leave a comment.