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, even though there was nothing obvious to make it so.
Continue reading […] SQL Server 2012 consumes all memory on startup […]
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 in this case, except for the fact that the information is available through DMVs.
Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]