Archives: January 2013
Page Verify = Checksum is one option which I like all my servers to be compliant. By default all the new databases which gets created will have page verify = checksum as this option is inherited from the model database.
NOTE – APPLICABLE FROM SQL2005 AND ABOVE.
SELECT name,page_verify_option_desc FROM…
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the node Process/System counters.
This is one area to look at under DBCC Memorystatus output to get a quick snap shot of the current state of memory and understand if… Read more
Lets start New Year with a very simple yet useful topic.
I am a big fan of out of box reporting capabilities of SSMS. Some of the reports are really useful.
One of the reports which I really like is the Top Jobs report. This one can be pulled by… Read more