Enabling & starting Dedup

To Enable dedup on a volume: sis on path

where path is the complete path to the FlexVol volume, ie. /vol/vol1.

To start dedup operations: sis start [-s] [-f] [-d] [-sp] /vol/volname

• The —s option scans the volume completely and you are prompted to confirm if deduplication should be started on the volume.
• The —f option starts deduplication on the volume without any prompts.
• The —d option starts a new deduplication operation after deleting the existing checkpoint information.
• The p option initiates a deduplication operation using the previous checkpoint regardless of how old the checkpoint is. Note: This option should be used along with -s only. This is applicable if checkpoint data is corresponding with the gathering stage.

Creating a dedup schedule

Command: sis config -s schedule path

schedule lists the days and hours of the day that deduplication runs. The schedule can be of the following forms:

• day_list[@hour_list] - If hour_list is not specified, deduplication runs in at midnight on the morning of each scheduled day.
• hour_list[@day_list] - If day_list is not specified, deduplication runs every day at the specified hours.
• A hyphen (-) disables deduplication operations for the specified FlexVol volume.
• auto - Deduplication runs automatically when the number of blocks added or changed since the last deduplication operation (performed either manually or automatically) exceeds approximately 20 percent of the total number of blocks that deduplication has already processed.

path is the complete path to the FlexVol volume.

Example
The following command starts deduplication operations at 11 p.m., Monday through Friday.

• sis config -s mon-fri@23 /vol/vol1

How to give access to SQL 2005 Activity Monitor

To view the Activity Monitor the user needs VIEW SERVER STATE permission on a SQL Server 2005 server.

Permission to KILL a process default to the members of the sysadmin and processadmin fixed database roles, and are not transferable.

References: http://msdn.microsoft.com/en-us/library/ms175518(SQL.90,printer).aspx