Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Muhammad Majid Ali Attari
  Where is Muhammad Majid Ali Attari?
 Hyderabad
 Pakistan
 Muhammad Majid Ali Attari
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: Slow Reponse From DB Server
Thread ID: 344602 Message ID: 345003 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, May 17, 2012 6:55:51 AM         
   


> >
> > as i told pete that new server is responding as it should be. even, old server is performing fine but it suddenly stats responding v slow or stop to respond. server logs are as:
> >
> > unexpected EOF on client connection
> > could not send data to client
> >
> >
> > Regards,
> >
> > Muhammad Majid Ali Attari
> you Must check the Network card of server,hdd for bad sectors :)
>
>
> regards
> Anand S. Kulkarni
>
> When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!



netwrok is perfect. hdd is also flying. i was trying to figure it out. i was not applying SQLDISCONNECT() at exit of my app assuming that the connection will be ended automatically. i came to know that if i you dont terminate a connection to postgre server, it has been left open. although i could not watch those left open connections in server status window. but i applied it and added SQLDISCONNECT() at exit of app. it has been 3 days, client has not complained for slow response of server. hoping that i applied the right and learned a new lesson.
well Anand 'G', thanx 4 ur time. if i get any update, i will bother this thread again. thanx again

Regards,

Muhammad Majid Ali Attari

ENTIRE THREAD

Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/11/2012 9:13:48 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/11/2012 5:02:20 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/12/2012 7:21:34 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/12/2012 11:03:48 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:13:04 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/14/2012 2:49:10 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:30:32 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/15/2012 2:15:30 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:54:52 AM
RE: Slow Reponse From DB Server Posted by Pete Sass @ 5/17/2012 6:22:45 PM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/14/2012 7:34:34 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/14/2012 7:45:39 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/15/2012 7:32:14 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/15/2012 11:07:57 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 6:55:51 AM
RE: Slow Reponse From DB Server Posted by anand kulkarni @ 5/17/2012 7:08:04 AM
RE: Slow Reponse From DB Server Posted by Muhammad Majid Ali Attari @ 5/17/2012 11:28:23 AM