SQLCLR WEB SERVICE

Last post 05-09-2008, 12:48 PM by assismarques. 0 replies.
Sort Posts: Previous Next
  •  05-09-2008, 12:48 PM Post number 51793

    SQLCLR WEB SERVICE

    I'm having a problem executing a SQLCLR function: this function  
    calls a web services that processes a query to a  data base and 
    returns a table to be used in a stored procedure. In a  low 
    concurrency scenario (not to many clients connected), the function 
    returns  correctly, however when the concurrency level is increased 
    we  have a SQLCLR command execution problem (all the SQLCLR 
    processes hangs), making the server unavailable to all web services 
    processes.

    At first we thought the problem could be the SQLCLR, since the web  
    services is 100% available, all the time. We monitored to come  to 
    this conclusion. Do you know of some SQLCLR bug?

    Could someone help me with this? I'm in a difficult situation with  
    my client, considering that we defended the MS SQLServer technology  
    and now it's not working properly.


    Att,

    Assis Marques
    DBA
View as RSS news feed in XML