I am facing a problem where my content database has grown very large, and whenever I initiate a crawl, the the crawler executes a very complex SQL query on the content database, and this query blocks all other queries that execute on the content DB. As a result, my sites either hang, or become very slow in loading pages.
How do I solve this problem? Can I use mirroring in some way to resolve this issue?
Is it possible to mirror the content DB, and run the crawl exclusively on the mirrored DB so that the sql performance of my front end servers are not affected?