You are viewing limited content. For full access, please sign in.

Question

Question

SQL Maintenance - Rebuild Forms DB Indexes with Services running?

Forms Administration Backup and Recovery Presales Installation and Upgrades
Updated July 3
asked on September 10, 2021

Hello LF Answers,
 

I have a customer who is currently heavily using forms and their DBA noticed some significant fragmentation on several of the tables. In the past Laserfiche had recommendations for rebuilding indexes on the repository database but the suggestion also came with a "make sure the services are stopped" caveat. Is this also true for the Forms database? Is this still true at all? First time I heard this was in 2013 and I've just lumped into my migration SOP as it was also only recommended to perform after migration of the repository database. 

 

I look forward to your responses and have a great weekend!

 

Your Pal,

Hunter

 

 

3 0

Replies

replied on September 11, 2021 • Show version history

Hi Hunter,

No need to take Forms fully offline. Schedule the SQL maintenance plan to run some time that's reasonably off-hours to minimize the chance an end users runs into an error from an object being locked at that particular moment.

If you happen to have SQL Server Enterprise Edition, you can do an online rebuild by specifying WITH (ONLINE=ON) to even further reduce the chances of running into a lock.

I can't recommend Ola Hallengren's SQL Server Index and Statistics Maintenance scripts enough. They're much more intelligent than the out-of-the-box index rebuild maintenance plans. Your customer's DBA is likely familiar with them already.

Cheers,
Sam

2 0
replied on September 13, 2021

Thanks so much Samuel! I weirdly have like three customers all asking this same stuff this morning so there must be something in the air. Do you know if the rebuilds with online=on are also okay to use with the repository databases?

0 0
replied on September 13, 2021

Welcome! Funny how that happens, right?

Online rebuilds are fine with repository databases.

0 0
replied on June 27

If you need an introduction to Ola's scripts, here is a video I created that does an overview of the solution.

https://youtu.be/iacDlUsc9UE?si=qAXAdIxezzb_mudW

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...