Manage the SharePoint SQL Environment

SQL availability is equally as critical as the other SharePoint roles.


As a SharePoint administrator, you want to have a clear view of the availability and performance in your SharePoint environment to be sure that your data is available. And, that your data is in SQL…

GSX fills the gap, providing data availability and performance on the SQL environment attached to SharePoint automatically.

Several points are key in the SharePoint environment: The SQL servers, the Content Databases and the Configuration databases.

During the autodiscovery phases, GSX connects to the SharePoint Configuration database to request a list of all Content Databases and SQL servers that manage them.

Once the farm is discovered, GSX continuously tries to access the SharePoint Configuration database and every Content Database to retrieve information about availability, size and document count.

Connections are real and are processed the same way a user would to access the SharePoint Content. This means that GSX monitors the availability of the SharePoint Content from a user’s perspective. When it works for GSX, you can be sure that the SharePoint Configuration Database is safe and every content database is also available to your users.

SPSQLServer

On each Content Database, GSX makes requests to retrieve the number of site collections, the number of documents and the size of each site collection. All of these statistics are displayed in the SharePoint statistic view to give you visibility on growing environments.

SPSQLServerview

As you can see here, GSX reports on the availability of every Content Database in real time, giving you an accurate view of any incident in your SQL environment. Hence, if you have a problem with SQL, GSX alerts you to explain exactly where it occurs  so you can take quick actions to solve it before it impacts your users.

More than just availability of the SQL environment, GSX alerts on the growth of your SQL environment concerning two critical aspects:

  • Site collections with two thresholds: One for the Site Collections size and one for the number of Site Collections documents. For each of them, you can define the scope (all site collections or a limited list).
  • Content Database with three thresholds: Content DB Site Collections Size, Number of Content Database documents and number of Sitecollections inside the Content DB. For each of them you can define the scope (all Content DBs or a limited list).

SPSQLServerrole

 

With these alerts and information, you are sure to never face a huge capacity problem because you know how fast your environment is growing in real time.

Finally, GSX Analyzer provides you with important reporting and trending views to detect any persistent problem within your environment (like Content Databases that have low availability over time or SQL servers that experience problems). The Environmental Health view of GSX Analyzer enables you to compare all your Content Databases regarding multiple statistics, such as availability statistics but also size, number of documents, etc.

SPSQLServerAnalyzer

At a glance, you can see where there are underused resources, where you have to increase the resource, where you have to fix problems, etc.

GSX will also report for each Content Database in real time, historical and forecast trends on the number of sites, the total size and the number of documents. This allows you to compare how they are used and how they are growing.

SPSQLContentDBAnalyzer