January 10, 2009 at 2:27 am
I am using VB6 and SQL-2000. When i run my application from different machines simultaneously and perform a save function which contains insertion into 3 tables and updation of 1 table using query from the frontend, some machines are getting the message "Timeout Expired" and the Server is getting hang.. The application is working properly when there are less number of client machines.I have also set the connectiontimeout = 0.
The insertion/updation statement does not fire any trigger or does not have any cursors. I am not able to identify where the problem is, whether in the application coding or in the client machines or in the server ( the server is having very good configuration) or in the network.
Providing solution for this would be really appreciable..
January 10, 2009 at 2:33 pm
I am not able to identify where the problem is, whether in the application coding or in the client machines or in the server ( the server is having very good configuration) or in the network.
I don't wish to be unkind, but please stop and think about this. You haven't even come close to adequately describing your problem. Without seeing the T-SQL statements, or the VB code, or the client setup, or the server setup, or the network setup, how is anyone else supposed to give you an answer?
http://www.sqlservercentral.com/articles/Best+Practices/61537/
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
January 10, 2009 at 2:48 pm
Some questions:
1) How long does it take for the Timeout Expired message to appear?
2) What is your "QueryTimeout" set to?
3) How many simultaneous clients are running when this happens?
4) Are all of the Client instance running on the same client host?
5) Have you run the SQL Server Profiler or a trace while this is going on yet?
6) show us the SQL code being executed for the Save operation.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 10, 2009 at 4:19 pm
have you checked to see if any blocking is going on? that could lead to time-outs.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply