Showing posts with label tools. Show all posts
Showing posts with label tools. Show all posts

Wednesday, March 21, 2012

Reporting Services on Win XP Pro x64

I just installed SQL 2005 Express with advanced tools on my Win XP Pro 64 bit edition. I expected reporting services to work but it appears as if it isn't configured. I use SQL 2005 Enterprise at work and there I used the Reporting Services Configuration Toole to configure and set up reporting services. However, this tool is not available with the current install.
When I installed, the installer warned that .NET 64-bit is registered and that it requires .NET 32-bit to install report server. Is there a special install I need to install report server for x64.
Thanks
Wentzel

You need to configure IIS to run in WOW64 mode, see http://msdn2.microsoft.com/en-us/library/ms143293.aspx.

Reporting Services Management

What tools are available to manage which users are currently running what
reports, parameters selected, load on server etc. Basically I'm trying to
figure out how I determine if Reporting Services is slow, what report/user is
causing it, or if it's just a lot of people asking for reports and I need to
look at scaling the server.
I'm interested in historical stuff, but I'm also interested in real time
this is what's happening where with what components. For instance is
retrieval slow or is it rendering that's slowing the report down, slamming
the cpu etc.
I see the DTS package for the logs and am installing that, but is there
anything more immediate like current activity in SQL server?Larry,
Your first stop should be the Execution Log. Check "Report Server Execution
Log" topic in the documentation. Among many other things, the Execution Log
will tell you how much time is spend in querying the data, processing and
rendering the report. In addition, in Report Manager you can see the current
activity (Running Jobs).
Warning.. shameless self-promotion :-) Accidentally, my book includes a
whole chapter (Chapter 16) on the RS performance and scalability.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:8947D670-D575-4FD1-A724-9A7A0147DF29@.microsoft.com...
> What tools are available to manage which users are currently running what
> reports, parameters selected, load on server etc. Basically I'm trying to
> figure out how I determine if Reporting Services is slow, what report/user
is
> causing it, or if it's just a lot of people asking for reports and I need
to
> look at scaling the server.
> I'm interested in historical stuff, but I'm also interested in real time
> this is what's happening where with what components. For instance is
> retrieval slow or is it rendering that's slowing the report down, slamming
> the cpu etc.
> I see the DTS package for the logs and am installing that, but is there
> anything more immediate like current activity in SQL server?sql