Hi, I have this problem that the Transaction Log for the Database K2 is growing at an exceptional rate. Once installed and my workflow is uploaded. Within 10 minutes the Log's size has already suppassed the DB's size. And within a few days time, it grows to an astonishing 6GB size while the DB's size is still at a mere 20MB.
Can someone tell me whats wrong here? Does escalation rules that has timing set to minutes affect this?
+7
The K2.net Server service is constantly checking for escalations that should fire, Destination Queue refresh, logging data to K2Log database, etc. Thus there will always be some activity on the K2.net Server even if no new process instances are created.
For example, if the Destination Queue refresh interval is set to 3 mins, and there are multiple Destintation Queues containing OUs or Groups with many members, it could potentially create many transaction log records.
I would suggest that you perform a SQL Trace on the K2 database for a couple of hours, in order to determine what activities are taking place. This should preferably be done when there is little process activity on the system, so that you will trace mainly system activities.
For example, if the Destination Queue refresh interval is set to 3 mins, and there are multiple Destintation Queues containing OUs or Groups with many members, it could potentially create many transaction log records.
I would suggest that you perform a SQL Trace on the K2 database for a couple of hours, in order to determine what activities are taking place. This should preferably be done when there is little process activity on the system, so that you will trace mainly system activities.
+2
Hi
It is a problem which we have because of the number of transactions being processed in SQL server. It makes the log files grow very rapidly. Depending on the importance of the Log data, you can set the recovery model in SQL from Full to simple. It will clear all the transaction logs once it has been completed. The con is that all data will be lost in case of a system crash or failure since the last SQL backup, and not till point of failure. If the log data is important, one can look at a good DB maintenance program where a Full DB backup must be done at least once a week and a transaction log backup every evening and then to truncate and shrink it.
Lenz le Roux
It is a problem which we have because of the number of transactions being processed in SQL server. It makes the log files grow very rapidly. Depending on the importance of the Log data, you can set the recovery model in SQL from Full to simple. It will clear all the transaction logs once it has been completed. The con is that all data will be lost in case of a system crash or failure since the last SQL backup, and not till point of failure. If the log data is important, one can look at a good DB maintenance program where a Full DB backup must be done at least once a week and a transaction log backup every evening and then to truncate and shrink it.
Lenz le Roux
+5
Thanks for sharing! I have solved my problem.
+6
Hi all,
You can see a summary of the content of the Transaction log with the following queries:
SELECT DISTINCT Operation,Context,[AllocUnitName],COUNT(*) AS "Count"
FROM ::fn_dblog(null,null)
WHERE [AllocUnitName] LIKE '%Identity%'
GROUP BY Operation,Context,[AllocUnitName]
ORDER BY 4 DESC
SELECT DISTINCT Operation,Context,COUNT(*) AS "Count"
FROM ::fn_dblog(null,null)
GROUP BY Operation,Context
ORDER BY 3 DESC
Kind regards,
Olivier
--First time of transaction log:
SELECT MIN([Begin Time])
FROM ::fn_dblog(null,null)
SELECT MIN([Begin Time])
FROM ::fn_dblog(null,null)
+1
We recently experienced the same issue of the transaction log growing at an unsustainable rate (900Gb+ in less than 2 days). It turned out that the SQL Server recorded a long running transaction and held locks on the server.kAsync table (found by ‘dbcc opentran’), but the spid for this transaction no longer showed in the sys.sysprocesses view.
Killing the abandoned spid in SQL Server and then executing a checkpoint caused the accumulated transactions in the log to commit and the transaction log could then be shrunk to a normal size.
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.