Geek Answers Handbook

The absence of a response from the server during a remote call to a stored procedure in essence

I have a Silverlight web application hosted on Azure vm in IIS. I have another virtual machine that hosts SQL Server along with another application that the web application is interacting with. I installed a LAN between these two virtual machines using the Azure Virtual Network. Vm, which runs IIS and the web hosting application, is also my domain controller, and I use Windows Authentication to authenticate users in this web application. The application uses the entity infrastructure to execute some stored procedures.

In general, everything works fine when the web application is available both locally and remotely, but there is one specific stored procedure that takes about 25 minutes to execute, which does not seem to work properly when remotely uninstalling through this web application. Please keep in mind that this 25 minutes is really the expected time, because this stored procedure deals with millions of records.

So, here is the problem I am having. When this stored procedure is executed from SQL Server Management Studio, it completes after about 25 minutes. When I execute this stored procedure from a web application locally, using the internal ip of the server hosting the application, it competes after about 25 minutes, the server sends a response back, and the application updates its status. But when I execute through the web application remotely using the server’s public IP address, although the stored procedure executes and completes within 25 minutes on the server, the application never receives a response from the server, it remains in a busy state.

I know that the stored procedure is executed because I track it directly on the database server, and also using the sql profiler to track any open connections from the entity framework that exists even after the stored procedure completes. I also use a violinist to track all HTTP traffic, and here's what I see.

When running locally through a web application using internal ip Executing locally

when uninstalling remotely via a web application using public ip enter image description here

All other stored procedures take a few seconds, and they seem to work both locally and remotely. I'm not sure if Azure endpoint binding has anything to do with this. When executing this stored procedure, I set the commandtimeout property to 0.

Any help would be greatly appreciated!

image links:

: http://i.imgur.com/NGNre3T.png

: http://i.imgur.com/haB3fwm.png

+4
1

- Azure. , , . Azure Powershell, :

Get-AzureVM –ServiceName "your-service-name" –Name "your-vm-name" | Get-AzureEndpoint

, :

Set-AzurePublicIP –PublicIPName "the-ip-name" –VM "your-vm-name" -IdleTimeoutInMinutes 15
0

More articles:


All Articles