Grant Fritchey (4/5/2013)
Looking at os_wait_stats is looking at waits aggregated. There's no way to know if those waits correspond to problems during your restore. That's why I suggested looking at sys.dm_exec_requests. That shows waits as they are occurring on active processes. That's how you can tell what is running slow when, not just what is running slow overall.
When you say it is aggregated, does it mean aggregated since last service restart?
FOr sys.dm_exec_requests, how can I understand better the result of it?
How that is related with the restore causing the network slow down?
Thanks