Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-04 : 08:03:34
|
| Wes writes "I have two servers: libsql3 - a high use server that feeds a call center, and LMS - a lesser used server for reporting and office data.I want to combine data from libsql3 with that of the LMS. The purpose of combining the data is for real time and historical production tracking of the call center agents. Eventually the supervisors will use an application in access to view the data from their stations.I attempted to use a view on the LMS which used openrowset to access a view on libsql3 containing the data I wanted and there was a performance dip on libsql3 that interferred with ongoing production.The required data set for the real time portion is less than 200 records out of ~1 Million based on a date and text matching criteria.The historical portion will use copies of the appropriate data created overnight so pose no special problem. What can I do to combine this data for the real time portion of this?" |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2005-10-04 : 08:12:48
|
Why don't you look at partitioning the tables?ie have 1 table holding the latest data (ie within the last week) and other tables partitioned per week or Month or so?edit: this must happen on the frequently used server obviouslyDuane.  |
 |
|
|
|
|
|
Data from two servers