Friday, February 24, 2012

DBCC Daily commands

Can anyone tell me what are the daily DBCC commands they run and if they run it as a job and how you can capture the result of those commands for further analysis. I am switching from a development role to a DBA role and i can never find such a sugestion anywhere online or in books. So more than 1 openion would be greatly appreciated.

Hi,

you can read this article at http://www.sql-server-performance.com/dbcc_commands.asp,to learn more about DBCC commands and how it will help you when you are trying to optimize your SQL Servers.

You can run the DBCC commnads as a job by scheduling DBCC commands by using AT scheduler command.

Best Regards

No comments:

Post a Comment