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 |
|
samrat
Yak Posting Veteran
94 Posts |
 Posted - 2003-08-26 : 03:33:39
|
| Greetings,I have noticed a very strange behaviour with our application, which runs on VB6.0 front end and SQL Server 2000 SP3 Backend (Both on the same machine)I notice some really slow response times if the machine is hooked up on the company's network and vice-versa when I unplug the network cable the response times is really fast. Any idea why this could be happening?Any help or a step in right direction very much appreciated.Samrat |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-08-26 : 05:03:31
|
| Try to assign other network protocol (in your connection string):;Network Library=dbnmpntw;initial catalog=.....This is Named Pipes; or use =dbmsipcn (Shared Memory).Default is dbmssocn (TCP/IP). Though I'm not sure for that.Note. The above syntax is for SQLOLEDB. In case of MSDASQLomit word 'Network'. |
 |
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-08-26 : 19:41:30
|
| Thanx for the reply stoad..But what I dont understand is, how come network protocol will slow down a application, when the application is a standalone installation. (Database and Front End application is on the same machine) ????Regards,Samrat Samrat |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 22:36:30
|
| Even if the the application and the database are on the same, they are still affected by the network. Have you checked any of the network counters in Performance Monitor to determine if a bottleneck exists there. It could be an issue with the NIC or maybe even with a worm. Have you applied the security patch for SQL Server service pack 3 yet? Is Windows patched to the latest security patches?Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 22:44:16
|
| I should have said if all of the machines on that network patched to the latest security patches from Windows? The latest worm (I think it's the Blaster) wrecks havoc on the network and affects all machines even if they are patched since it floods the network.Tara |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-08-27 : 00:04:11
|
| Thanx Tara,I think you are right in saying that heavy network can affect the application performance. I found out from my NA that there were couple of heavy activities on the network yestserday and today since the networks normal, the app seems to work fine. Can you point me on to some good reading material on Network protocol and SQL Server in relation to the same topic. I would definately like to pursue this further.Thanks,Samrat |
|
|
|
|
|
|
Slow Performance