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
http://www.sqlservercentral.com/blogs-admin/blogs/livingforsqlserver/CSSUG_SQLOS_Basics_15Dec2012/SQLOS_CSSUG_Meet_15Dec2012.zip
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
CPU
SMP vs. NUMA
Preemptive vs. Non Preemptive Scheduling
SQLOS & CPU
Requests – Tasks – Workers – Threads - Schedulers
Memory
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 !!!