Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question

migrated from stackoverflow.com Nov 26 '11 at 19:55

This question came from our site for professional and enthusiast programmers.

    
This is really not the right site for this question. –  Andrew Barber Nov 26 '11 at 11:31
    
    
Is my answer sufficient? –  RMacy Dec 26 '11 at 0:39

3 Answers 3

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.

share|improve this answer

One easy way to do it is get the data in a dataset, and export it to xml (or excel 2010 for ease of use) and have a look at the file size. The other way is to have a look at the firewall log ( if you are using a separate port or url for connection).

share|improve this answer
    
When Sqlserver is doing some join operations as like as inner join or left join and etc with remote tables,I suppose it transfers the other data in spite of data which is transfered with update and insert. I want to calculate it too. –  Raymond Morphy Nov 27 '11 at 5:23

You're pretty much going to have to use networking tools to do the monitoring. Another option is to query the size of the tables involved directly on the linked server and that will give you a rough estimate. If you're joining across linked servers, all the data must be brought over, then filtered down, so you're probably transferring a lot more data than you think.

share|improve this answer
    
What networking tools can I use? –  Raymond Morphy Dec 9 '11 at 7:08
    
Unfortunately, I won't be of much help on that question. –  Eric Humphrey - lotsahelp Dec 9 '11 at 14:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.