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.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Linked server

Author  Topic 

duongminh83
Starting Member

1 Post

Posted - 2014-06-06 : 23:50:55
Hi all,
I hace some question about Linked Server
For example:
I have two Database, 1 for DB2 (23), 1 for Sql 2012 (71).
I created a linked server from (71) to DB2 (23).
Question is:
When I run a querry from (71) such as:
Select * from (23).[database].[table]
How to Process this time on both servers? It means What (71) processes, what (23) process?
Thank for All

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-06-07 : 02:10:53
On the DB2 - you could use Statement event monitor - which returns various metrices per statement. On the SQL Server - you could use various DMVs or Profiler.
Is this a one-off for troubleshooting or do you want to set up something as a regular monirtoing procedure?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -