Solved

SSRS WMI processing defaults?

Posted on 2012-04-09
2
312 Views
Last Modified: 2012-06-21
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.
0
Comment
Question by:fstinc
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 37827438
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
0
 

Author Closing Comment

by:fstinc
ID: 37858314
Yeah, I was a bit lost. It looks like its VBscripts that are gathering information. Thanks.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now