My Tridion Newsletters

SDL Tridion Nominate your MVP Candidate

Sign up and get a newsletter when new Tridion stuff is added to the site

Nominate

SDL Tridion Nominate your MVP Candidate

If you find the content of this page useful, please nominate me for the SDL Tridion MVP award.

Maintaining SDL Tridion Databases

There are a number of database maintentance tasks that can be scheduled by your database administrator to keep your CMS running well.

TCM Queue_Messages Table

Delete queued messages of type 1 (publisher) and type 3(search)

Message type id

  • Publisher
  • Transport
  • Search
  • Workflow

Normally this queue information is short lived but sometimes messages remain in this table that will never be processed.

Many Tridion processes use this table so it must be monitored and maintained to remove these old messages.

Large numbers of messages in this table will slow all processes and cause database deadlocks.

Normally there will be a few thousand messages in this queue.

Stored Procedure to clear this useless data

begin tran 
delete 
from queue_messages 
where queue_id in (1, 3) 
and schedule_time is null 
and processing_consumer_id is null 
commit

 

TMCS Emails Table

Delete “rendered_content” data from emails over 30 days old

Update Statistics

Every 6 hours

Logging databases

Truncate “tridion_cm_log” “EVENTLOG” table every month

Database Backup

Daily Backup of databases

  • Tridion_cm

  • Tridion_cm_log

  • Tridion_cm_email

  • Tridion_Broker

  • Tridion_tracking

Workflow Process Histories

Tridion recommend no more than 1000 items in this list and a daily purge

Old workflow histories

Remove old workflow history

Publish Transactions

Tridion recommend no more than 1000 items in this list and a daily purge

Old publishing queue publish transactions

Remove failed published transactions older than 1 month

 

 

 

More information on Tridion World

Link to Julian Wraith's article on Tridion Database maintenance at https://www.sdltridionworld.com/articles/maintainingsdltridiondatabases.aspx

 


Created: Thursday 27th May 2010 11:17 PM
Last Modified: Monday 28th June 2010 9:55 AM LinkedIn link: View Chris Mills' profile on LinkedIn
Valid XHTML 1.0! Valid CSS! Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0