Sitecore Session management in SQL

Tags

asp.net based cms, Session, session management, Sitecore, sql, web farm, web farms

One of the most common thing we used to do in ASP.Net for Web Farm environment for session management was to setup the Session “OutProc” using either state server or SQL Server.

Sitecore also supports the OutProc Session management using SQL. Sitecore has provided a specific database and internally it is managed as well.

This configuration was done using Sitecore 8.0 (XP) or some people say (xDB)

Please find details below to configure the Sitecore Session in SQL.

Steps to do this

1. Confirm the database named instancenameSitecore_sessions exist.
2. Add a connection string as below
   <add name=”sharedsession” connectionString=”user id=sa;password=*******;Data Source=SQLDatabase\SQLEXPRESS;Database=instancenameSitecore_Sessions”/>
3. In web.config make a change as below
   <sessionState mode=”Custom” cookieless=”false” timeout=”20″ customProvider=”mssql” >

<providers>

<!–<add name=”mongo” type=”Sitecore.SessionProvider.MongoDB.MongoSessionStateProvider, Sitecore.SessionProvider.MongoDB” sessionType=”Standard” connectionStringName=”session” pollingInterval=”2″ compression=”true” />–>

<add name=”mssql” type=”Sitecore.SessionProvider.Sql.SqlSessionStateProvider, Sitecore.SessionProvider.Sql” sessionType=”shared” connectionStringName=”sharedsession” pollingInterval=”2″ compression=”true” />

</providers>

</sessionState>

4. connectionStringName should match the name with the connection string specified.
5. Run the attached SQL file on your database after replacing your database name in Use Statement and one more place below

Attached is the Docx file which contains the SQL Script provided by Sitecore with installation.

You can find the script in the database folder where you have installed the Sitecore.

Sessions db performance boost

Quick comparison between .Net based CMS

Tags

asp.net based cms, kentico, orchard, Sitecore, Umbraco

Hello Friends,

The big question asked to me no. of times.

“Which is the best CMS running on .Net Platform“

While replying on Experts-Exchange website, Recently I came across same question : “Which is the Best CMS running on .Net”

Detail question:

I am looking for some tips on a good cms that i can use for a customer that needs to easy update the site, we can implement a responsive css we got and we need to be able to add custom code for showing products from database and so on.

There were few answers. I replied with a Quick comparison between few CMS I have worked with.

My Answer:

This question has unlimited answers.
We have been working in CMS domain since many years.
We have worked on following in .Net domain

• Sitecore

• Umbraco

• Kentico

• Orchard

All 4 are very good.

• If you want a simple site with easy updates go with Umbraco.
• If you want a site where everything is readily available and you don’t want to work much anything then go for Kentico.
• Looking for Pure MVC based CMS then Orchard.
• If you need to add a lot custom code to display, Flexible, easy for editing for client, Multi Lingual Support then go for Sitecore.

All above mentioned CMS are available in MVC.
Our Experience says, Money spent on Sitecore is worth. Especially when you want to add lots of custom code to read and display.

You can add Responsive Design in any of the mentioned CMS.

The Author was looking for such quick comparison, So he liked the answer and I was rewarded 2000 Points. 500 Points for the Question * 4 (Grade A ) = 2000 Points.

Link for the Question

Some more thoughts on these CMSs.

• Umbraco: A Simple, easy to use, Open Source CMS. Learn using Paid Video subscription. I created 5-6 pages in few hours of starting with Umbraco.
• Kentico: Free and Paid Versions are available. Most of the Web parts are readily available OOB. Lots of settings. Sometime its confusing.
• Orchard: MVC Based. According to news it is supported by Microsoft Employees. Growing fast with more and more people joining the Community. This CMS looks promising. (Still it will take some time to reach to a Mature CMS Level)
• Sitecore: An Enterprise level CMS. One of the leading CMS. Extensible. Great Community Support. Great Product Support. Lots of Flexibility. Very famous for Multi Lingual Support. Also Supports Multi Device, Multi Instance, Multi Site solutions. costliest out of these 4. but still much cheaper than Tridion & SharePoint.

Planning to have a have a detailed review for all 4 CMS.