catronro

Does the LINKEDPI SQL server specs affect performance?

Discussion created by catronro on Sep 4, 2013
Latest reply on Sep 9, 2013 by mhamel

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?

Outcomes