November 25, 2003 at 2:35 pm
We have a web page that hits a series of stored procedures and produces results on an ASP Page.
The page is very slow when loading the data, but is very front end light. Very few records are returned to the page.
We run Profiler, capture the exact procs & params being sent to SQL, gather them and run them in QA. Bamm! Lightning fast.
We have checked for network bottlenecks and nothing.
Any ideas greatly appreciated!!
-Thanks
November 25, 2003 at 2:44 pm
I think we got it.
We threw With recompile in the proc and bamm, back to normal.
Question:
Why was QA acting differently?
Why was is recompile needed?
Thanks
November 25, 2003 at 10:54 pm
Check your ,OLE-DB Service ,ADO is accessing the SQL Server through a totally diffrent set of libs , You might have cahanged some important index in a table ,wich some times need a recompile ,see sp_recompile
Regards john
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply