Gail, Michael!

You guys seem to be very close to the root of the problem.

Michael,

Actually you had a good point. I noticed there's a lot of

sp_executesql 'XXXXXXXXX' stuff. I would...

Is there a forum on SQLServerCentral for discussions on Reporting Services ?

Or maybe there is a better place than SQLCentral?

In QA it takes 1 sec to get the same results.

Our Report Server is running on

Windows XP Professional SP3; HP Pentium 4 CPU 3.20 GHz; 2 GB RAM.

Can it...

When I click on "Preview"

it takes 30 sec to generate a report in Visual Studio.

It's only 229 records (I checked it in Query Analyzer).

Does it always take that long to...

Should I exclude "NT AUTHORITY\SYSTEM" records?

UserNameNamePath

-------------------------------------------------------------------------------------------

NT AUTHORITY\SYSTEMCommodities - Stress Worst Case/Market Risk/Stress Testing/Commodities - Stress Worst Case

NT AUTHORITY\SYSTEMStress Worst Case/Market Risk/Stress Testing/Stress Worst Case

NT AUTHORITY\SYSTEMStress Worst Case/Market Risk/Stress Testing/Stress Worst...

Hi Gail,

Mike Vessey on page 2 of this thread wrote:

as i said you need RPC starting as well -

if you know this is going to be a stored proc then...

Hi VM,

You wrote:

In the "Events Selection" tab of the "Trace Properties" window, right click on Stored Procedures and click on 'Select Event Category'. You can find the "RPC:Starting" you are...

One thing I'm confused about.

All these DMV's.

Will they show me the historical data or it's just to

look at the current state?

I mean what if we had some long running...

I tried it with

"use master"

so I assume it should pick up all long running queries

regardless which database it was?

I checked compatibility level is 9.0

This morning "ReportServerTempDB_log.LDF" grew to 7 GB

and caused disk space problem on C:\ drive.

So I detached and attached it on D:\ drive

It's part of the bigger investigation.

The client is experiencing...

So to move ReportServer stuff from C to D

I guess i need to re0install Report Server?

Is that correct?

Or maybe i just can change he temporary files location

fro Report Server?

So they want me to move Report Server from C:\ drive to D:\ drive

on that production server.

Can it be done?

When Report Server is installed where its program files are saved?

Apparently the are running some daily jobs (every hour).

Report Server is running on the same box

and they suspect it might cause issues as well.

Should I maybe start Performance Counters to...

Here is an error log:

Error Output: 4/27/2009 9:38:25 AM, User: Bianca Oran

System.ApplicationException: Can not create new flag. ---> System.ApplicationException: Not able to GETENTITYBYID with id: 80603 of entities of type:...

I am using Profiler Standard template.

I do not see RPC starting.

Where do I get it.

It is not just SPs.

It might be anything.

I do not know their code.

I just started looking...