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

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.

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

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.