SQL
Database Optimization: Purging SQL Logs (LDF)
Learn how to optimize your SQL database by purging logs (LDF). Reduce your log file size and enhance your database performance.
EPM
SQL maintenance Query
This article provides essential SQL queries for checking and rebuilding fragmented indexes in your EPM database. Regular maintenance using these queries can enhance database performance and ensure smooth operations. Learn how to implement these steps effectively in your SQL Server environment.
Quest SMA
Optimizing the SMA Database: How to Reduce Its Size
This article outlines steps to optimize the KACE SMA database by reducing its size. It includes important precautions like verifying and backing up the appliance before deleting the history of agents to manage the database limit effectively.