itwhiz (12/19/2013)
I have been tasked to monitor the performance of queries running on our dev/test machine.Can I store the output from using Set Statistics Time On ?
I want to monitor the execution times of stored procedures when used by SSRS reports.
If you are only interested in the run times of the procedures from SSRS reports, you can also extrapolate that from the ReportServer database.
Run statistics are kept in the ReportServer database, so you can query the ExecutionLog.
You should be able to tell which procs are associated to which reports and tune from there.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events