Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stored Procedure Hangs but Works Fine after Recompile Expand / Collapse
Author
Message
Posted Wednesday, October 1, 2008 8:10 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:19 PM
Points: 21, Visits: 167
Hi

Folks

I have a Stored Procedure which generally works great but some days it Just Hangs when we use it thorough our VB 6 application. At that time if I try to execute the SP in SSMS with the same parameter which the application is using it works fine. It only Hangs through the Application. To have a work around I recreated the Store Procedure and then the applications work fine. As of now I have added the "with recompile" option to the Stored Procedure. But if any one has any Ideas why this could happen I would applicate it.

We are using SQL Server 2005 and VB 6 ADO.

Thanks


Raj Gujar
Post #579080
Posted Wednesday, October 1, 2008 8:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 6:30 AM
Points: 16, Visits: 149
Hi,

If possible, check with profiler when you get your system hanged out next time. It might give you a clue.

Thanks
Post #579088
Posted Wednesday, October 1, 2008 8:57 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:19 PM
Points: 21, Visits: 167
I will do it when next time it hangs, But My Concern is that It works great through SSMS at the very same time but hangs through the application. My Understanding is that if it has to impact performance it should be consistent through SSMS or Application
Post #579131
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse