snippetsqlMinor
How to monitor how much data is transfered in a linked server?
Viewed 0 times
muchhowtransferedlinkedmonitorserverdata
Problem
I have a linked server to a remote computer and doing some insert, update and delete operations between local and remote databases.
I want to know how much data is transfered when operation is doing. How can I do it?
My local database is Sql server 2008 and remote database is SQlserver2ksp3
I want to know how much data is transfered when operation is doing. How can I do it?
My local database is Sql server 2008 and remote database is SQlserver2ksp3
Solution
This sounds like a job for PERFMON, which is included with the latest windows server offerings.
http://technet.microsoft.com/en-us/library/cc749249.aspx
Basically you're going to setup a counter to watch the MSSQL data transfer between the servers.
You may be able to use a counter inside of MSSQL to track this as well, but I'm not familiar with any functionality that provides that.
http://technet.microsoft.com/en-us/library/cc749249.aspx
Basically you're going to setup a counter to watch the MSSQL data transfer between the servers.
You may be able to use a counter inside of MSSQL to track this as well, but I'm not familiar with any functionality that provides that.
Context
StackExchange Database Administrators Q#8422, answer score: 2
Revisions (0)
No revisions yet.