Auto Draft

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.

I

Continue reading […] SQL Server 2012 consumes all memory on startup […]

 

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.

Interesting.

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.

In the

Continue reading […] SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry […]