No jeff ........still working on it.

This is not a pure data ware house. This code is already developed by other team. Currently we are doing optimization. we cant change this logic, because it will affect...

No Gail shaw, it is not like that. we are also doing both the steps.

GilaMonster, That is a very good question. We are doing a kind of data ware housing , here we are creating set of tables for reports.After running this procedure these...

24 Processors,

Max degree of Parallelism : 0

Max server Mem : 2147483647

Any clue?

All of your information are valid, but performance is not improving.

Some times batches take much longer time 🙂

sp_spaceused - information

60656288 - reserved

32717008 - data

27924440 - index_size

14840 - unused

Thanks for all your answers. I will try give more information in coming days.

This is a kind of data warehouse table. we are creating reports after running this procedure. It is doing Index scan too.. There is an auto increment column named...

I found the issue, Some one from onsite has been calling the SP simultaneously.Thanks all for your Great replies...

@dev : I am restricted to post the code...sorry...

No...it is not happening. I ran the procedure 2 times...same error I am getting.

Yes...It is all physical tables. No temporary tables....

Sorry...When I post first ...I got some error...

Thanks to all. It automatically solved...:-)