Deployment Solution

I have DS 6.9 SP3 installed on Server 2008 R2 with the Database installed locally with a full installation of SQL 2008.

The server has been running for a couple months with only a few issues. lately we have started having issues with jobs\tasks taking 5 minutes to start after being started on a computer. There is daily maintenance being ran on the database but we still experience slowness. The database has been upgraded through every version of Deployment Server starting in v5.x.

Does anyone have any recommended cleanup scripts that should be ran on the database? We are managing almost 4000 devices using 1 deployment server.

How do you know it's the database?

This KB links to several performance-related articles.
https://kb.altiris.com/article.asp?article=38917&p=1

Have you read Article 45425, "Common Performance Monitor Counter thresholds" and Article 40488, "Creating a maintenance plan in SQL Server 2005 or 2008 to optimize database performance"?  You will want to set up performance monitors to help you to determine if there really is a performance bottleneck, including possible SQL bottlenecks.

We found that the SQL server was the bottleneck in our install.  We have a separate SQL server and DS server.  We use active-active clustering for our SQL nodes.  Once we moved the DS SQL database to its own instance (with some other, much smaller, less intense databases), the problems went away immediately.  I would suggest seeing what other items are running on your SQL server if you have a separate one, too.  If your SQL and DS server are the same, consider moving the SQL database to its own server...although DS iteself doesn't seem to be that intense of a program.