March 7, 2011 at 10:29 am
In my server a job is running which transfers records from a DB to customer server.... but customer says that the transfer rate is very slow and they say that it is not using full bandwidth... As a DBA wat should i do to resolve this issue????
March 8, 2011 at 4:23 am
I will take a look at the job history. Is the job taking more time to run than usual.
If the job was taking 5 mins to run last week on a Monday, is it taking 15 mins to run this Monday.
Is it like the data that is transferred from one region to other varies from day to day.
I would look into these considerations so that I could verify things on SQL Server itself before looking
at network bandwidth etc.
M&M
March 9, 2011 at 11:22 am
premkuttan,
You have no way of knowing exactly what the problem is unless you have something to compare it to. How long does it take to copy some 10 MB file to the customer's server? If that takes a long time then there is a bandwidth problem. If not, then something else, such as how long does the query run locally, should be looked at.
Todd Fifield
March 10, 2011 at 10:08 am
1) check network bandwidth with proper tool or even a simple file transfer as someone else mentioned
2) run a query that outputs same data directly to a local file to test if it is just a slow-performing query
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply