Network Management

Limit of in-memory OLTP reached

When the Orion Platform warns you that Memory optimized tables consume a huge amount of memory, upgrade your Azure SQL to a higher tier or disable memory-optimized table.

First published date

6/5/2019 10:00 PM

Last published date

6/21/2021 5:32 PM

Overview

On Database Details, you can see a warning about high utilization of In-memory OLTP next to the In-Memory Utilization record.

You can also find the following message in SQL Server logs or in Orion Logs:

Msg 41823, Level 16, State 171, Line 6 Could not perform the operation because the database has reached its quota for in-memory tables. See 'http://go.microsoft.com/fwlink/?LinkID=623028' for more information.

Relevant only for SolarWinds products with Orion Platform 2019.2 and later using the Azure SQL database.

Product section

Orion Platform

Cause

The In-memory OLTP Storage limit of your the Azure SQL database tier is not sufficient for the Orion Platform.

Resolution

To resolve the issue, use a tier with higher OTLP storage limit or stop using memory-optimized tables.

Option 1: Upgrade your Azure SQL to a tier with higher In-memory OLTP Storage limit.

Learn more:

Resource limits for single databases using the DTU-based purchasing model (© 2019 Microsoft, available at https ://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases, obtained on April 10, 2019)
Azure SQL Database vCore-based purchasing model limits for a single database (© 2019 Microsoft, available at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-vcore-resource-limits-single-databases, obtained on April 10, 2019).

Option 2: Stop using memory-optimized tables

Open C:\Program Files (x86)\SolarWinds\Orion\ConfigurationWizard.exe.config.
Set the following key to false: <add key="TimeSeries_MemoryOptimizedTables_Enabled" value="false"/>.
Run the Configuration wizard. See Run the Orion Configuration wizar.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.