Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning I'm using EXECUTE sp_executesql in my ASP.NET RE: I'm using EXECUTE sp_executesql in my ASP.NET

  • January 11, 2012 at 9:38 am

    #1431916

    RESOURCE_SEMAPHORE_QUERY_COMPILE waits is high. My understanding, this nothing to do with my ASP.NET code technique

    Let's, my same Stored Procedure is execute 500 a day. Did we have special technique to make it run efficiently?