Hi everybody,
For anyone who has upgraded to v15- have you noticed Tessitura running more slowly post-upgrade? We've seen a small hit in performance when searching for constituents. Not enough to hamper operations, but enough to be noticed. We are self-hosted and have more than minimum specs on all of our servers.
Thanks, all!
Cheers,Kathleen
We're running the standard SQL Server Rebuild Indexes Maint Plan on a weekly basis? I believe this accomplishes the same thing as the UP_REBUILD_ALL_INDEXES Daniel mentions, although they may be slightly different.
Re: indexes, I recommend Ola Hallengren's "SQL Server Index and Statistics Maintenance" for nightly index rebuilds of only the indexes that need it.
https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
Much lower overhead than rebuilding *all* indexes.
Ola's backup script is excellent, as well, imho.
I totally agree.