Hello,
I am looking for some documentation on how to best optimize MSSQL for LF use.
I want to know particular ways that will improve the SQL performance for LF.
Thank you,
Tony
Hi Tony,
There's a good presentation on the Laserfiche support site:
Although it's a presentation with few notes, the slides are well written and should give you lots of useful tid-bits. It covers everything from SQL Server versions through to index tuning.
One thing I would add is to remember to limit the memory available to SQL Server. In a default installation, if it can gobble up every megabyte of RAM, it will and this will be to the detriment of the host OS; which is even worse if you're running SQL and Laserfiche service on the same server. I'd give SQL as much memory as you can without choking the OS or other application on the server.
-Ben
Ben's spot on with his suggestion. The presentation he linked is the one from 2013; we updated the course for the most recent Empower conference. It can be downloaded here. I tried to keep notes on the slides, but there may be some gaps here and there. If nothing else, they provide lots of supplemental reading.
A good portion of the presentation talks about monitoring the performance of your DBMS and finding the bottlenecks that are dragging you down (or will be in the future). Keeping a record of performance data will let you look for trends and bottlenecks, and help identify where your problems are coming from. It sounds like your database performance is under expectations, so this section will be especially relevant.