Which Altiris Knowledgebase articles are useful in assisting with SQL Server and Notification Server tuning?
The following list provides some of the Best Practices tuning documents for the Altiris Notification Server and Microsoft SQL Server. These documents can also help with common problems such as excess growth of the Altiris databases. Many of these articles are based on observations of customer environments and are provided as reference material.
Altiris recommends each individual administrator compare these recommendations against their existing environment to ensure these suggestions do not negatively impact their current configuration.
SQL Server 2005/2008:
1. Article 49632, "Optimizing SQL Server 2005 on Windows Server 2003"
2. Article 40488, "Creating a maintenance plan in SQL Server 2005 or 2008 to optimize database performance"
3. Article 45425, "Common Performance Monitor counter thresholds"
4. Article 25784, "How can I reorganize or rebuild my Altiris database indexes on a SQL 2005 server for improved performance?"
5. Article 30570, "How can I get a report that shows me the database fragmentation on a SQL 2005 server?"
LDF file growing too large: