The Curious Engineer

All blogs / Databases

Slava Oks's WebLog

learn.microsoft.com/en-us/archive/blogs/slavao

DatabasesOS / kernelPerformance / optimizationMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
46 from 26 Jan 2005 to 24 Sep 2017
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/slavao/feed.xml

2017 1

  1. What made Porting Microsoft SQL Server to Linux to be the right move after all

2016 1

  1. One, Two, Three... Boom!

2007 2

  1. Changing gears
  2. Q and A: Ratio between AWE Allocated and VM Committed/Reserved in DBCC MEMORYSTATUS output

2006 14

  1. Q & A: I am running on 64 bit and all of my tasks are waiting on SOS_RESERVEDMEMBLOCKLIST, What is going on?
  2. SQLOSDMV's Continue
  3. Q & A: Does SQL Server always respond to memory pressure?
  4. SQLOS's DMVs Continue
  5. SQLOS's DMVs
  6. Talking points around SQL Server 2005 scalability
  7. Q & A: I can't make SQL Server 2005 32 bit version to use all memory on the machine
  8. Set of new features in SQL Server 2005 enabled by SQLOS
  9. Q and A: Enabling AWE settings for SQL Server 32 bit edition in WOW
  10. Q and A: Some questions about output from dbcc memorystatus
  11. Q and A: SQL Server memory allocated outside of Buffer Pool, formerly known as MemToLeave
  12. Q and A: Do I need to run "sp_configure 'awe enabled', 1" to make 64 bit version of SQL Server use locked pages?
  13. Be Aware: 4GB of VAS under WOW, does it really worth it?
  14. Retrieving information about CPUs' relationships

2005 28

  1. Q and A: Clock Hands - what are they for?
  2. Q and A: Virtual Address Space, VAS, reservation - why bother?
  3. Q and A: x64 & AWE mechanism
  4. Be aware: To Hyper or not to Hyper
  5. Final changes in SQL Server 2005's memory manager
  6. Q and A: Using Lock Pages In memory on 64 bit platform
  7. Talking Points around Memory Manager in SQL Server 2005
  8. Configuring SQL Server 2005 for Soft NUMA
  9. SQL Server 2005 NUMA support & troubleshooting
  10. SQLOS helps SQL Server to leverage hardware capabilities
  11. Platform layer for SQL Server:
  12. Be Aware: VirtualAlloc with MEM_RESERVE can fail even if you have plenty of VAS inside of the process
  13. Q and A: Controlling size of a single cache in SQL 2005
  14. Q and A: Max memory with sql server 2000 / win2003 x64
  15. Be Aware: Using AWE, locked pages in memory, on 64 bit
  16. Be Aware: IA64 Stack Size
  17. SQLOS Caching
  18. Be aware: FLS-Fiber Local Storage
  19. Be aware: a new section in my blog
  20. SQLOS's memory manager: responding to memory pressure
  21. Changes in dbcc memorystatus in Yukon
  22. SQLOS's memory manager and SQL Server's Buffer Pool
  23. SQLOS - unleashed
  24. Look at Memory Leaks - Classify and Identify
  25. Memory Pressure - Classified
  26. Getting an exception call stack from the catch block (C++)
  27. Tracking VAS in Yukon, cont...
  28. Tracking VAS in Yukon