Stored procedures run inside the database engine, and their execution details are nearly opaque to external tracing systems, significantly increasing the difficulty of locating performance bottlenecks and troubleshooting issues.