Offloading Data Sets

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

02 Aug 2007 09: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