4

After installing Sitecore 9 update 2, I noticed few changes in ConnectionString.config. One of them is <add name="sessions" connectionString="user id=sa;password=12345;data source=.\SQL2016;database=Sitecore_Sitecore.Sessions" />.

Can someone please explain what is the purpose of this database? I haven't found this database in server after installation. Is it safe to keep as it is now?

3

The xDB stores two kinds of session information - shared and private . You can think of shared session state as the contact store - it has information about the contact, devices used, and engagement plan states. Private session state contains information about interactions - such as goals triggered. When you install Sitecore on a single machine, both types of session data are stored InProc.

In the Sitecore Experience Database, you can use a session state server to share all your contact sessions across different browsers and devices. Configuring out-of-process session state is important if you have deployed an environment with multiple content delivery servers or clusters of content delivery servers.

Tracking the session state of your contacts is important regardless of whether you install a standalone environment or a fully scalable environment. For example, it is possible to track two simultaneous contact sessions from two different devices, such as from a desktop web browser or a mobile phone.

If you decide to deploy a large, fully scalable environment with vertical and horizontal scaling, then session state becomes even more important. For example, in a multi-content delivery cluster environment, you can share contact information between content delivery instances to ensure that contacts stay connected to the particular cluster where their interaction originated.

Here is described how you configure session database:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.