Tham khảo tài liệu 'hướng dẫn học microsoft sql server 2008 part 105', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Part VI Enterprise Data Management DBCCdlln ame FREE Unloads the specified dll from memory DBCC MEMORYSTATUS Provides a snapshot of the current memory status of SQL Server. This command is very useful in troubleshooting issues that relate to SQL Server memory consumption. DBCC USEROPTIONS Returns the active SET options for the current connections The following three DBCC commands are used with trace flags. Trace flags are used temporarily to set certain specific SQL Server characteristics or turn off some behavior. For example trace flag 1204 is used to enabled deadlock reporting to SQL Server ErrorLog. DBCC TRACEON Turns on the specified trace flags DBCC TRACEOFF Turns off the specified trace flags DBCC TRACESTATUS Displays the active trace flags Managing Database Maintenance SQL Server provides a host of database maintenance commands. Fortunately it also provides the DBA with ways to schedule maintenance tasks. Planning database maintenance Database maintenance plans include the following routine tasks Checking database integrity Performing index maintenance Updating database statistics Performing database backups Shrinking the database Checking file sizes and free disk space These maintenance tasks can be automated and scheduled using the SQL Server Agent service. The maintenance tasks are referred to as SQL Server Agent jobs. Maintenance plan There are two ways to create a maintenance plan Maintenance Plan Wizard Used to quickly create a basic maintenance plan this wizard enables you to choose typical predefined maintenance tasks such as performing database backup rebuilding indexes updating statistics checking data integrity and shrinking the database. It does not allow you to add any custom tasks. Maintenance Plan Design Surface Used for designing maintenance plans with more flexibility this option enables you to create a workflow of typical maintenance tasks and custom maintenance tasks using T-SQL scripts. It also allows extended logging which can be very .
