I have the following:
- AF Server whos database is on an enterprise class SQL server
- PI server with ample resources
- Linked SQL server (using PI OLEDB) on a sql express machine
My question is can having the linked SQL server on a sql express machine affect performance of my queries (because sql express is limited on the amount of RAM and CPU it can use)?
My thought is that prehaps the linked server is just acting as a pass through, so it would not effect performance, but i am seeing some performance issues and what to eliminate this as a possibility?