I'm a huge fan of a lot of the Redgate tools, however at my current workplace they are very paranoid over anything interacting with live servers (in particular affecting performance).
So my question is specifically on their SQL Search tool, what impact does it have on a server? I'm assuming that there will be:
- Initial indexing (what does it interact with, idea on impact on server, can it be customised to not index live servers)
- Subsequent connections/refreshes (how is it determining if there is a change to be re-indexed and what performance/load impact that will have on a server)?