Viewing 15 posts - 1 through 15 (of 21 total)
So I wanted to post what we found in case this helps anyone in the future. In this particular case, the clustered unique index includes a date field. ...
February 27, 2015 at 7:48 am
Are you considering Schema changes? Data Changes/Fixes? Stored procedures? Any particular focus, or any/all of the above?
May 3, 2014 at 12:19 pm
The following select statement will scan fn_dblog and construct the sp_repldone statement for each individual command in the log that is marked for replication. It converts PreviousLSN and CurrentLSN...
April 24, 2013 at 7:40 am
Thanks, Alex. I've seen many of those resources, as well as Jonathan Kehayias's excellent material. But I was looking for some resources about cpu usage in particular. ...
February 25, 2013 at 11:32 am
The other thing to think about is that email isn't really a successful alert system unless it arrives, and there are a whole host of issues that can prevent an...
December 13, 2012 at 10:18 am
You can have a job at the publisher insert a tracer token periodically. If it doesn't arrive at the subscriber have a certain amount of time, the job can...
September 28, 2012 at 10:12 am
You should be able to compare the replication stored procedures in the subscribers to see what is different between those that are working and those that are not.
August 24, 2012 at 8:07 am
You could also put the delete statements in a procedure on SUB, and then, publish the execution of the stored procedure. On MAIN, write the procedure so that it...
January 31, 2012 at 10:00 am
Hi Gary, I tried adding a Write-Host $event.Message to the catch block, but when I include the MessageEventHandler, the catch is not invoked. When I remove the Handler, there...
January 31, 2012 at 9:20 am
Yes, we were doubtful there was something so simple, but we thought we'd ask.
In our particular case, the issue was with our custom replication procedures incorrectly treating a new computed...
August 21, 2011 at 8:46 am
looks to be a windows permission item. The proxy user needs to have write access to where you are creating the log file.
July 21, 2011 at 3:45 pm
our replication setup created a proxy in the "Replication Transaction-Log Reader" category, with a name like:
[REPL][<Domain Account>][<Job Name>]
That's what shows up in the "Run as" portion of the Run agent...
July 21, 2011 at 12:41 pm
You can also go after the data files, summing the number of 8K pages used and converting to your unit of choice (MB in this example):
select sum(fileproperty(df.name,'SpaceUsed'))*8./1024.0 as 'Space Used...
June 2, 2011 at 4:48 pm
That resulting in a syntax error around the EVENTDATA().node construct.
We were able to get around this by switching to an openxml command:
DECLARE @data XML
SET @data = EVENTDATA()
declare @idoc int
April 1, 2011 at 12:35 pm
This is interesting. I freed the proccache and then ran the query without the recompile hint. The full output is
SQL Server parse and compile time:
January 13, 2010 at 2:22 pm