Question

sql database version

Updated February 23, 2015

asked on February 23, 2015

Hi, we are in the process of updating our servers, currently Laserfiche runs on a 2008 sql database.

We are on RIO and have around 300 active workflows with an average of 4000 instances per day and 4 different repositories. Does installing a more recent sql version like 2012 or 2013 make a noticeable or any performance improvement?

Do you recommend to upgrade based on our laserfiche workload?

Kindly let me know.

Thank you and regards,

Vincenzo Minino.

0 0

Replies

replied on February 23, 2015

I don't know if it would make a noticeable difference in performance, but in the long run it would keep you up to date with SQL Server longer.

0 0

replied on February 23, 2015

Hi Vincenzo,

Do you notice any performance issues? Perhaps just some good ole fashioned performance tuning is required.

There's a number of resources that imply that there are benefits with 2014 but that depends on what benefits are required. Getting the best out of 2014 requires performance tuning knowledge as well, from what I've read.

As far as I know, Laserfiche has been tuned for SQL 2005 and above so required specialist knowledge to improve on.

It's not exactly a No but If I were you, I wouldn't just install and hope for the best. Perhaps you have a test environment and can check?

-Ben

http://www.sqlpassion.at/archive/2014/03/18/performance-improvements-in-sql-server-2014/

http://blogs.technet.com/b/cansql/archive/2014/04/14/sql-server-2014-benefits-of-upgrading-from-sql-server-2005-2008-2008r2-and-2012.aspx

http://www.infoworld.com/article/2610600/database/review--sql-server-2014-pushes-the-pedal-to-the-metal.html

0 0

You are not allowed to follow up in this post.

Question

Question

sql database version

Replies

Sign in to reply to this post.