Our new SF application has been in full use for over a month. All, for the most part, has been going extremely well. Just recently...perhaps in the last week or so...we have been encountering a ton of SQLConnection errors at the remote end of our T1 line (10 - 20 per day). I have been doing my best to examine each window to best utilize the tips that I have gotten from all of you in the past, but now, I am stuck trying to figure out the origin of these errors (so many windows...so many queries). I assume that I could fire up the SQL Profiler, but there is so much data that comes flying through there, I am not sure how to best filter it to get to the root of the problem. I have a suspicion that there is one window or even one query that is gumming up the works for everyone else. I'd appreciate any tips or tricks for helping me track down my pesky connection problems.



Thanks!!

Bill

Let me approach this subject again with a little more information...



I have query that takes 9 seconds to run on the SQL Server itself. I can repeat that duration nearly every single time I execute it in the Query Analyzer. Sometimes it goes as high as 10 or 11 seconds, but 99% of the time it completes in 9 seconds. I am working on this query to improve it, but for all practical purposes, it is working within acceptable parameters. The number of records returned is less than 500.



As far as I understand the nature of the SQL Server, the actual execution is happening on the server itself, so if the query is called from the same subnet or a subnet from a distant location, the query will take the same amount of time to execute on the server. Please correct me if I am wrong about this point.



If a user in subnet A (the same subnet as the SQL Server) executes the query via the StrataFrame application, the window responds in less than 10 seconds (normally). If a user in subnet B (connected via a T1 line) executes the query via the same application, the window occasionally times out. Not always, but sometimes (couple times per day). Enough to be annoying, anyway.



Shouldn't I expect that the window in subnet B to be slightly slower than subnet A? After all it is only 1.5Mb. It reality it is much slower, so, where could the bottleneck be...the SQL connection, the data returned, something else? Should I be assuming that business objects (if any in the window) are being hydrated on the client? So, there would be no additional overhead between the client and the server regarding data flow, right?



Sorry...I know I have brought this up soooo many times, but I've got to point a finger at something tangible. My manager (and, in addition, the vice-president) is expecting an answer. At the moment, I have nothing more to offer.