Monitor SharePoint Content Database Growth

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  August 25, 2009 at 7:13 am

  #213739

  According to Microsoft SharePoint best practices for databases I should alter the content databases when they reach 100 GB. Is there a way to setup a alert of some sort to notify me when these databases reach a certain size? I would prefer not to have to manual check everyday. I was thinking of a alert or trigger that would email me through Database Mail when the databases reach 80 or 90 GB.

  Has anyone had to alter their SharePoint Content databases due to size?

  http://www.mssqltips.com/tip.asp?tip=1777

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736494

  More actions

  August 25, 2009 at 7:21 am

  #1044148

  This should give you an idea of how to set an alert

  http://www.databasejournal.com/features/mssql/article.php/1498781/SQL-Server-Agent---Creating-Performance-Condition-Alerts-on-Database-Server-Objects.htm

• Vua Corona

  SSC Journeyman

  Points: 93

  More actions

  August 26, 2009 at 12:40 pm

  #1045086

  Create new alert

  Select type: SQL Server performance condition alert

  Object: SQLServer:Databases

  Counter: Data File Size

  Instance:

  Alert if counter > 100000 (KB)

  good luck.

  vuacorona

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  August 26, 2009 at 12:46 pm

  #1045092

  Thanks.

• rajeshkumawat88

  Grasshopper

  Points: 21

  More actions

  October 9, 2013 at 1:04 am

  #1657004

  Follow the steps mentioned in this post:-

  How to monitor SharePoint Database Size