[cisco-voip] CallManager Publisher - Out of Disk Space
Wes Sisk
wsisk at cisco.com
Thu Nov 3 08:48:47 EST 2005
Without backups the transaction log would (and has on several systems)
consume all avalable disk space.
In all ES after 04.0(02a)ES33 04.1(02)ES26 04.1(03)ES01 there is a new SQL
job to monitor available disk space and if it drops below 90% then we
automatically truncate and shrink the transaction logs.
/Wes
-----Original Message-----
From: Carter, Bill [mailto:bcarter at sentinel.com]
Sent: Wednesday, November 02, 2005 11:53 PM
To: Wes Sisk
Cc: Schuett, Court (MBNAP it); Stu Packett; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] CallManager Publisher - Out of Disk Space
You are right, something doesn't sound right. Is there a "cap" on the
database/ldf log files. How large would it grow if there was no backups
running??
----------------------------------------------------------------------------
--
From: Wes Sisk [mailto:wsisk at cisco.com]
Sent: Wednesday, November 02, 2005 10:14 PM
To: Carter, Bill
Cc: Schuett, Court (MBNAP it); Stu Packett; cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] CallManager Publisher - Out of Disk Space
his databases appear relatively 'normal' in size. Here are sizes from
some profiling I did:
Tests completed using CCM 3.2(2c)spF
I added 1000 phones to a system and associated 1000 users.
Without starting CCM and TFTP just the database backup file is 129MB.
My test included 1000 phones with 2 lines and 4 speed dials each,
and a user associated with each phone.
Start CCM and TFTP service to genearte default config files
and the backup jumped up to 200MB for 1000 Users.
10,000 phones&users is ~10 times this size, or 1,280MB. Scale for
a backup starting at 1GB that does not include CDR's or music-on-hold files.
1.5 Million CDR ~ 1,385,002 KB for CDR Database/Wes
Carter, Bill wrote:
Here are the steps for shrinking the SQL databases
From a command prompt
c:\osql -E
1> use CDR
2> go
1> backup log CDR with no_log
2> go
1> dbcc shrinkdatabase(CDR)
2> go
1>exit
You can also do this to the ART database. When backups are run, the
procedures have the same affect.
--------------------------------------------------------------------------
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Schuett, Court
(MBNAP it)
Sent: Tuesday, November 01, 2005 1:02 PM
To: 'Stu Packett'; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] CallManager Publisher - Out of Disk Space
I believe when you back it up, the backup procedure goes through and
compresses all databases. I ran into the same problem you're having one
time and that helped tremendously. Are you running a backup every night?
You can also do it manually. It's under the SQL Enterprise manager, but I
don't remember the exact steps. Should be an article on cisco.com on how to
do it though.
Court Schuett
Network Systems Engineer
Millward Brown
Naperville, IL
630-955-8983
court.schuett at us.millwardbrown.com
--------------------------------------------------------------------------
From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Stu Packett
Sent: Tuesday, November 01, 2005 12:56 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] CallManager Publisher - Out of Disk Space
My CallManager Publisher ran out of disk space. It had less than 1MB
of free space when I took a look at it. I'm having a hard time regaining
more disk space. I've got over 1.6GB now, but it's dropping. It's an MCS
server (forgot what model) with a 14.9GB C: drive partition. My art.mdf
file is 2.9GB and CDR.mdf is 1.5GB. The art_log.ldf is 70MB and CDR_LOG.ldf
is 690MB. What else can I do as I'm frequently getting the 'out of disk
space' warning in my system logs. Thanks in advance.
Here's what I've done so far:
1. Delete all the C:\Program Files\Cisco\Trace files
2. Delete all the IIS log files
3. Delete unncessary files that were previously downloaded.
--------------------------------------------------------------------------
IRS Circular 230 Disclosure: To ensure compliance with requirements
imposed by the IRS, we inform you that any U.S. federal tax advice in this
communication (including attachments) is not intended or written by Fenwick
& West LLP to be used, and cannot be used, for the purpose of (i) avoiding
penalties under the Internal Revenue Code or (ii) promoting, marketing, or
recommending to another party any transaction or matter addressed herein.
--------------------------------------------------------------------------
ATTENTION:
The information contained in this message may be legally privileged
and confidential. It is intended to be read only by the individual or
entity to whom it is addressed or by their designee. If the reader of this
message is not the intended recipient, you are on notice that any
distribution of this message, in any form, is strictly prohibited.
If you have received this message in error, please immediately notify
the sender and/or Fenwick & West LLP by telephone at (650) 988-8500 and
delete or destroy any copy of this message.
====================================================
This email is confidential and intended solely for the use of
the
individual or organization to whom it is addressed. Any opinions
or
advice presented are solely those of the author and do not
necessarily
represent those of the Millward Brown Group of Companies. If
you are
not the intended recipient of this email, you should not copy,
modify,
distribute or take any action in reliance on it. If you have
received
this email in error please notify the sender and delete this
email
from your system. Although this email has been checked for
viruses
and other defects, no responsibility can be accepted for any
loss or
damage arising from its receipt or use.
====================================================
----------------------------------------------------------------------------
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20051103/003d08ef/attachment-0001.html
More information about the cisco-voip
mailing list