Network Management
Unable to Shrink Transaction Logs Due to In-Memory-Optimized Table Found
This article will show how to resolve an issue of unable to shrink the Transaction Logs.
First published date
6/18/2020 1:02 AM
Last published date
6/18/2020 1:02 AM
Overview
The In-Memory feature disallows the normal shrink.
Product section
Network Performance Monitor
Cause
- In-Memory-Optimized Table Found
Resolution
1. Log on to the Orion Platform server as an administrator.
2. Navigate to the installation folder:
Default: C:\Program Files (x86)\SolarWinds\Orion\
3. Open the file ConfigurationWizard.exe.config in a text editor.
4. Change Key from true to false.
<add key="TimeSeries_MemoryOptimizedTables_Enabled" value="false"/>
5. Save and close the file.
6. Open up Database Manager.
7. Add default server.
8. Right-click the Orion database and select New Query.
9. Execute the following queries:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
UPDATE dbm_TimeSerieProcessingConfig
SET IsInMemoryTable=0, IsClusteredColumnstore=0
WHERE TableType='cur'
10. Run the Orion Configuration wizard and make sure it completes without any error
11. Try to shrink the Transaction Logs
2. Navigate to the installation folder:
Default: C:\Program Files (x86)\SolarWinds\Orion\
3. Open the file ConfigurationWizard.exe.config in a text editor.
4. Change Key from true to false.
<add key="TimeSeries_MemoryOptimizedTables_Enabled" value="false"/>
5. Save and close the file.
6. Open up Database Manager.
7. Add default server.
8. Right-click the Orion database and select New Query.
9. Execute the following queries:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.
UPDATE dbm_TimeSerieProcessingConfig
SET IsInMemoryTable=0, IsClusteredColumnstore=0
WHERE TableType='cur'
10. Run the Orion Configuration wizard and make sure it completes without any error
11. Try to shrink the Transaction Logs