I recently fixed a problem at one of our clients that had a persistent problem with the DW write actions timing out. After fixing the immediate issues, I wrote a small utility (TableCount.exe) that does a table count on all the tables in a database and reports the number of milliseconds that the operation takes on each.
You can read the rest of the story here, on my myITforum.com blog.
VJD/<><
