Monitoring FTP impact of DB compiling performance

  • Our current setup is configured where local data servers are used to directly FTP the respective databases housed on that server to production servers. What I want to investigate is the processing impact of FTP'ing on the server while databases are running (and vice-versa) - as there may need to be a business case put forward to alter the current arrangement. While I have seen, VBS scripts to track CPU load, I want to have an understanding of all factors - CPU load, RAM and upload bandwidth? Are there any standardised rules-of-thumb on how to monitor these? Presuambly, I'll need to monitor all factors twice, once sans FTP, then a DB run while FTP'ing?

    Thanks.

    Rob

  • Hi I have kind of same issue going. First have to do FTP done,. And second what is the performance impact on the server while doing this FTP when DB's are in online.

    Right now I am facing issues with http://FTP.. If someone know please guide me.

    Hi robertprice45 If you have the process to do FTP, Please walk me through.

    Thanks in advance.

  • The VBS code for tracking CPU performance of all running processes is here: http://www.databasejournal.com/features/mssql/article.php/3560366/Monitor-CPU-Usage-of-All-Running-Processes--Part-I.htm

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply