I have a SQL Server 2008R2 OLTP database which is experiencing performance issues during work hours. I would like to run Database Engine Tuning Advisor on this instance but I don't know how it will impact the instance itself.
When can I use this tool and are there any risks involved (Is it possible to overload the DB or significantly impact the environment)?
EDIT: I have identified a few issues with the environment and came up with a few ideas to test.
I would like to further the question here: If it is generally unadvisable to use DETA in production, when can and should it be used? Microsoft created this tool for a reason. If it may help DBAs and developers, how, when and why should we use it?