Showing posts with label publications. Show all posts
Showing posts with label publications. Show all posts

Friday, February 10, 2012

Before merging,validate subscribers with this expression

Hello,
Could someone explain me what it meens.
I have made 2 merge publications with dynamic filters: suser_sname()
The first one does not validate subcriber before the synchronisation
The second one validate with 'suser_sname()'
I do not see differences between the 2 replication, and i do not exactly
understand what it means.
Thank you.
Courtoisement
Pierre-Marie PETIT
pm@.nst.fr
03 20 06 63 94
can you script out your publication and subscription and post it here?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"pm" <pm@.nst.fr> wrote in message
news:uPfNCExnEHA.3428@.TK2MSFTNGP11.phx.gbl...
> Hello,
> Could someone explain me what it meens.
> I have made 2 merge publications with dynamic filters: suser_sname()
> The first one does not validate subcriber before the synchronisation
> The second one validate with 'suser_sname()'
> I do not see differences between the 2 replication, and i do not exactly
> understand what it means.
> Thank you.
> --
> Courtoisement
> Pierre-Marie PETIT
> pm@.nst.fr
> 03 20 06 63 94
>
|||Here is the only differences between the 2 publications
(you can see that it is only here: @.validate_subscriber_info =
N'suser_sname()' Thie parameters is not in the second Tsql code)
So i do not understand what is this parameter for @.validate_subscriber_info
exec sp_addmergepublication @.publication =
N'pub_SYNERGY_Dyn_UserFilter_validation', @.description = N'Pub avec Filtre
sur le user et validation des donnes', @.retention = 14, @.sync_mode =
N'native', @.allow_push = N'true', @.allow_pull = N'true', @.allow_anonymous =
N'false', @.enabled_for_internet = N'false', @.centralized_conflicts =
N'true', @.dynamic_filters = N'true', @.snapshot_in_defaultfolder = N'true',
@.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
@.conflict_retention = 14, @.keep_partition_changes = N'true',
@.allow_subscription_copy = N'false', @.allow_synctoalternate = N'false',
@.validate_subscriber_info = N'suser_sname()', @.add_to_active_directory =
N'false', @.max_concurrent_merge = 0, @.max_concurrent_dynamic_snapshots = 0
exec sp_addmergepublication @.publication = N'pub_SYNERGY_Dyn_UserFilter',
@.description = N'Pub avec Filtre sur le user (qui ne doit pas faire partie
du compte admin de sql)', @.retention = 14, @.sync_mode = N'native',
@.allow_push = N'true', @.allow_pull = N'true', @.allow_anonymous = N'false',
@.enabled_for_internet = N'false', @.centralized_conflicts = N'true',
@.dynamic_filters = N'true', @.snapshot_in_defaultfolder = N'true',
@.compress_snapshot = N'false', @.ftp_port = 21, @.ftp_login = N'anonymous',
@.conflict_retention = 14, @.keep_partition_changes = N'true',
@.allow_subscription_copy = N'false', @.allow_synctoalternate = N'false',
@.add_to_active_directory = N'false', @.max_concurrent_merge = 0,
@.max_concurrent_dynamic_snapshots = 0
"Hilary Cotter" <hilary.cotter@.gmail.com> a crit dans le message de
news:%23cPKwUxnEHA.3396@.tk2msftngp13.phx.gbl...
> can you script out your publication and subscription and post it here?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "pm" <pm@.nst.fr> wrote in message
> news:uPfNCExnEHA.3428@.TK2MSFTNGP11.phx.gbl...
>

Because of replication The server slow down....please help

Hi...
We have a SQL Server Std Edition that make syncronisation(merge
publication) with 100 mobile device.We create100 publications according to
our employees user id.We use articles with joins and user id for all
publications.The mobile devices make syncronisation over this publications.
Problem1:When I execute an insert or update statement in database , it cost
min 10 minutes for response.Last night I execute an update sql(for 10 rows)
at night.When i wake up morning,the transaction log is get full, and only 2
of the updates make succesfully.
Why database ddl operations get a long time to execute?
Problem2:How can I control transaction log automatically?
Problem3:If I make an insert from aspx page to sqlserver the data don't send
to the syncronized users.When I create the the publication again,the data
send to the user..
If I insert the data with a query screen on the sqlserver management studio,
the data send to the synronized user.What is the difference inserting a data
with aspx page and sqlserver management studio.?
I'll wait for your answers..
Thanks...
Maybe you can setup the subscription to run on differnt time not
continously...
? "The_TOZ" <tunc@.te-mob.com> ? ? ?
news:82CEB077-8802-45BE-8D49-038D55D7333F@.microsoft.com...
> Hi...
> We have a SQL Server Std Edition that make syncronisation(merge
> publication) with 100 mobile device.We create100 publications according to
> our employees user id.We use articles with joins and user id for all
> publications.The mobile devices make syncronisation over this
> publications.
>
> Problem1:When I execute an insert or update statement in database , it
> cost
> min 10 minutes for response.Last night I execute an update sql(for 10
> rows)
> at night.When i wake up morning,the transaction log is get full, and only
> 2
> of the updates make succesfully.
> Why database ddl operations get a long time to execute?
> Problem2:How can I control transaction log automatically?
> Problem3:If I make an insert from aspx page to sqlserver the data don't
> send to the syncronized users.When I create the the publication again,the
> data send to the user..
> If I insert the data with a query screen on the sqlserver management
> studio, the data send to the synronized user.What is the difference
> inserting a data with aspx page and sqlserver management studio.?
>
> I'll wait for your answers..
> Thanks...
>
|||1) That's terrible. Are you using pre-computed partitions? Try to disable
this option. The sync times will be longer but the latency you see on each
transaction will be shorter. There probably is something else on this
database causing severe waits/performance problems - you should look at it
in depth to understand it
2) Put it in full recovery model, and backup the tlog as frequently as
possible - 20 minutes is normally good enough. Also make sure you growth is
in megs not %.
3) There should not be a different between how the client gets the data. The
only problem that can occur is if the insert comes from a bcp operation. Are
you including a guid for the GUID column replication is using - normally
called rowguid? You should let SQL Server autosupply this value.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"The_TOZ" <tunc@.te-mob.com> wrote in message
news:82CEB077-8802-45BE-8D49-038D55D7333F@.microsoft.com...
> Hi...
> We have a SQL Server Std Edition that make syncronisation(merge
> publication) with 100 mobile device.We create100 publications according to
> our employees user id.We use articles with joins and user id for all
> publications.The mobile devices make syncronisation over this
> publications.
>
> Problem1:When I execute an insert or update statement in database , it
> cost
> min 10 minutes for response.Last night I execute an update sql(for 10
> rows)
> at night.When i wake up morning,the transaction log is get full, and only
> 2
> of the updates make succesfully.
> Why database ddl operations get a long time to execute?
> Problem2:How can I control transaction log automatically?
> Problem3:If I make an insert from aspx page to sqlserver the data don't
> send to the syncronized users.When I create the the publication again,the
> data send to the user..
> If I insert the data with a query screen on the sqlserver management
> studio, the data send to the synronized user.What is the difference
> inserting a data with aspx page and sqlserver management studio.?
>
> I'll wait for your answers..
> Thanks...
>