no none of them in suspect mode

ya thats a good idea and ya i can see table scan, index seek and RID lookups in my execution plans with query costs 77% the max

What I can see on title is Table scan and below that table name and cost is mentioned. Is that what r u asking?

And u want me to run just...

it sucks from day-1 (so something is wrong in design,??)as well as getting even more worst as the time passes

I understand that its hard to say without observing but its too long,calls lot of different Functions

And the default is clustered index on primary key But they have created nonclustered...

YA i ran ur code but i can get a query for blocked spid

i dont see a query for blocking spid. and that's what i want so that i can...

WEll thanks Gail

But

I want to capture blocking_session_id's commands and from where these commands come from?

So after executing your code, I want to modify this...

ya i m looking at snapshot captured at every 2 minutes. we have some kind of template that generates this snapshot.

right now i can see around 50 different spids for same login during whole period of job.

and i can see some other reportng users with different logins and they...

because when my job(with multiple steps ) runs and at same time so many end users are there and they are creating blocking with that job.

i want to...