Search found 17 matches

by billsklar
Fri Sep 24, 2004 12:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NETWORKIO lastwaittype in SQL Server 2000
Replies: 4
Views: 1877

Problem seems to be on the "read" side of the job. When I replace the bulk loader with a flat file I still get networkio waittypes. It's like the appserver can't handle the data volume.
by billsklar
Fri Sep 24, 2004 10:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NETWORKIO lastwaittype in SQL Server 2000
Replies: 4
Views: 1877

NETWORKIO lastwaittype in SQL Server 2000

We are running several job at a time. The jobs use SQL bulk loaders. We are getting wait times on SQL of upwards of 60-70 seconds for data to be sent to the "client" (in this case that would be the DS appserver). Microsoft came out and said that SQL is basically waiting on DS to accept the...