Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange Performance Issues
Message
From
18/04/2002 08:44:36
Kenneth Downs
Secure Data Software, Inc.
New York, United States
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00643932
Message ID:
00646276
Views:
31
>compare the values that you're seeing to the other box. Do any of them seem really out of line?
>
>I thought you only had to issue diskperf -Y to catch physical disk counters.
>
>-Mike

Well, I ended up going another way. The perfmon may be a nice tool, but I am unfamiliar with it, which is why I have to say "may be a nice tool", I just usually can get where I need to go on my own.

So anyway, I discovered at least that the network card was at fault, by doing these tests:

Retrieve New Machine to WS : SLOW
Retrieve Old Machine to WS : FAST
Retrieve New Machine to Self: VERY FAST
Retrieve New Machine to Old : SLOW
Retrieve Old Machine to Self: VERY FAST
Retrieve Old Machine to New : SLO

Which showed that every time the data had to leave the new server over the net, it choked. So we put in a new net card and that cured some of it, but not all. What I now have is basically this:

Test table, 25000 records, 500 byte fixed length (10 fields of 50 chars), populated entirely with foxpro's SYS(2015) function, which gives about 30% randomized data. In test after test, the old machine is delivering about 7200 recs/second, while the new one has gone from 1800 to 4000. So the net card was some of it, but not all of it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform