#1 

Being around such talented people as you would be working with would be a geat experience.    I love creating and being so detailed oriented I think the desire to...

Thanks, I found some interesting articles based on this one.  My server guy tells me we should be running the latest hotfixes.  What I found was teh ASPNET_* files are...

Once in a bind I did a restore that appeared to work. 

I think the process I used was:

I restored a MSDB database to another name - "MSDB_OldV" on the target...

What OS are you running?  Are you running RS SP2?  What are your IIS configurations?  Do you have a seperate applicationPool for RS and is it set for web farm? ...

I monitored my desktop while rendering the report and the network had one blip as expected immediately before the rendering.  It did not last long enough to be the entire...

By the way, I found the compression settings in IIS and none of them are set.

Just my simple testing it takes as long to page and open groupings on the server as it does my desktop. 

I have been monitoring the W3WP.exe process more and...

I do understand what you are saying about the more logic - the longer it takes.  I have found experiemetnally some things that take a long time.  In report paramteres...

Correction on #9.  It akes 1-2 seconds not 102 seconds.

Thanks for the response.  Let me answer your questions with the answers I do know.

1. During monitoring, I see CPU go up on server where Reporting Services resides and it...

I'm trying to find answeres to problems with speed of rpeorting services renderings/formatting.  Reports take WAY to long to display when the SQL behind them is relatively speedy.  Did you ever...

I don't believe there is a way to do this in SQL2K. 

I've searched for the same kind of security.  I need to be able to allow application managers to look...

I would suggest reading up on kerberos and checking your server properties in active directory (assuming you are configured this way) for "Trust computer for delegation" option.

I have no real solutions but more thoughts.

Good link on the tempdb contention.  I've had issues that I think have been helped somewhat with SP3 but still believe I should implement...

In an previous life, I supported about 130 servers running SQL Server and the only way I installed and upgraded was via Terminal Services ( or other tools on older NT4 servers). ...