Surendra Sharma

Surendra Sharma

Search This Blog

Showing posts with label CMS. Show all posts
Showing posts with label CMS. Show all posts

Monday, October 24, 2016

Reference Guide for Sitecore database

Sitecore Database
Sitecore Database


Sitecore database is one of the least explored area in Sitecore world. Even you will not get enough Sitecore database material on its official website. Knowledge of SQL server and its trick can make Sitecore developers life easy.


I started an articles series that covers all possible database operations that leads and architect have to do.

Here I combined all those tricks and mold into an eBook.

Below are the key topics that this eBook covers

  • It’s not all about items, it’s all about data
  • Sitecore Databases
  • Access items and field values from Database
  • Changing data from database
  • Sitecore Database Backup Script
  • Restore database script
  • Creating Sitecore database backup job
  • Sitecore SQL Server database Maintenance Plans
  • Cleanup Sitecore Database Tables
  • SQL server recommended configuration for hosting Sitecore website
  • Page for testing Sitecore Databases performance
  • Page for getting all Sitecore Databases connections

I tried my best to include all the cases that are associated with Sitecore Databases.

You can read and download this reference guide from here:




Please leave your comments or share this reference guide if it’s useful for you.

Thursday, October 20, 2016

Sitecore database lesson 11 - Page for getting all Sitecore Databases connections


Sitecore provides a handy test aspx page to get all connections string that are using by your Sitecore instance. It includes runtime xDB connections as well if you have hosted your xDB data on clouds.

For using this page, copy-paste “xdbStat.aspx” page in “Website” folder.

Access this page from browser like http://sitecorelessons/xdbstat.aspx where sitecorelessons is the name of Sitecore instance.

This page provides 

  • Connection name and complete connection string value

Here is screenshot of this page output

xDB Statistics
xDB Statistics


I hope you like this Sitecore database lesson. Stay tune for more Sitecore database related articles. 

Please leave your comments or share this article if it’s useful for you.

Wednesday, October 19, 2016

Sitecore database lesson 10 - How to test Sitecore Databases performance

Sitecore provides a handy test aspx page to check your database performance. You can download it from here.


You have to unzip it and copy-paste “databasetest.aspx” page in “Website” folder.

Access this page from browser like http://sitecorelessons/databasetest.aspx where sitecorelessons is the name of Sitecore instance.

This page provides 

  • SQL Server information which includes ProductVersion, FileVersion, WindowsVersion, ProcessorCount and PhysicalMemory.
  • Perform action on items 10,000 times and provide useful information like Action name, Min Time, Max Time, Average Time and Boundary Average Time for selected database.
  • Provides index information and allow to rebuild indexes.
Here is screenshot of this page output

Sitecore Database Performance Tool
Sitecore Database Performance Tool


I hope you like this Sitecore database lesson. Stay tune for more Sitecore database related articles. 

Please leave your comments or share this article if it’s useful for you.