SSRS WMI processing defaults?

fstinc
fstinc used Ask the Experts™
on
We are using SSRS to report Server performance. I would like to find out how often SSRS is connecting to servers to update the Database? I cannot seem to find it.  . . Is it resource intensive is what I am trying to find out. Thank you in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
BI Consultant
Most Valuable Expert 2011
Commented:
I'm not sure what you're referring to with "updating the database".  SSRS retrieves data from databases, not the other way around.

Put simply, each time a report is requested, either manually (through Report Server or Report Manager) or automated, the dataset will be built and thus data will be retrieved from the database.

Since SQL Server 2008 R8, there's an option to use caching on shared datasets, possibly something to look into?  See http://msdn.microsoft.com/en-us/library/ee636149(v=sql.105).aspx

Author

Commented:
Yeah, I was a bit lost. It looks like its VBscripts that are gathering information. Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial