• How can I check the NIC Connections between the server?

    If I copy the backup file on to the local machine , I can restore it successfully. But that now how our jobs are designed. This restoration is one of the steps in the jobs. We have 9 other steps apart from this. We typically cannot change the step because it has dependencies.

    Today i have tried 8 times to restore it through network. It failed 7 times. But I observed that server behaves weird when the restore is in progress. The CPU usage spikes up to 80%, Task manager does not responds and sometime SSMS does not responds.

    Our server horse power is pretty good. 16 processors with default parallelism. 74 GB RAM.

    Can anyone suggest few test scenarios so that I can test in here Like perf monitor or something. This is happening in our PROD so I need to move a little quick here.