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

Question

Question

SQL Performance Tuning

Laserfiche How To
Updated 3 hours ago
asked 6 hours ago

Hi All,

 

As we all know, Laserfiche relies heavily/almost wholly on SQL server in terms of system performance. And I'm looking for advice on how to make the most of this situation.

 

I appreciate that performance tuning your SQL stack firmly lies in the Microsoft camp, however is there anything anyone/Laserfiche can share as a general tips & tricks guide on how to get the best out of your SQL environment and things to look out for etc.

 

There is a plethora of videos available on YouTube and various sites, but it would be great to have something which has the vendor seal of approval. 

 

Cheers!

Chris

0 0

Replies

replied 5 hours ago • Show version history

As you mentioned, Laserfiche recommends running scheduled maintenance plans against your various Laserfiche SQL databases. Their go-to recommendation is usually Ola Hallengren’s SQL Server Maintenance Solution, which is extremely popular in the SQL world. I created a video about a year ago that walks through how to implement it—you can check it out on YouTube here: https://youtu.be/iacDlUsc9UE?si=4CleeTLnno0LR4pI.

4 0
replied 3 hours ago

Thanks Blake, yes I'd already checked this out and the Ola Hallengren's SQL server maintenance solution (Option B specifically) is always a good shout. https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html & https://ola.hallengren.com/frequently-asked-questions.html. 

 

However I'm looking for any advice beyond this. E.G. Best collation method, or any other tips and tricks available. Best layout for disk optimisation, expected fragmentation of tables. Best setting for max degree of parallelism etc. There are many variables here, and simply executing a maintenance plan is only one piece of a very big jigsaw.

 

As we all know, SQL is a dark art and specialist DBA's make A LOT of money making them perform well. Appreciate there is some industry secrets here that people might not be willing to share, but what I'm looking for here is some vendor backed 'general guidance' on how to best configure your SQL stack to get the most out of the hardware it's running on.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...