How to Identify which Reports are Running on the Central Management Console/InfoView

Hello Experts,

I am having a database performance problem which has been traced to the server that has the Central Management Console and runs my Crystal Reports Job Server.  Is there a way I can trace which report(s) were run on demand (not scheduled), so I can know if the database perfomance slowdown occurred while a Crystal Report was being run from Info View?  I did check the 'History' option for reports in Info View that I know where run, but there were no historical instances.  

Also, on the Central Management Console REPORTJOBSERVER window - Metrics tab, there is an item, 'Total Number of Job Requests Received:'  which currently shows a '2'.  What does that '2' represent, and if it represents reports, how can I see which reports it is referring to?

Thank you for any guidance on this issue.
~Chopp
ChoppAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

wykabryanCommented:
Good luck on this one. There is one way to narrow it down. When the database starts to hang due to performance issue. Go into Admin Launchpad (Different than the CMC), click on the instance manager. Log in. The screen will come up blank at first, change the status to Running or Pending. Do not fill in the By User fields. This will return all reports that are pending or running at that time. The reason for Pending is some reports, especially the one with performance issues, sometime start running and then stop - thus go into pending mode. The only other way is to write a report that goes against the audit database, if you have it turned on. CMC schedules are usually done by administrators whereas Infoview schedules are done by everyone else. so it is easy to sort them them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ChoppAuthor Commented:
Thank you for your help.  I am going to download the 'SQL Server Performance Dashboard Reports' tool to help monitor and identify the source of the performance problem.

~Chopp
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.