The key information in your reply is NHibernate and most probably a misuse of it.

Check your app while a trace is running and check the values needed for functionality vs. queried from database.

If there are columns queried that are not needed for a specific app functionality, it's time to call the vendor in and make them fix their code. If you have a poorly written app, index tuning will provide just minor improvement...