Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2009-09-30 : 06:33:10
|
| Hi,Just checked few times that when i run reports off the report server, the memory on the driver where the report server database is installed drops quite fast.Any info to what is going on? Databases expanding when reports are running? are they caching any data?Thanks |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2009-09-30 : 15:48:09
|
| Does the report try to retrieve million row data? Or your report dbs sitting on a very busy server? You could set up the report execution schedule when the box is not busy. |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2009-10-01 : 04:56:33
|
I found that alot of the reports were previously created with aload of views and views take up alot of space. So converted all the reports to SP's and the problem is solved.quote:
Originally posted by Dance Doll
Does the report try to retrieve million row data? Or your report dbs sitting on a very busy server? You could set up the report execution schedule when the box is not busy.
|
|
|
|
|
|
|
Reporting service performance