Question

Adding new template filed kills SQL

Laserfiche Administration

Updated August 4, 2015

asked on July 3, 2015

We have around 14 million records in a repository.

When we try to add a new field in the template, assigned to all documents in repository, it hits the SQL server very badly and sql transactional records gets doubled. Though this does add the field at the end, but it just kills the LF system. In the result we have to clear the transactional logs and provide more disk space.

What would be the solution for this.

0 0

Replies

replied on July 27, 2015

Hi Uzair,

There are some troubleshooting steps you can take. I recommend looking at the Event Viewer on both the SQL Server and the Laserfiche Server, specifically taking a look at the Application (that's where Laserfiche events will be reported) and System logs:

Those should shed more light on the issue.

I also suggest looking at the SQL error logs. If it's a performance issue on the SQL Server side, those logs will be a good place to start.

1 0

replied on August 4, 2015

Thanks for the reply Tania.

I belive we have done all this torubleshooting already but I will try this again and will let you know as what we see under Event Viewer.

0 0

replied on July 28, 2015

Hi Uzair,

I'm not a SQL expert but I've seen issues like this when the logging level is set incorrectly in SQL. If you are having transactional issues with SQL (we had a similar problem where it was filling the transaction logs) then you can change the recovery model in SQL. Please see this article:- https://msdn.microsoft.com/en-us/library/ms189275.aspx

Hope this helps!

1 0

replied on August 4, 2015

Thanks for the suggestion Chris.

I will give this a try and will let you know how it goes.

0 0

You are not allowed to follow up in this post.

Question

Question

Adding new template filed kills SQL

Replies

Sign in to reply to this post.