How to check execution logs

[siddu]

Hi,

How to find execution logs like execution time of StoredProcedure etc using ReportServerDB in SQLSERVER 2005
Also suggest how to increase performance of StoredProcedure

Thanks