SP1 STD ED
dual proc
Sql 2k
--
My ReportServer service just went nuts and started running it's on Sprocs - in the 10s of thousands - (continuously) and eating up all of a dual processor box
It also started logging 30 plus meg log files - I had to turn off logging so I didnâ't run out of HD space
I only have one or 2 reports scheduled and this seemed to make no difference to the service
I stopped and restarted the service
Stopped and restarted SQL Server
Still going crazy â' any ideas?
Had to stop Reporting services for the night
Thanks, AHHRestarted the RS service this morning on the box on which it is installed and the problem seems to have abated for now
If anyone else has experienced this issue and found a solution please advise...
Thanks AHH
Showing posts with label proc. Show all posts
Showing posts with label proc. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
Reports based on OLAP?
We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated.Is it possible to do that?
--Yes
Are there any client applications which allows to create these types of
reports?
--Yes, you create the cubes in Analysis Services and you can use Excel Pivot
tables to connect, then if you are looking for more functionality and better
graphing capability you have a whole host of options. Search on google for
OLAP viewers, there's a bunch. I use ProClarity (www.proclarity.com )
You will want to look into using DTS to copy your data to a store where you
can build your cubes off.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:u%23ov$HCvDHA.1744@.TK2MSFTNGP12.phx.gbl...
to
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated.Is it possible to do that?
--Yes
Are there any client applications which allows to create these types of
reports?
--Yes, you create the cubes in Analysis Services and you can use Excel Pivot
tables to connect, then if you are looking for more functionality and better
graphing capability you have a whole host of options. Search on google for
OLAP viewers, there's a bunch. I use ProClarity (www.proclarity.com )
You will want to look into using DTS to copy your data to a store where you
can build your cubes off.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:u%23ov$HCvDHA.1744@.TK2MSFTNGP12.phx.gbl...
quote:
> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows
to
quote:
> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
Subscribe to:
Posts (Atom)