SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Takes Query Plan Analysis and Performance Monitoring to a New Level

SSRS: Information about Report Execution History

Sometimes it is useful to know how long a report took to run and which users ran which reports. This can be achieved by querying the ExecutionLog table from the reportserver database.

Duration:
3 mins 52 secs
Skill Level:
100
Rating:
3.64 out of 5
Publish Date:
April 06, 2010
SSRS: Information about Report Execution History You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Marco Francisco
From Portugal. 26 years old. Experience in a wide variety of business intelligence projects and industries (in particular communications, automotive, billing & payments, CRM). Currently working at the biggest Portuguese communications company as BI Architect, Performance/Tuning and Project Manadgement.

References

There are no downloads or recommended reading links for this video

Comments
Vincent DANIEL on 4/7/2010
low quality video and english speaker

Huonglien Nguyen on 4/7/2010
Excellent information. The only problem was eventhough I turned on the volume to max, I barely heard the speaker.

Michael Davis on 4/7/2010
The video quality is very low, hard to read the text.

Mark Horninger on 4/7/2010
Could hardly hear the speaker, and he was very hard to understand with such a heavy accent.

Sara Karasik on 4/7/2010
Even with my speakers on the highest volume, I could barely hear anything. Add to that the thick accent, and the unclear text on the screen, this video was a total waste of time. BUT - I still love this site, and find the vast majority of the short videos to be informative and interesting!

nirav on 4/7/2010
can i get the queries that author executed in the video?

Marco Francisco on 4/7/2010
yes nirav. take a look at http://www.bidn.com/blogs/marcoadf

Marco Francisco on 4/7/2010
Sorry...but first version wasnt very clearly..I made another version of it...myst talk with admins.

Gregory Caporale on 4/7/2010
Would like to have access to the actual script.

glyn on 4/7/2010
Screen is very blurred, sound is very low altogether a very unsuccesful video. This is very annoying as I wanted this information and it is important. Is it possible for you to email me the scripts that are shown in this video?

Andrew Meyer on 4/7/2010
Unable to clearly see queries used in video.

John on 4/7/2010
I tried to visit your blog but the site was down and I would really like to get the scripts you have. Thanks

Joe on 4/7/2010
The resolution too small for me to read comfortably

Christian Bahnsen on 4/7/2010
Awesome topic. Thanks so much. It would help if you zoom in tighter on the T-SQL. It was very hard to read some of the code.

Dexter Jones on 4/7/2010
The information is good, but the screen is too small.

Helena Li on 4/7/2010
I cann't hear what he said, the voice is too low

Not Available on 4/7/2010
The screen and script is hard to see, but it is a good information to know.

B3BA2F9D45 on 4/7/2010
it's really fuzzy. be nice to be able to read the screens

sriman_mca on 4/7/2010
not visible properly.

Vladimir Sotirov on 4/7/2010
Please make to volume up next time.

Arvind on 4/7/2010
Video was not very clear. I could not see what column was used for join condition.

7A4FBBE753 on 4/7/2010
Good info - need more about the tables/views used in the queries though.

R Michael Lacy on 4/8/2010
Can't read what's shown on your screens. Please post scripts.

douglas williams on 4/8/2010
I think that this was a good intro into Report Execution History. However, there were a few times when i had to replay a section because the presenter was speaking a bit fast for me to accurately hear what he was saying.

douglas williams on 4/8/2010
I would agree with the majority. I thought the topic was good but the presentation - esp.the low audio and video quality - made it a challenge to get the info.

Charlie Bruno on 4/8/2010
Good info, but I could not see the text on the screen.

Roman Yusfin on 4/9/2010
Good content, need better visuals - zoom in on code and results. ;)

Laura Sell on 4/9/2010
The screens were a little blurry, but other than that, great demo.

Dexter Jones on 4/12/2010
Good information. Thank you, Marco. (I wish my Spanish was as good as your English!)

William Ringland on 4/12/2010
Sound was way too low and SQL code way too blurry. Subject material was good.

Jennifer Stauffer on 4/22/2010
It was a little bit difficult to see the code. It would be helpful to have the code posted separately.

Narayana on 6/7/2010
good one

Marrina Chen on 9/27/2010
The presentation is valuable. Please make your query easy to read for viewers. Thanks

Chris on 10/6/2010
Video far too small to read code.

Adam on 3/11/2011
great work! if code window was clearer in the screen cam and the sql was made available as a download, it would be fantastic.

Keith Cooper on 3/11/2011
the content looks to be interesting, but this guy's English is unintelligble with his thick accent to the point where I could not understand a thing he was saying! Sorry!

Asan Buhari on 3/13/2011
Very low audio and therefore it was not that clear to catch things at first.

lital on 3/14/2011
Excellent information.

Sneha on 3/14/2011
The font was very small and not visible.Presenter was speacking very fast.

John on 3/14/2011
Content of video was very good - however, the resolution of the video was so poor that I could not read the queries.

WChaster on 3/14/2011
The captured screen was too small for me to read.

B on 3/18/2011
I have a hard time understanding the presenter (accent) AND I could not read the code and results on the screen because it was too small and blurry.

jeff ewing on 3/28/2011
good data, poor audio and need to pause longer on code.

19BD5EE3C5 on 3/31/2011
poor quality video - couldn't see the text

blaze on 4/11/2011
THE CODE IS HARD TO READ

Bini on 4/26/2011
You need to show your line of code, zoom in a little closer. You explained it very well but I couldn't see your T-SQL for retrieving the data.

Maurice Ivory on 7/22/2011
It was okay

Les Weaving on 11/11/2011
Useless quality - what a waste of my time, couldn't understand a word!

Tavis Reddick on 5/29/2012
It's a bit difficult to read the SQL on the video.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions