What did info did you glean from the system and application logs? Can't you
tell them to try it on a regular server and see if the problem goes away?
Otherwise, they need to get you a virtual server for your lab that you can use
to test with.
Testing it in your own controlled environment is a must. On their network it
could be going through a firewall (for example) where all the ports that SQL
server needs to function haven't been properly opened up (although that would
imply a "hang" situtation rather than actual crash). Or they might be having
licensing issues with their server or the SQL database, etc. (I've seen
Microsoft products where the server crashed when the licenses were exceeded.
Exchange for example). These are things that could be wrong on their network
that have nothing to do with your app.
There are too many variables that could be beyond your control as a non IT
employee. You need to prove to the customer that your product can perform
flawlessly in a known controlled situation. Once you have that in your lab, you
can then make requirements as to what they need to have established in their
environment, or all bets are off as to its performance.
Dave
edsynergy <[EMAIL PROTECTED]> wrote: I have just
gone live with a delphi app which has mssql at the backend.
Under load testing it has been well behaved. It is now installed in a
large health organisation with users coming in over wan connections to
the sql server. For periods the system performs well and then it
crashes. All other users of the system also crash out as well. The
application will still launch and they can even log on but meaningful
work is not possible.
I have reviewed the code and cannot find an issue there. It would be
easy for me to blame the network/ old pc's ( and not doubt the clients
IT support could point a the software) but I rather get to the bottom
of it. The sql server is not on a dedicated server. It is one of
these new fangled virtual servers and I wonder if this is the issue.
After all it is only using the chunk of memory allocated to it by the
real server it is on. Would this impact on performance. Any views
would be much appreciated.
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
