web stats
SqlServer - large transaction log files being created - Mirth Community

Go Back   Mirth Community > Mirth Connect > General Discussion

Reply
 
Thread Tools Display Modes
  #1  
Old 04-11-2011, 09:23 AM
Rahn Rahn is offline
Mirth Newb
 
Join Date: Aug 2010
Posts: 21
Rahn is on a distinguished road
Default SqlServer - large transaction log files being created

We're running into a problem where our Mirth database is growing very rapidly, and using up all the space on our server.

We're getting roughly 100K transactions a day.

As we look at it, it seems to be the transaction log is group much faster than our backup is erasing the committed transactions.
On my channels, I have message pruning set to run once an hour for messages over 5 days old.
I don't keep the filtered messages.

Any suggestions on where to look to see where the transactions are coming from?
Where does Mirth use transactions (Is it on all SQL statements)? (I do have a few database writer destinations.)

My DBA doesn't want me to connect Profiler to a production database, so can't use that to see what's coming across.
Reply With Quote
  #2  
Old 04-11-2011, 09:27 AM
dans dans is offline
Mirth Employee
 
Join Date: Apr 2007
Location: Irvine, CA
Posts: 590
dans is an unknown quantity at this point
Default

I would not run pruning once an hour as you don't want pruning jobs to run constantly. Pruning once a day is probably the best option (when message load is low). Turn on batch pruning if it is not already on.
__________________
Daniel Svanstedt
Software Engineer
Mirth Corporation

Want professional services, support, and enterprise or virtual appliances? It's all available from the Mirth Corporation:
Mirth Support | Mirth Training | Mirth Appliances | Online Training | Developer Q&A

Don't forget, Mirth Support gives you access to all of our online training videos, and silver support gives you access to developer Q&As!
Reply With Quote
  #3  
Old 04-11-2011, 09:45 AM
Rahn Rahn is offline
Mirth Newb
 
Join Date: Aug 2010
Posts: 21
Rahn is on a distinguished road
Default

I had batch pruning, block size=0 on.
I've changed it to Daily, so we'll see how that affects things.
Reply With Quote
Reply

Tags
sql server, transaction log

Thread Tools
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:52 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation