hi ,

Thanks for you reply.

As per my earlier investigation,I have done the below,

1)done finding missing indexes

2)tuning of SSRS subscriptions query

3)Optimizing the SQL queries of all stored procedures so that they will take less time to complete

But I shall have to look on IO subsystem from now on......

why my SQL queries are waiting in my data warehouse, irrespective of select,update,delete SQL statements..

My Current Concern:[/b][/u]

What is the best possible way to execute any SQL statements within less time span....??

What kind of change that i should need to do to my IO subsystem??

Should i need to look into my hardware config??