I have a rather large sproc that is taking a minimum of 40 seconds to execute. I have removed everything on the page and am only executing the sproc and it takes 40 seconds.<BR>The sproc takes 10 parameters and creates a dynamic statement to retrieve data. <BR>It was blazing fast until an SSL certificate and outlook web access was installed on the same server. The procedure executes immediately from query analyzer and other large sprocs execute fine from the ASP pages but this one just takes 40 seconds.<BR>any ideas with what I can try?<BR>I didn&#039;t write the sproc and the data model being used is complete crap but I have no control over that.