Stored Procedures ID in MSSQL

[Swati_Bhat]

Hi all,

can someone suggest how to capture and display storedprocedure ID?

Thanks!

[MaciejNeumann]

Hello @Swati_Bhat ,

As we're waiting for help from the rest of the Community, you can check out these documentation articles, which explains how to manage your MSSQL extensions and how to get even more information by creating your own MSSQL extension.

[Mike_L]

As this is in the extensions forum: Do you mean with the MSSQL extension (which currently doesn't capture stored procedures), or do you mean through the OneAgent deep monitoring? I'd expect the latter, but just want to make sure before moving the thread to the correct forum.

[Babar_Qayyum]

Hello @Mike_L 

We are using the Oracle Database Extension 1.1.3, but do not see the most time consuming Oracle statements. What could be the reason?

Regards,

Babar

[Mike_L]

There is a new feature set added called TopN, you need to enable that to get the top queries. 

[Babar_Qayyum]

Hello @Mike_L 

The feature is already enabled.

Regards,

Babar

[Mike_L]

And you are on logs v2 or grail? If so I’d have a look at the AG logs to look for a permission error or so.

[Babar_Qayyum]

Hello @Mike_L 

We are on Log v2. Normally, we are providing the following permissions:

• CREATE_SESSION
• SELECT_CATALOG_ROLE

Sure, I can check the AG logs as well.

Regards,

Babar