Our team has gotten a request from our support organization and SQL server configuration for the Endpoint Management suite of the products (primarily Altiris CMS, SMS, and Asset Management). Please take a few minutes to check out an external page dedicated to the best practices around implementing and optimizing 2005 and 2008 SQL Server.
SQL Server 2005 and 2008 Implementation Best Practices and Optimization
http://www.symantec.com/docs/HOWTO10723
I know our company asked Altiris for years if our SQL configuration was correct. Never could get any real guidance out of them.
Your SQL performance is a significant portion of the overall performance of the solution, and the lack of guidance was troubling and caused a lot of heartache and a lot of hours of implementation time lost.