How do i measure bandwith usage for merge replication SQL 2005 to Sql server mobile 2005?

Hi,

Is there any way to measure bandwith usage during merge replication between sql server 2005 and sql server mobile 2005 running on a cradled wm5 mobile device.

Attaching the windows performance monitor to the network connection established over usb would work although I was wondering if there was something specific for this case integrated into Sql server 2005 / sql server mobile 2005 / Sql server management studio / third party tools that i could use ?

thnx,

pdns.

Not for mobile, but if you had a SQL Server subscriber (Dev, Ent, Std, Express) you can add (unsupported) merge agent parameter "-T 101" which will give command-line output statistics for that particular sync, there might be some net statistics IO output which is not always accurate unfortunately.

However we can take this into consideration for hte next release of SQL Server, although I cannot make any guarantees.

|||

can u tell me full command syntax that how we could use it on command line

thanxs in advanc

Ahmad Drshen

|||Search BOoks Online for topic "Replication merge agent", you should see the command line utility topic. YOu can also drill down into the agent job steps to see the exact parameters and values that your job is using to execute a push/pull merge agent.

How do I drop sql server mobile database when ...?

How do I drop sql server mobile database at specifical time in my application in PPC?

And, How do I drop it when user input the worng password third times in my application in PPC?

Thank you very much.

Simply delete (or open and fill with junk) the database file at particular time or after user entered incorrect password too many times.

|||

I mean How do I trigger the event?

if (sysdate>'01-may-2006' )

{

//Simply delete (or open and fill with junk) the database file

}

Is that right?

|||As far as I know SQL Mobile does not support database triggers. You have to perform this operation from your application instead.