• HI,

    You will need to get more detailed information to get any focused answer to the problem you are seeing. If the tool you are using does not have object-level data, then a good tool for that is sqlnexus. Review the documentation at this site (http://sqlnexus.codeplex.com/) , and collect some data and run sqlnexus.exe to view its reports. I have found the Blocking and Wait Statistics Reports extremely useful and it will get you object-level data that you can use to narrow your investigation into the root causes of the issue. If after running this tool, you don't see blocking and locking caused by specific objects then you might look into other toolsets that would allow you to assess your IO subsystem.