Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated the sv-pagetree macro with the following parameter(s): []
Scroll ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
#F0F0F0#F0F0F0

Using SQL Server 2016 and above in the Memory Tables for SummitAI on-premise instances, the performance of the Application can be significantly improved.

Prerequisites for SQL Server in Memory Tables

Memory tables are supported from SQL Server 2016 and above.

Configuring SummitAI Application for Using SQL Server in Memory Table

Generate the in-memory database in SQL server. Refer to Script for generating in memory session database.

Add the following settings to use SQL server in memory tables as session provider. Refer to sample web.config  For SQL server in memory

<sessionState mode="Custom"  customProvider="AzureSessionProvider" allowCustomSqlDatabase="true" sqlConnectionString="Server=tcp:serverIP;Database=AspState;User ID=userId;Password=password;">        

                           <providers>          

                                  <add useInMemoryTable="true" retryInterval="100"  maxRetryNumber="5" name="AzureSessionProvider" type="Azure.Utilities.SqlSessionStateStore, Azure.Utilities" writeExceptionsToEventLog="false" />        

                           </providers>
   
                     </sessionState>

Sample Web.Config

For SQL Server in Memory

Sample SQL Server In memory - Web.config

Script for Generating in Memory Session Database

aspstate_sql2016_with_retry.sql

Scroll ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
1

| |