Hi Brandie,

Thanks for your assistance

The main issue is fixed now as there were missing Indexes, now things are running much better

But just for my knowledge what will be the solution of I/O wait, Latches if SQL DB is having no issues

So let's say after running PerMon or DMV's I have a report now what will be the next step, there is any SQL side things I need to check (DB is optimized already)

OR what are the pointers I need to report to SAN admin?

Let me know if there is a book or step by step guide with a solution of dealing with the I/O Wait etc

Thanks