7/31/2019 12:54 PM | |
Joined: 9/9/2015 Last visit: 9/30/2024 Posts: 727 Rating: (278) |
In the SQL, right click the Historian Database, Report-> Standard Report-> -Generate the Disk Usage and disk usage by table report out first Then only you can identify which segment you would like to reduce the size/ delete in proper way. You can use truncate + Shrink function to reduce those unwanted segment. Step 1: Sample for Truncate, (check from disk usage by table report) 1. New Query-> 2. Key in -> • TRUNCATE TABLE ALG.Message_0_100000 • TRUNCATE TABLE ALG.Message_0_100001 • TRUNCATE TABLE ALG.Message_0_100002 3. Execute F5. Step 2: Sample for shrink (Check from disk usage report) 2. Identify the segment and its RTData. For eg as below: • Segment 100000 = PH_AlgRTData_0_7 • Segment 100001 = PH_AlgRTData_0_16 • Segment 100002 = PH_AlgRTData_0_22 3. New Query-> select 'DBCC SHRINKFILE (N''' + LogicalFileGroupName+ ''' , 1225)' from CONFIGURATION.VPartitions where SegmentId between 100000 and 100002 and DataCategoryID = 3 • DBCC SHRINKFILE (N'PH_AlgRTData_0_7' , 1225) • DBCC SHRINKFILE (N'PH_AlgRTData_0_16' , 1225) • DBCC SHRINKFILE (N'PH_AlgRTData_0_22' , 1225) 4. Press F5 to execute. These are samples methods to truncate and shrink Alarm drive. |
Last edited by: JazTai at: 07/31/2019 14:51:22Please give me 5 stars Rating if my post is helpful for you. :) |
|
Follow us on