dbo.DTA.Tuninglog table

Can the records in this table be deleted? Currently the size of this table
is over 460 MB and I would like to clear it, but I am not sure what it is
used for (used by the database tuning engine I would guess).
Thanks.Hi Tim.
This table is used for DTA's tuning log. You can TRUNCATE the table if you
want to free up space and you no longer care about its contents.
The following Books Online Link contains information on the tuning log:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8edc95f8-581f-4391-9fe9-5ae8d03f9193.htm
Also, the DTA command-line utility allows you to store the tuning log on a
different table of your choice:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/a0b210ce-9b58-4709-80cb-9363b68a1f5a.htm
Regards,
Leo
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O4rYjKx9GHA.2408@.TK2MSFTNGP05.phx.gbl...
> Can the records in this table be deleted? Currently the size of this
> table is over 460 MB and I would like to clear it, but I am not sure what
> it is used for (used by the database tuning engine I would guess).
> Thanks.
>