Category Archives: Memory

Denali –Memory : Memory Error Recovery in SQL Server 2012

  Continue on What’s new in Denali and Memory enhancement, come across another great article by SQLCAT and Glenn Berry a new feature of Sql server 2012 in association with windows server 2012 called Memory Error Recovery in SQL Server … Continue reading

Posted in Denali, Memory, Whats New | Tagged , , | Leave a comment

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know at sql everything is on memory, memory information retrieve quickly compare to Disk. So if things are not in … Continue reading

Posted in Memory, Performance Tuning, Troubleshooting | Tagged , , , , | Leave a comment

Denali – Memory: “any size” page allocations

I blog introduction to Memory here. Considering you already know memory concept, till sql server 2008 R2, memory management is divided into two parts: BPool – Single page allocation Mem_to_Leave – Multipage allocation. Single page allocation is a 8k page allocated … Continue reading

Posted in Denali, Memory | Tagged , | Leave a comment

Lock page in memory

When you configure the memory and on your system if other applications are also present, in such cases de-allocation of memory may impact huge performance issue. so lock page memory is useful here as to prevent/reserve the memory for Sql … Continue reading

Posted in Memory, Others, Performance Tuning, What I learned today | Tagged , | Leave a comment

Important: System Objects/Views/DMV/DMF

Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored on catalog views which look like Sys.xxx Eg. Sys.databases Compatibile views: This are views to manage old compatibility Select * … Continue reading

Posted in DMV, General, Index, Memory, Performance Tuning | Tagged , | Leave a comment

Introduction to Memory configuration

Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in sql server. So started working more on it and found very fundamental information everyone should aware of it. Memory management … Continue reading

Posted in Memory, Performance Tuning, Webcast, What I learned today | Tagged , | Leave a comment