Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (, having IT experience of more than 9 years. Anup is an active blogger with, and can also be found on MSDN SQLServer forums and He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

Archives: January 2013

Leverage Policy Based Management for regular Page Verify =Checksum compliance monitoring

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.


SELECT name,page_verify_option_desc FROM…

Read more

2 comments, 639 reads

Posted in on 17 January 2013

DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts

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

0 comments, 1,792 reads

Posted in on 11 January 2013

SQLAgent Job related reports and out of box real time job monitoring tool !

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

0 comments, 578 reads

Posted in on 8 January 2013