Viewing 15 posts - 331 through 345 (of 1,790 total)
Krasavita (2/18/2011)
How would I know it is runnning? I have all the info now
If you see that agent running in sysprocesses on the subscriber then it is running. Next step...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 1:26 pm
You need to pick one of the tables that is not replicating and put that in this query to find out the publication name;
selectsp.name
fromsyspublications sp inner join sysarticles sa...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 12:11 pm
Can you check this link - http://www.mssqltips.com/tip.asp?tip=1269
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 11:48 am
**Note, you have to change the server name in that script as well. Thanks!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 11:36 am
Krasavita (2/18/2011)
SELECTmda.name AS distribution_agent,
mp.publication AS publication_name,
mda.publisher_db AS publisher_database,
job_id,
job_step_uid
FROMMSdistribution_agents mda INNER JOIN MSpublications mp
ONmda.publication = CASE
WHEN mp.independent_agent = 1 THEN...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 11:35 am
I would agree that you definitely look IO bound and would make that the priority in this case. I wouldn't be at all surprised if you are having difficulty completing...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 11:20 am
You did replace the "YourPublisher" with your publication server name correct? Just making sure.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 11:11 am
A couple things here. You could set up a trace with the distribution agent job name as a filter in the trace to see if there are any commands...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2011 at 7:29 am
From - http://technet.microsoft.com/en-us/library/cc966545.aspx - which is a good read.
Query
Triggers
Snapshot isolation and read committed snapshot (RCSI)
MARS
Online index creation
Temporary tables, table variables, and table-valued functions
DBCC CHECK
LOB parameters
Cursors
Service Broker and event notification
XML...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 12:20 pm
john.kaye (2/17/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 9:39 am
I had only thought of this approach due to some tempdb analysis that I was doing and I found something similar on a blog post from SQL Soldier. I can't...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 9:25 am
I guess I am wondering how populated the columns are. I see that you allow NULLs so wondering if they are mostly NULL at this point or is there actually...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 8:54 am
magasvs (2/17/2011)
You can find cache size for the objects with this query:
Nice! Did you write this or did you find it somewhere? I started writing something like this last night...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 8:48 am
oskargunn (2/17/2011)
Didn´t make a difference :/
Are your text columns mostly populated or are they mostly NULL at present?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2011 at 8:04 am
Can you check out Web Synchronization for Merge Replication and see if that will work?
If not let me know as I have a really clunky idea that might work....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2011 at 9:31 pm
Viewing 15 posts - 331 through 345 (of 1,790 total)