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 |
|
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 |
 |
|
|
|
|
|
Linked server