<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Programming
»
Testing
»
Monitoring FTP impact of DB compiling...
Monitoring FTP impact of DB compiling performance
Rate Topic
Display Mode
Topic Options
Author
Message
robertprice45
robertprice45
Posted Thursday, February 24, 2011 7:02 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 9:51 AM
Points: 5,
Visits: 78
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
Post #1068913
bvsc
bvsc
Posted Thursday, February 24, 2011 8:27 AM
SSC Veteran
Group: General Forum Members
Last Login: Thursday, January 24, 2013 10:58 AM
Points: 289,
Visits: 223
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 FTP.. If someone know please guide me.
Hi robertprice45 If you have the process to do FTP, Please walk me through.
Thanks in advance.
Post #1068999
robertprice45
robertprice45
Posted Thursday, February 24, 2011 10:45 AM
Forum Newbie
Group: General Forum Members
Last Login: 2 days ago @ 9:51 AM
Points: 5,
Visits: 78
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
Post #1069118
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
