Video Screencast Help

Symantec_CMDB Reccomendations.

Created: 26 Jul 2012 | 1 comment

Hello.

I have attached a picture of our cmdb, is this normal? at the moment we have about 260 managed clients and about 900 unmanaged devices.

On the attached screenshot our database size is 44119.44mb

Also auto shrink is set to false.

I have attached a few screenshots of my configuration. Is this looking ok?

Thanks.

Comments 1 CommentJump to latest comment

mclemson's picture

That's a large database for 1,000 devices.  I would have expected <10GB.  Settings look normal -- Auto Shrink is correct.  (Notice your database is 44GB, of which 40GB is used; if it shrinks to 40GB, it will then be full, and will have to auto grow -- at which point it will grow at the recommended value of 10%, putting you right back at 44GB.)

It could be that a table is very large.  The two I know to check are ItemVersionData and CollectionMembershipChanges.  Check out these KBs to see if it applies in your environment:

http://www.symantec.com/docs/TECH46681
http://www.symantec.com/docs/TECH178884

Check table space using these commands in SQL:

exec sp_spaceused 'CollectionMembershipChanges' (or exec sp_spaceused 'ItemVersionData')

If those tables are fine, you might want to check all tables using this query:

 

declare @RowCount int, @tablename varchar(100)
declare @Tables table (
PK int IDENTITY(1,1),
tablename varchar(100),
processed bit
)
INSERT into @Tables (tablename)
SELECT TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE' and TABLE_NAME not like 'dt%' order by TABLE_NAME asc
declare @Space table (
name varchar(100), rows nvarchar(100), reserved varchar(100), data varchar(100), index_size varchar(100), unused varchar(100)
)
select top 1 @tablename = tablename from @Tables where processed is null
SET @RowCount = 1
WHILE (@RowCount <> 0)
BEGIN
insert into @Space exec sp_spaceused @tablename
update @Tables set processed = 1 where tablename = @tablename
select top 1 @tablename = tablename from @Tables where processed is null
SET @RowCount = @@RowCount
END
update @Space set data = replace(data, 'KB', '')
update @Space set data = convert(decimal(8,2), data)/1000
update @Space set data = data + 'MB'
update @Space set reserved = replace(reserved, 'KB', '')
update @Space set reserved = convert(decimal(8,2), reserved)/1000
update @Space set reserved = reserved + 'MB'
select * from @Space order by convert(decimal(8,2), replace(data, 'MB', '')) desc

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com