Find executed store procedure.

Rafnas T P9y ago

For new stored procedure names you can use below code

use [DatabaseName]

SELECT name

FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7

For Modified stored procedure names you can use below code

use [DatabaseName]

SELECT name
FROM sys.objects
WHERE type = 'P'

AND DATEDIFF(D,modify_date, GETDATE()) < 7

Red colour field you can give your Database name

0

Vikrant More9y ago

use below DMV to identify, however it will holds aggregated data you could not see for previous week but you can get details about procedure since plan_cache has not flush.

select OBJECT_NAME(object_id) as SPName,* from sys.dm_exec_procedure_stats

0

Nitin Sontakke9y ago

I think you are attacking the problem from wrong direction. It is never a good idea to decide something before doing any investigation.

I suggest, you generate a built in performance report by:

Open SQL Server Management Studio, connect to the server, right click on the server node and then choose Reports -> Standard Reports -> Performance - Top queries by Average CPU Time. This will give you some idea.

But remember that there might several reasons why your application is slow.

+1