Reporting Services

[onpnt]

Has anyone gone deep into SQL Server 2K Reporting Services?

I thinking of looking into it due to a task that in my eyes can be completed easily with something as old as ASP3 but want to introduce some new (but old to the world) technology to my team.

The task is quite simple in a active refresh page (intranet web interface) at about a increment rate of 5 seconds to show active phone agents. Things like call wait time, number of calls etc....

without looking in-depth into reporting services does anyone know or used it for this kind of rapid refresh rate? I'm concerned about killing the performance

thanks for the discussion

 

[aalmeida]

I do not think that a reporting tool would be apropriate for this lind of things, it would be an overkill.

I think you would be able to do this better with the ASP or .NET programing.


AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[onpnt]

I'm agreeing with you but wondering if anyone has some kind of benchmarks or testing (exp.) with reporting services and how it may take effect on a network and its resources. of course no network is the same and there are 100's of variables to take under consideration that may make your performance better then the next net but in all performance can be seen.

I'm in the process of setting up some test app's for getting some needed data on how resources are used and what this tool will do on this type of rapid query environment. when I get those results I'll post them. I'm hoping someone has some data I can compare with.

Thanks

 

[aalmeida]

Ok,

I have installed and used Reporting Services myself for Enterprise wide solutions on highly used Reports and for my own use like reporting on SQL server status (I'm a DBA).

The impact on the network is minimum and actually depend upon the number of users more that the report server it self.
It is a new product from microsoft so there are not much documentation or administrator experience available in the market as one would want, but for a new product it is very Administrator friendly, easy to install and mantain.
At the time I installed it last year I had no experience what so ever with reporting services and I got the installation right at the first try and did not have to dig to deep.
I created some reports based on the templates that were incredibly close to my needs (That was surprising) and created new reports my self using Visual Studio .NET.
The trick part was permitions and seting up Visual Studio .NET.

AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"

 

[xlbo]

We have only just implemented here and I am more of a report writer than a DBA but the guy that I am developing reports with has been using / testing RS for >6 months and when I mentioned your question, he got that "oh my god you can't be serious" look in his eyes....not a good sign. From what I understand, you can easily schedule reports but there is nothing in the setup that would make it easier / more efficient to schedule reports at that kind of interval than any other standard reporting application - it is basically using a standard query engin within the .NET framework so it is very flexible but doesn't really offer anything too different (query wise) from what you might get from Business Objects or Crystal etc

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[ookete]

You're looking for something like a datagrid on a webpage that queries its source every 5 seconds or so. You wouldn't go to Reporting Services for this.

 

[Glowworm27]

Another thing to note is you may call reports from the reporting service via the Reporting Service Webservice. But I don't think it would be a good fit for your application.

Also you may want to research data caching because if your data hasn't changed you may want to cache the data, to reduce the network traffic.

Just my two cents

HTH

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips