Find executed store procedure.

Question

How do find last one week executed store procedures in sql server? My server is slow when run my application so it will be store procedure problem.

Vikrant More · Answer

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

Nitin Sontakke · Answer

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.

Rafnas T P · Answer

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()) 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()) Red colour field you can give your Database name

Find executed store procedure.

Answers (3)