We're current running a search engine website using SQL Server 2000. There are huge performance problems with the database maxing out on CPU. Our search spider runs about 5-10 insert/update/delete stored precedures per second. The site then uses the same database for searching. This together causes our database to max out. I heard that if we indexed our database, it would not help since it constantly gets written to and the data changes to much. How can we improve the performance of this kind of setup? If we tried replication, wouldnt it just pound the other database with updates as well? The nature of our search results needs to be updated to the minute not to the hour or to the day. What can we do?