SQL Server Performance

SQL Server internal tables

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256b, Aug 27, 2011.

  1. Trev256b Member

    How can I safely remove unwanted data in the following internal tables in msdb? I've noticed these tables are too large and casuing disk space issues. I want to check how data is writing to these tables? I've checked online and nobody seems to know for sure how to remove data from the tables. (I've run the maintenenace plans but these have had no effect.):
    1) queue_messages
    2) sysxmitqueue
    Trev256b, Aug 27, 2011
    #1

  2. Luis Martin Moderator

    "I've noticed these tables are too large and causing disk space issues"
    Who wrote that?
    Luis Martin, Aug 28, 2011
    #2

  3. FrankKalis Moderator

    FrankKalis, Aug 28, 2011
    #3
    preethi likes this.

  4. satya Moderator

    What is the current size of MSDB database in this case?
    Why not move it to the drive where the space is not an issue?
    satya, Aug 31, 2011
    #4

  5. Trev256b Member

    hi guys - i found the answer! database mail was not working so I cleared the database mail queue and purged all mails that hadn't been sent. this cleared the disk space. hope this helps. does this make sense to you?
    Trev256b, Sep 4, 2011
    #5

Share This Page