Avatar of rwheeler23
rwheeler23
Flag for United States of America asked on

MSSQL with full-text search slow after upgrade.

We are working with one of our vendors whose software stores images for retrieval. They just updated their software and we have noticed that retrieval has gotten very slow to the point the retrieval actually times out. The database is MSSQL and full-text search is turned on. What steps can I try to speed up image retrieval? Should I rebuild and/or reorganize indexes or do something with settings for full-text search? There are about 1,000,000 images and full-text search did not exist in their previous version. This is MS SQL 2019.

Microsoft SQL Server

Avatar of undefined
Last Comment
arnold

8/22/2022 - Mon
Michael Pfister

rwheeler23

ASKER
It is currently rebuilding the indexes. When it is done I will apply CU 13.
ASKER CERTIFIED SOLUTION
arnold

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
rwheeler23

ASKER
The images are not stored in the databases only links to the images. I will check out Ola. I had set up a maintenance schedule using SSMS.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
arnold

Look at using dta
https://docs.microsoft.com/en-us/sql/tools/dta/dta-utility?view=sql-server-ver15

Capture a trace of SQL server queries, then analyze to see what modifications might help improve performance if index rebuild/reorganize does not improve things.

How big are the db's versus memory in the server?
rwheeler23

ASKER
The database involved with the images is 2.5GB. There is an unrelated database that is 50GB. There is 12GB RAM in the server.
arnold

12Gb for cumulative 52.5 gb in Databases, how active if at all is the 50GB db?

Oh, both questions are yours.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.