Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Tuesday, July 4, 2017

How does a stored procedure takes 15 seconds to start?

SQLServerCentral » Latest topics
How does a stored procedure takes 15 seconds to start?
The trace attached shows a stored procedure calling another stored procedure.
The statement calling the inner procedure takes 18 seconds while the inner procedure itself only takes 2.5 seconds!
In fact, according to the trace, the start date&t

No comments: