cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
681
Views
0
Helpful
7
Replies

ICM Side A & Side B issue

happy_248578
Level 1
Level 1

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

7 Replies 7

geoff
Level 10
Level 10

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

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.........

What size hard disk are we talking about on your Logger?

Regards,

Geoff

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?

You would use SQL Server Enterprise Admin in a standard way to add new data space to the SQL database for _sideA which would live on your new drive. Probably add new space for the transaction log also on your new drive.

Regards,

Geoff

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 _hds right click and then click "estimate" this will show the retention settings for all tables in HDS. You can check for the same at the _sideA database.

Joe

Excellent questions, Joe. I hope the original poster comes back and reads your reply and supplies additional information.

Regards,

Geoff

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: