RIL_button( “http://sqlconcept.com/2012/12/24/sql-server-2012-consumes-all-memory-on-startup/”, “SQL Server 2012 consumes all memory on startup” );
I had a strange experience just now.
I noticed that when I started my SQL Server 2012 service, the SQL Serve process would start allocating more and more memory and it would quickly reach the memory limit.
I also noticed that the disk system was quite active,
Continue reading [...] SQL Server 2012 consumes all memory on startup [...]
RIL_button( “http://sqlconcept.com/2011/10/16/sql-server-denali-three-dmvs-sys-dm_server_memory_dumps-sys-dm_server_services-sys-dm_server_registry/”, “SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry” );
I just read a very interesting post by Pinal Dave on 3 new DMVs in Denali.
In his post Pinal is asking the audience to help decipher the purpose of the DMVs. So here is my answer:
There is almost nothing new
Continue reading [...] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry [...]