An in-depth look at SQL Server Memory–Part 1

re: An in-depth look at SQL Server Memory–Part 1

HarshDeep_Singh — Sun, 21 Apr 2013 15:25:38 GMT

Hi Vijay,

Many thanks for appreciating the effort. Glad to know you found it useful.

Regards,

Harsh

re: An in-depth look at SQL Server Memory–Part 1

Vijay Kondapally — Sun, 21 Apr 2013 13:40:22 GMT

Awesome!! So many questions answered in a cogent manner. The visual representation of the memory allocation/usage is very useful.

re: An in-depth look at SQL Server Memory–Part 1

HarshDeep_Singh — Wed, 13 Feb 2013 14:50:39 GMT

Hi Lonny,

Thanks for appreciating. Can you please elaborate on what you mean by "disfavouring" ? I will be more than happy to research and get back to you on this, as long as I know what you're looking for.

Regards,

Harsh

re: An in-depth look at SQL Server Memory–Part 1

Lonny Niederstadt — Wed, 13 Feb 2013 08:47:01 GMT

Great article! One aspect of SQL Server memory management which I've found very scant information on is disfavoring of database pages in the buffer pool. For dbcc checkdb to disfavor its pages seems fairly straightforward, but for scans consuming more than 10% of the database cache, this doesn't seem very straightforward. For example, does the decision to disfavor happen before the first reads for the scan? Or are pages 'retro-disfavored' after the 10% threshold is reached? It seems that the 10% threshold is probably of the database cache for the NUMA node local to the scan itself - is that correct?

Thanks!

re: An in-depth look at SQL Server Memory–Part 1

Nivedita — Mon, 17 Dec 2012 08:16:58 GMT

Excellent work Harsh!!! Am sure this will help many folks who work with SQL Server, it covers quite a lot of information to be picked up...!!! Cheers...!!