none connection corruption RRS feed

  • Question

  • We have an WebService that is having problems when put under a heavy load.

    it works like this.

    Clients submit data for a inventory transaction as XML data.

    I create a new sqlConnection(pooling =false)

    I create and start SqlTransaction

    I call a lower level dll passing in the sqlConnection/SqlTransation created in the WebService.

    If the lower level process works I commit the transaction and close the connection then dispose of both.

    if the lower level process fails I roll back and close the connection then dispose both.

    All works fine until mutilpe clients start sending in data for a trx

    When 2 or more trx try to execute at the same time we get all kinds of errors from several differnt points in the webService and lower level object.  Here are a couple examples;

    "Timeout expired.

    The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."

    "The SqlCommand is currently busy Open, Fetching. "

    "The ConnectionString property has not been initialized. "

    "General network error"

    "'select srvname from sysservers where isremote = 0' query FAILED"


    If they get an error and resubmit the trx will work fine.

    We have been working on this for long time.  Any advice?




    Friday, July 13, 2007 6:36 PM