size of database containing trace data.

• prsnn_shetty

  Right there with Babe

  Points: 750

  More actions

  January 6, 2009 at 3:48 am

  #97118

  Hi,

  We have collected data in a database through profiler run on diff

  databases.The database has grown to size of 8gb ,whereas i colud

  see only 1gb of data in tables using sp_show_huge_tables.

  Regards

  Prasanna

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  January 6, 2009 at 9:35 am

  #921905

  The rest of the space is probably being used by the database's transaction log.

  Run DBCC SQLPERF (LOGSPACE) to see the space used by all the logs in the instance.

  Greg