Many "Create Procedure" statements shown in SQL PI for SQL Server (4229580)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Many "Create Procedure" statements shown in SQL PI for SQL Server
Description

While troubleshooting a performance issue with a SQL Server database, Foglight is showing lot of "Create Procedure" statement. However, the application team claims that there's no create procedure in their code. The create date on these stored procedures do not change either. Can you look into this please?
Resolution

This is part of how the functionality of how SQL Server works.
Whenever a stored procedure is executing, the text for the procedure is the create statement. This does not mean it is the actual create that was running but the stored procedure itself was executing.
This is not in the control of Performance Investigator (SQL PI), but it is a positive activity because use can see what the stored procedure is actually doing by looking at its code without the need to open another tool.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title