• You can find a few information in DMVs (sys.dm_exec_query_stats) but there will not be that many details.

    You will only know how many times it has been called since last server restart.

    You can use profiler to gather following information :

    - who called the SP (hostname, loginname or ntusername depending on the authentication type)

    - when it was called

    - ...