http://www.sqlservercentral.com/blogs/livingforsqlserver/2012/12/14/sqlos-basics-chennai-user-group-meet-presentation-file-download/

Printed 2014/09/18 02:14PM

SQLOS Basics - Chennai User Group Meet - Presentation File Download

By Ramkumar (LivingForSQLServer), 2012/12/14

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


 

 

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.