Data Center Security (DCS) Database Partition Shrink Stored Procedure.
Release : 6.9.0
Follow these instructions:
Examples of how to run the stored procedure....
To TEST Real Events (CSPEVENT table):
EXEC SCSP_ShrinkDbPartitions @eventClass='REALTIME', @dataFileShrinkTargetSizeInMB=50, @shrinkMode='TESTMODE';
To SHRINK Real Events (CSPEVENT table):
EXEC SCSP_ShrinkDbPartitions @eventClass='REALTIME', @dataFileShrinkTargetSizeInMB=50, @shrinkMode='SHRINK';
To SHRINK Profile Events (PROFILE table):
EXEC SCSP_ShrinkDbPartitions @eventClass='PROFILE', @dataFileShrinkTargetSizeInMB=50, @shrinkMode='SHRINK';
To SHRINK Analysis Events (ANALYSIS table):
EXEC SCSP_ShrinkDbPartitions @eventClass='ANALYSIS', @dataFileShrinkTargetSizeInMB=50, @shrinkMode='SHRINK';
Note :- The above stored procedure added in our latest release 6.9.2 and 6.9.3 as enhancement.