topic Heavy load of SQL Database in Server Management - Systems Insight Manager https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556499#M12262 Hi there,<BR />I installed the actual HP Insight Manager a few weeks ago. Only 2 Discovery runs has taken place. But the DB on our MS Exchange consists of aprox. 23 GB of data. Can I clear the DB in any way? Or is it possible to reduce the amount of collected data?<BR /><BR />Thanks,<BR /><BR />Mark Thu, 02 Jun 2005 06:28:04 GMT Mark Güthling 2005-06-02T06:28:04Z Heavy load of SQL Database https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556499#M12262 Hi there,<BR />I installed the actual HP Insight Manager a few weeks ago. Only 2 Discovery runs has taken place. But the DB on our MS Exchange consists of aprox. 23 GB of data. Can I clear the DB in any way? Or is it possible to reduce the amount of collected data?<BR /><BR />Thanks,<BR /><BR />Mark Thu, 02 Jun 2005 06:28:04 GMT https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556499#M12262 Mark Güthling 2005-06-02T06:28:04Z Re: Heavy load of SQL Database https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556500#M12263 Did you mean to ask about the Exchange Database or the Insight Database and Transaction Logs?<BR /><BR />- Jim Tue, 07 Jun 2005 12:18:22 GMT https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556500#M12263 jim goodman 2005-06-07T12:18:22Z Re: Heavy load of SQL Database https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556501#M12264 I talk about the insight DB on our SQL Server.<BR /><BR />Mark Wed, 08 Jun 2005 01:06:06 GMT https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556501#M12264 Mark Güthling 2005-06-08T01:06:06Z Re: Heavy load of SQL Database https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556502#M12265 Some folks are changing the recovery mode to simple and checking Auto Shrink. Then perform a backup and the file should shrink considerably. I haven't done it yet but many folks here have stated this has worked for them.<BR /><BR />- Jim Wed, 08 Jun 2005 12:54:36 GMT https://community.hpe.com/t5/server-management-systems/heavy-load-of-sql-database/m-p/3556502#M12265 jim goodman 2005-06-08T12:54:36Z