BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-25-2007, 12:25 PM   #1 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default SQL Transaction Log ..... issues?

Please Login to Remove!

After months and months and months of no issues with our SQL (2000) transaction log, today it's growing and growing and growing (not the actual database, just the transaction log).

This BES environment is v4.0.6, Exchange 2003 SP2, and currently has 488 users on it.

The original size of the transaction log was set to 100M (too small, I know, BUT has been like this for over a year...plus I think the DBA's had it set to automatically grow or something if necessary). A DBA I am not.

The application log on the BES starting throwing all kinds of errors this morning, including:

"The log file for database 'BESMgmt' is full. Back up the transaction log for the database to free up some log space."

I talked with the DBA's and they doubled the size to 200M...which was fine for about 10 minutes, but then it filled up again. They then set it to 1G (refusing to set it to unlimited), and I rebooted the BES. However, the transaction log has continued to grow and is now over 500M (again, the actual database size is not growing).

This started sometime this weekend, since the above errors were not present in the application log on Friday (I had a single user sync issue I was investigating, so was looking at the app log). We have not done any patching to the BES, and the only utility that has been run was handheldcleanup, run late last night, to resolve a problem with adding a user who had been moved from another Exchange/BES environment to this one.

I have already contacted RIM and sent them the Application Log, and they said they did not find any issues with the BES....

Any insight would be greatly appreciated. Happy darn Monday!
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-25-2007, 01:36 PM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

1 - I believe 100MB is the default size set for a SQL transaction log in MSDE.
2 - This should be set to unlimited growth.

As for your issue, not really sure...
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 06-25-2007, 01:40 PM   #3 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

Yea, I think the size was never changed after we moved the DB from MSDE to SQL....well over a year ago. Which is why I don't understand why everything is going to hades NOW....why not earlier??

The Transaction Log is now at 700M and growing.... so yet another call to RIM... gotta love T-Support!
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-25-2007, 03:24 PM   #4 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

Talked to RIM and they said the server is most likely playing 'catch up' since the log ran out of space (I think very, very early this morning).

I also found out that the SQL server ran out of disk space on Saturday, so I'm sure THAT didn't help at all. It was fixed within an hour, and I never noticed any disruption in service (continued to receive emails all weekend).

Can anyone tell me what the 'normal' size transaction log would be for around 500 users?

I'm still baffled why we never had issued before this while the log size was set to 100M.....quite puzzling.
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-25-2007, 04:23 PM   #5 (permalink)
CrackBerry Addict
 
ladydi's Avatar
 
Join Date: Jun 2005
Location: Washington
Model: 8800
Carrier: T-mobile
Posts: 848
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I wish I could help. My log is 25MB with a 50MB limit for my 21 users. What does the transaction log record? (I am an sql dunce, so I apologize if this is a dumb question)
__________________
~Di~
Windows 2003
Exchange 2003
BES 4.1
Offline  
Old 06-25-2007, 05:13 PM   #6 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

I wouldn't think it should be any more than 20-30MB, at the most. I think 15-20MB per 500 users is about average (in BES 4.0.x, that is).
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 06-25-2007, 07:23 PM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: Jun 2005
Model: 7100i
Carrier: Rogers
Posts: 73
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by juwaack68 View Post
After months and months and months of no issues with our SQL (2000) transaction log, today it's growing and growing and growing (not the actual database, just the transaction log).

This BES environment is v4.0.6, Exchange 2003 SP2, and currently has 488 users on it.

The original size of the transaction log was set to 100M (too small, I know, BUT has been like this for over a year...plus I think the DBA's had it set to automatically grow or something if necessary). A DBA I am not.

The application log on the BES starting throwing all kinds of errors this morning, including:

"The log file for database 'BESMgmt' is full. Back up the transaction log for the database to free up some log space."

I talked with the DBA's and they doubled the size to 200M...which was fine for about 10 minutes, but then it filled up again. They then set it to 1G (refusing to set it to unlimited), and I rebooted the BES. However, the transaction log has continued to grow and is now over 500M (again, the actual database size is not growing).

This started sometime this weekend, since the above errors were not present in the application log on Friday (I had a single user sync issue I was investigating, so was looking at the app log). We have not done any patching to the BES, and the only utility that has been run was handheldcleanup, run late last night, to resolve a problem with adding a user who had been moved from another Exchange/BES environment to this one.

I have already contacted RIM and sent them the Application Log, and they said they did not find any issues with the BES....

Any insight would be greatly appreciated. Happy darn Monday!
Chances are the recovery model is set to Full. The default for BESMgmt is Simple. This can be changed via SQL Enterprise Manager or via T-SQL

ALTER DATABASE BESMgmt SET RECOVERY Simple
GO

You will want to backup your database before making any changes.

Hope this helps.
Offline  
Old 06-25-2007, 08:38 PM   #8 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

Thanks, Jibi and BB_God, I'll pass along the info to my DBA's.
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-28-2007, 12:10 AM   #9 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

and for a bit of a delayed response here ... Has the MDF / database size grown at all?
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.