Offloading Data Sets

Last Post 02 Aug 2007 10:24 AM by sschmid4. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sschmid4
New Member
New Member

--
02 Aug 2007 10:24 AM
Investigating using reporting services and I need to understand where the underlying dataset is stored when creating a dataset in Model Designer. If I install a Reporting Services instance on a second server outside of the server holding the OLTP instance, does the creation of a data model then allow me to store that data model as it's own database on the Reporting Services instance thus removing the hit to the OLTP instance? Having the model is nice for design purposes but really getting the I/O hit away from the OLTP instance is what I need.


Acceptable Use Policy
---