Auto Draft

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 [...]

December 24th, 2012 | Category: SQL Server 2012, SQL Server Architecture, SQL Services | Comments are closed
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

Development paths and other demons

RIL_button( “http://sqlconcept.com/2012/10/13/development-paths-and-other-demons/”, “Development paths and other demons” );

A common trend nowadays is to follow a specific development path, especially if your survival depends on it.

This can be applied in any aspect: personal, work related, professional, communal etc.

And why would it be different? For us as humans, having a goal seems to be the usual cure

Continue reading [...] Development paths and other demons [...]

October 13th, 2012 | Category: Ramblings, Some thoughts, SQL Server Limitations, SQL Server metadata, SQL Services | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

SQL SERVER – Denali – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

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.

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

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

October 16th, 2011 | Category: Ramblings, SQL Server Limitations, SQL Services, T-SQL | 2 comments - (Comments are closed)
Work on itWell, now...OKGoodGood job! (4 votes, average: 4.25 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

 
  Older Entries »