MSDB Database is growing (21 GB).

• tapaskumardm

  SSC Eights!

  Points: 812

  More actions

  March 15, 2012 at 8:08 am

  #254767

  The MSDB database is now 21 GB.

  I find sysmail_query_transfer and 'sysmail_mailitems' table is occupying 17 GB and 3 GB respectively.

  Can some body explain what is the use of sysmail_query_transfer table.

  Is there any impact ,if I released this table.

  The table has only 4 rows, but it is occupying 17 GB of space.

  Some body help.

  Thanks in advanced.

• rraja

  Default port

  Points: 1486

  More actions

  March 15, 2012 at 12:18 pm

  #1460081

  Check this thread for same issue.

  http://social.msdn.microsoft.com/Forums/is/sqldatabaseengine/thread/68bd166f-c9b1-4f21-b997-8b44a8cffedb

• GSquared

  SSC Guru

  Points: 260824

  More actions

  March 15, 2012 at 1:52 pm

  #1460154

  That table contains the results of including query data in an e-mail. All it takes is a few big datasets and you'll get a HUGE table.

  There's an article here on archiving DBMail items: http://msdn.microsoft.com/en-us/library/ms189258.aspx

  You can, of course just use sysmail_delete_mailitems_sp (http://msdn.microsoft.com/en-us/library/ms190293.aspx), and that will probably clean up what you need.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon