Max number of documents / performance
- From: "William F. Kinsley" <bacardi@xxxxxxxxxxxxxx>
- Date: Sat, 6 Jan 2007 11:12:50 -0500
I have a large database that support 1,500+ concurrent users running an intense DB aplication. It currently supports scanning on documents(Using OCR) and images as LOB in the DB. These table are configured for their own filegroup so they can be on a different array then the relational data. There are over a million scanned documents and about 3,000 - 5,000 are added daily.
I now need to add the ability to perform fulltext searchs on these documents and perforamce is a major requirement. (most of the servers are high end 8 way 20-30 gigs of memory, fiber SANS, etc)
Some of my servers are running SQL2000, and a few new ones are running SQL2005. Now I am aware that SQL2005 allows for adding the new documents to the index without a complete index rebuild, but I must support both. One of my issues is that the servers are used almost 24x7.
My question is:
1) Should the documents and fultext index service be moved to their own server?
2) What is a realistic number of documents that can be indexed per server?
3) What are my performance options? Thrid party tools?
4) How can index the new documents on a SQL2000 server without doing a complete rebuild of the index?
Thank you,
Bill
.
- Follow-Ups:
- Re: Max number of documents / performance
- From: Hilary Cotter
- Re: Max number of documents / performance
- From: Simon Sabin
- Re: Max number of documents / performance
- Prev by Date: Re: Problem with COINTAINS
- Next by Date: Re: Max number of documents / performance
- Previous by thread: Re: Index Population Schedule has no Tasks
- Next by thread: Re: Max number of documents / performance
- Index(es):
Relevant Pages
|
