03-30-2009 12:13 AM - edited 03-14-2019 03:52 AM
Hi,
We have ICM 7.0 with Side A and Side B.Now system Hard Disk Space is showing very low.Even HDS database is also showing 90%.We are planning to add one more HDD.Can anyone help us how we can proceed further.
Thanks
03-30-2009 07:36 AM
Check SQL. Check the size of the transaction logs for the logger DB, side A and side B, and the HDS and AW DBs.
There are standard SQL operations to flush out uncommitted transactions and these will reduce the size used.
Regards,
Geoff
03-30-2009 09:09 AM
Correct Automatic Data Purging is also happening but problem is our ICM SIDE A(Active Server) Disk are running with short of space.Even we changed the DB path also now that is also full.We checked with Cisco also they suggested to upgrade the HDD.........
03-30-2009 10:26 AM
What size hard disk are we talking about on your Logger?
Regards,
Geoff
03-30-2009 09:06 PM
Currently 80 GB Hard Disk is running which we created two partition C & D.First Logger was pointed to C when C drive space full after that we pointed to D drive. Now D drive is also running with Short of Space.
So now we are planning to add one more Hard Disk but we are not aware we need to move all DB or only we can point Logger to new HDD?
03-30-2009 10:28 PM
You would use SQL Server Enterprise Admin in a standard way to add new data space to the SQL database for
Regards,
Geoff
03-31-2009 08:39 AM
You also mention that the HDS is auto purging due to capacity at 90%. Do you have plans to increase the HDS data files to correct this issue? What drive is the HDS data and log files currently on, C:, D:, etc... Eventually you will have degradation when running Webview reports if this is not corrected.
What are the settings of table retention on both the loggers and the HDS? Open ICMDBA (both logger and HDS) drill down to the database
Joe
03-31-2009 12:09 PM
Excellent questions, Joe. I hope the original poster comes back and reads your reply and supplies additional information.
Regards,
Geoff
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide