Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rajendra
Starting Member
5 Posts |
 Posted - 2008-10-01 : 10:20:03
|
| I am having performance issue with Sql server 2000. While connecting using sql server 7 client; it works nice but issue with performance with 2000 client |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Rajendra
Starting Member
5 Posts |
Posted - 2008-10-02 : 02:02:07
|
| Description on problam in depth....(A) My Customer is having SQL SERVER 2000 machine with Gigabit NIC(B) All client systems are having 100 mbps NIC and connected thru 100 mbps switch(C) Some Client machines are having SQL SERVER 2000 Client+Server Components installed. These machines are connecting to Server -"A"(D) Some Client machines are having SQL SERVER 7 Client+Server Components installed. These machines are also connecting to Server -"A"(E) Application is developed in BORLADND DELPHI - Uses BDE - Network Library for Sql Server Connection** Now in above Secenerio application running on machines "C" are slow; but good performance on machines "D" while fatching rows from table in the application |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-10-02 : 12:02:27
|
| B) are you sure the NIC is active at the proper higher speeds? it may be installed, but it can be throttled back.You have have to trace/benchmark the equipment to see where the delays are occurring? Search here for other message on this....this issue has come up several time in the past few years...not often, but there are some messages on same. |
|
|
|
Rajendra
Starting Member
5 Posts |
Posted - 2008-10-02 : 12:54:52
|
| I am sure that all NIC are running at 100 mbps full duplex speed; Why (C) and (D) should have differant performance on same hardware environment? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Rajendra
Starting Member
5 Posts |
Posted - 2008-10-02 : 13:30:07
|
| Specially when Scrolling Cursors;(Borland Database Engine TTable Objects) One More observation... If I Put one Gigabit Swithch between Server and Existing Switch; All clients works at high speed...(1) Server_GigabitNIC <---> 100mbps Switch<---->all_clientsis slow(2) Server_GigabitNIC<--->Gigabit Swithch(no-client with this switch)<---->100mbps(exisiting)Switch<---->all_clientsis fast |
|
|
|
|
|
|
Sql Server client performance