Last post Jun 05, 2019 11:50 AM by PatriceSc
May 30, 2019 07:55 PM|hamed_1983|LINK
I'm using sqlServer mode for sessionSate of my webApp, but performance is very slow! to do this, i found out we can convert 'ASPStateTempSessions' table to in memory optimized table to increase performance. To do this, i found this
link, but it works for sqlServer 2016 whereas i'm looking for 2014.
Can anybody help me ?
thanks in advance
May 31, 2019 02:18 AM|Nan Yu|LINK
The recommended approach is to use use the latest ASP.NET async version of the SQL Session State provider:
ASP.NET Session State with SQL Server In-Memory OLTP
I would suggest try the latest async version of sql session state provider .
May 31, 2019 07:45 AM|hamed_1983|LINK
Thanks for reply
I'm using vs 2015 and does not have 4.6.2 version of .net, the maximum version is 4.6.1.
Also in option2, As i told in my first post, using vs 2016 compatible script, not 2014 which i'm using!
Jun 05, 2019 02:34 AM|Nan Yu|LINK
You probably need to install the 4.6.2 SDK. It includes the reference assemblies for 4.6.2, which is what Visual Studio needs in order to target 4.6.2 for builds.
SDKs for all .NET versions (3.5+) are available from the .NET SDKs for Visual Studio page.
I also not find sql script which compatible with sql server 2014.
Jun 05, 2019 11:50 AM|PatriceSc|LINK
And which problem do you have when trying to run this script ? Note that prior to SQL Server 2016 SP1, you need the Enterprise edition to use the "in memory" feature. (edit: seems the WITH NATIVECOMPILATION option is perhaps not possible in SQL Server 2014
when using memory optilmized tables ????)
I would also install 4.6.2 to have a test app up and running as close as possible to out of the box features. And if I'm forced to stick to 4.6.1 I could then compare to see how to possibly port back that to my 4.6.1 version (apparently they added async support
as well for the session provider) but I guess that upading the old proc might be enough.