x

SSRS data source location best practice

Hi all,

just an easy question/need this morning. I'm looking for informations pointing out that a data source shouldn't be too far away from SSRS. I have a request to create additional data sources that will point to several remote locations. I have a gut feeling that this isn't best practice at all.

Regards Dirk
more ▼

asked Jul 19, 2012 at 08:09 AM in Default

DirkHondong gravatar image

DirkHondong
1.3k 15 17 19

What are these additional data sources exactly? Are they shared data sources?
Jul 19, 2012 at 10:27 AM Usman Butt
Yes, they are. Or better: will be
Jul 19, 2012 at 10:33 AM DirkHondong
So the problem is the remote sites? They are not in the same data center and you are worried of the issues may arise due to Network Latency?
Jul 19, 2012 at 10:38 AM Usman Butt
That is right. And I do not have the information tight now how the query will look like, how many data will be selected etc pp.
Jul 19, 2012 at 10:44 AM DirkHondong
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Hmm...frankly speaking I do not know what to answer precisely ;) But it is definitely not the best option unless it is the only one you have. It could mean if there are several remote locations with reports of large data sets (simultaneous run), you could be having lots of performance, timeout, Logon issues etc. It can even make your server slow for the local DBs. So this becomes sort of Capacity Planning. If you have an ultra fast network, multiple network routes, multiple network cards, a beefy server, then you may get away with this ;)

But one should ask why there is a need for that? Less hardware resources OR someone put an idea to have a centralized Reporting Server for all remote sites for centralized management?
more ▼

answered Jul 19, 2012 at 11:32 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

Well' we already have de-centralized SSRS in place. But now there is the idea of few new reports which need some KPIs from other locations as well. So, instead of consolidating the data to one location and get the data from reporting there, the report itself should use several data sources, querying the locations directly and view the result.
Jul 19, 2012 at 11:36 AM DirkHondong
I do not see it as a good idea. What if any of the remote site is down? Moreover, KPI reminds me of SharePoint and Excel more ;)
Jul 19, 2012 at 12:36 PM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x558
x7

asked: Jul 19, 2012 at 08:09 AM

Seen: 1109 times

Last Updated: Jul 19, 2012 at 12:36 PM