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