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
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 !!!


 

 

 

Rate

Share

Share

Rate