Thanks.

I have confirmed this with another SQL resource on site as well.

This was exactly what happened for any who is interested. Connection not being closed correctly by development

Its in house. I have put the question back to the dev team to find out what the application does with the connection.

I am also looking into the possibility of...

Hi Have doen some digging and the dbcc indexdefrag process (spid 60) is being blocked a process (399) which is running a simple select statement from a user table. sp_who2 reports...

The contention seems to alway be on the same query and table. If the query is key to the application which I am assuming that it is then how could...

Thanks and agreed unfortunately I don't have such a window (hence the test to see what the effect of running dbcc indexdefrag is when users are on the system)

It still...