I have a database backup job that runs on a Windows 2003 Server at 1am every morning. It backs up a database to a folder on a remote Windows 2003 server. It should take approximately 8 minutes to run, but occasionally it takes 10+ hours to run, and then fails.
I'm looking to schedule a network monitoring job/script/app to record the TCP traffic on the database server's NIC to see what's happening (statistical data - bytes Tx/Rx, bytes/sec, IP addresses data sent to, etc) during the first hour of the backup (1am-2am).
As this is all happening at 1am in the morning, I'm looking for a way to automate this job, but I haven't a clue where to start. Has anyone created scripts using Process Explorer, Netstat, TCPView, or similar? If so can you suggest how I could go about this?
NOTE: SNMP is disabled on all of our servers, and I cannot turn this service on (security compliance policy).