Hi,

One thing i want to discuss...I had stopped my both Report servers services on today.

My Data warehouse in SQL server might not have been queried by Report Servers.

What did i do ??

Now i have queried my data warehouse for a complex SQL query.

Super..Super..i have got my results within seconds...

usually it will take more mins to execute..now it is just seconds..

Also i have queried my data warehouse for concurrent queries..there are nothing...

So i have found my real problem is.....,

More SSRS subscriptions have been scheduled at same time(multiple requests)

So when i have concurrent SQL queries,SSRS subs queries,Jobs query running against my data warehouse..it cant handle those requests..

Thatswhy those blocking and late delivery of ssrs subscriptions .

Now i need to find a way to execute concurrent SQL queries against my data warehouse...

Can u help please ?