Tuesday, March 20, 2012

Bandwidth Utilization...

I have two identical SQL Servers... same OS... same config... when i
run my SSIS package on one server... Bandwidth utilization goes upto
20 mb... and package completes in 10 mins. Its getting data from
oracle DB. I will be migrating this package to another the other
server... there it takes about 1 hour... and bandwidth utilization is
about 2mb... why is the difference in speed of getting data? What
can be the contributor for this? I am using oracle 9i drivers for both
servers... on one its 9.2.0.0 (upto 20 mb speed) and the other one is
9.2.0.6 (2mb max). I dont think it can be the driver version. However
I cant seem to find the 9.2.0.0 to rule out this possibility.
Any help will be greatly appreciated.
Regards, zomer.How are the NIC's configured? Is one configured at 10MB? What about the othe
r
NIC settings?
Have you checked the event log on the machine that is getting low
utilization? Anything there?
I don't know what its called, but I know that the network guys can limit the
bandwidth someone uses. Ask your network guys and see if its been done.
Hope that helps,
Jay
"zomer" wrote:

> I have two identical SQL Servers... same OS... same config... when i
> run my SSIS package on one server... Bandwidth utilization goes upto
> 20 mb... and package completes in 10 mins. Its getting data from
> oracle DB. I will be migrating this package to another the other
> server... there it takes about 1 hour... and bandwidth utilization is
> about 2mb... why is the difference in speed of getting data? What
> can be the contributor for this? I am using oracle 9i drivers for both
> servers... on one its 9.2.0.0 (upto 20 mb speed) and the other one is
> 9.2.0.6 (2mb max). I dont think it can be the driver version. However
> I cant seem to find the 9.2.0.0 to rule out this possibility.
> Any help will be greatly appreciated.
> Regards, zomer.
>|||Both are at 100 Full Duplex. That is the Speed of the OAM router.
That OAM router is locked on 100 full also.
Everything else is the same on both machines... except the ora driver
version.

No comments:

Post a Comment