Fastest and slowest growing Database

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  February 23, 2011 at 11:55 pm

  #97652

  Hi Friends,

  Can any one share the script for how to creating report fastest and slowest growing database?

  Database growth is depending on data storing on daily basis during DML SQL statement.

  Please provide the script for data growth amount on daily basis.

  Thanks in advance

  ananda

• Marco V

  SSCrazy

  Points: 2939

  More actions

  February 24, 2011 at 2:42 am

  #1290798

  we run a SP every morning which populates a table with all databases and their sizes so you can see the growth over a long time

  http://searchsqlserver.techtarget.com/tip/Check-SQL-Server-database-and-log-file-size-with-this-stored-procedure