• Try SQL Server Profiler, and see what the apps are doing.

    SQL Server Database Administrator