database growth

• sql2k8

  Hall of Fame

  Points: 3455

  More actions

  July 16, 2011 at 5:25 pm

  #253783

  Hi,

  i have a table called Table a

  CREATE TABLE [dbo].[TableA](

  [ServerName] [varchar](100) NULL,

  [DatabaseName] [varchar](100) NULL,

  [LogicalFileName] [sysname] NOT NULL,

  [PhysicalFileName] [nvarchar](520) NULL,

  [FileSizeMB] [money] NULL,

  [FreeSpaceMB] [money] NULL,

  [UsedSpaceMB] [money] NULL,

  [FreeSpacePct] [varchar](7) NULL,

  [FileSizeGB] [money] NULL,

  [FreeSpaceGB] [money] NULL,

  [UsedSpaceGB] [money] NULL,

  [Datetobeused] [datetime] NULL,

  [RecoveryMode] [sysname] NOT NULL,

  [Status] [sysname] NOT NULL,

  [Updateability] [sysname] NOT NULL

  ) ON [PRIMARY]

  Can anyone please tell to me how to create the monthly database growth.

  I need tsql script for this.

  Thank You very much

• Paul White

  SSC Guru

  Points: 150467

  More actions

  July 16, 2011 at 11:38 pm

  #1353921

  There are hundreds of scripts out there for things like this. I used Google to find this:

  http://sqlserverteam.blogspot.com/2008/11/monitor-database-growth.html

  There are probably better ones. Have a look around.

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi

• sql2k8

  Hall of Fame

  Points: 3455

  More actions

  July 17, 2011 at 8:27 pm

  #1354032

  Thank You paul white

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 17, 2011 at 8:45 pm

  #1354034

  sql2k8 (7/16/2011)

  ---

  Hi,

  i have a table called Table a

  CREATE TABLE [dbo].[TableA](

  [ServerName] [varchar](100) NULL,

  [DatabaseName] [varchar](100) NULL,

  [LogicalFileName] [sysname] NOT NULL,

  [PhysicalFileName] [nvarchar](520) NULL,

  [FileSizeMB] [money] NULL,

  [FreeSpaceMB] [money] NULL,

  [UsedSpaceMB] [money] NULL,

  [FreeSpacePct] [varchar](7) NULL,

  [FileSizeGB] [money] NULL,

  [FreeSpaceGB] [money] NULL,

  [UsedSpaceGB] [money] NULL,

  [Datetobeused] [datetime] NULL,

  [RecoveryMode] [sysname] NOT NULL,

  [Status] [sysname] NOT NULL,

  [Updateability] [sysname] NOT NULL

  ) ON [PRIMARY]

  Can anyone please tell to me how to create the monthly database growth.

  I need tsql script for this.

  Thank You very much

  You may want to reconsider your Data Types, e.g. FileSizeMB (Money). 🙂

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/