.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Replication Monitoring Questions

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
We have a pretty extensive replication topology at our organization. The
publications are 99% transactional with a couple of snapshots thrown in for
articles that do not change very often. these are used for some mission
critical BI processes, so making sure they are in sync is one of my top

I am finding it pretty much impossible to ensure that everything is up to
date without manually opening each publication/ subscription in replication
monitor and verifying that the flow of transactions is behaving properly.
This process takes literally hours for me to complete. I had created a job to
run sp_publication_validation against all of the publications coupled with
alerts to email me when validation failed, and this seemed to be working fine
until this morning. During my morning checklist routine, I found two
publication marked as "Critical Performance," with each having 57 seconds of
latency. When I opened the Distributor to Subscriber History tab, I found
both had a status of "Initial snapshot is not available," and apparently had
not been updating properly for roughly a week. My job did not pick these off
as failing validation. I manually ran a subscription validation against both,
and no results were ever returned.

My question to

View Complete Post

More Related Resource Links

Merge replication performace questions


I believe I’m having performance issues with my merge replication setup.  The reason I believe I’m having trouble is because the progress bar shown in the details window of the subscription, shown in replication monitor, doesn’t get up to 100% for download/upload completion, in fact it usually slowly goes down while the approximate time remaining goes up.  When I look at the Synchronization Status on the subscriber, the blue bar underneath the “Last Status Message” doesn’t go the whole way across.

When I validate the subscription, validation fails for a number of tables but that is what I expect to happen because in order to validate, I need to stop the subscription from continuously updating so I can restart the synchronization in order to get the validation results.

Here is my setup: Server A has 2 quad core Intel (X5460) 3.16GHz CPUs, 32 GB of RAM and a Gigabit Ethernet card.  Server B has 2 quad core Intel (E5530) 2.40GHz CPUs, 24 GB of RAM and a Gigabit Ethernet card with a Gigabit switch between the two servers.

The merge agent profile is using the “High Volume Server-to-Server Profile”.

I am trying to get one publication from server A to server B using a pull subscription which is polling every second.    

General replication questions - SQL Server 2008 R2


First, can SQL Server 2008 R2 replicate to SQL Server 2008 R2 Express Edition???

Second, I have setup replication from R2 to a SQL Server 2000 database.  I defined a stand-alone table (not a parent or child) and replication worked fine.  I simply changed a record and it was reflected in the 2000 database.

Next, I changed the table to be replicated to be a parent table.  After I changed a record in this table, replication failed.  The error message said it was unable to drop a table because it was in a relationship.

Questions.  When replication occurs between a publisher and subscriber and several records in a table targeted for replication, is the table dropped in the subscriber database then copied over in its entirety???  When I define a table to be replicated, do I have to include all the related tables???



ROWGUID in Merger Replication - Newbie questions


I am a newbie in MS SQL Replication. This is long story for your BlackBerry. I hope you can read and understand my story below.



Publisher: Windows XP & MS SQL 2008 Standard, Customer maintenances EXE Application.

Subscribe: Window XP & MS SQL 2008 Express, Customer maintenances EXE Application.

  I only have Customer maintenances EXE file and I have no application source code.

  Both publisher and subscribe CUSTOMER table will be update by different people and different location.


Problem: for example

In publisher, Table Customer have 3 clients Mr. A, Mr. B, Mr. C.

In subscribe, Table Customer have 2 clients Mr. A, Mr. D


As you know a ROWGUID will add to the tables in merger replication. After the first synchronization, then I execute the EXE application to reads the Customer table, doing some add or delete customer to tables, then the program hang.


Replication monitoring



On replication monitor publisher is not in connected status.when i am trying to add publisher it is giving message like it was already in connected status.And then i tried to connect distributor then i am getting message

login failed for user .the user is not associated with a trusted sql server connection :error 18452

Authentication mode is in mixed mode.but still i am getting this error.

We are using sql server 2005,standard eddition.

So please help on this issue..

Thanks in Advance..



Replication Monitoring Tools


Hi, Can anyone suggest a Replication Monitoring Tool? We have like 200 servers to monitor. Its been very had for us to manage replicatoin in Replication Monitor. I m looking for something that gives us better view of the Replication flow like Errors, Latency etc..


Thank you

some questions about 2005 merge replication



We have 2 servers with 2005 merge replication setup and we have some questions about it:

1.) The database grew up about 55GB data(since most of them are binary image data) and log alternatively and we want to change from Full recovery mode to Simple recovery mode to reduce log size. Do we need to drop and create replication again or simply change the recovery mode is enough? Any other procedures we need to follow?

2.) The snapshot(run once about 2 weeks) job run about 3 to 4 hours. As this job drew all the resources while it's riunning and severely affect other transactions, we want to reduce it's running time. How about rebuild the index for replication system tables(e.g. msmerge_content) and how much gain by this action? Any other suggestions?

Thanks and regards,


C# Interview Questions

C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.

There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

Linq qry with order by basic questions


I have never tried a group by with linq, now I do and I'm stuck.

I try to convert this sql statement to its linq counterpart :

SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id

Is there some one who can me show me the convertion process ?

Questions about getter and setter


I created a getter and Setter in Visual Basic. I have some questions though. Please look at the code below.
Here are my questions.

A.) At line 1 below, should "pieces" be declared as Private?
B.) In the IDE at lines 4 and 7 the IDE keeps changing those variables to uppercase so that the property name "Pieces" is the
    same as the variable name "pieces".Should I instead define the integer pieces with an underscore: _pieces ?
That is the only way I can get around the IDE forcing the variable to become uppercase.


1  Dim pieces As Integer

2  Public Property Pieces() As String
3  Get

4  Return pieces
5  End Get

6 Set (ByVal values As String)
7   pieces=value
8 End Set
9 End Property

SharePoint's Sandbox: Developing, Deploying and Monitoring Sandboxed Solutions in SharePoint 2010


The challenge in SharePoint development has always been the balance between creating and deploying solutions that you can trust not to damage or impair a SharePoint farm. A new feature in SharePoint 2010, called Sandboxed Solutions, enables farm administrators to feel comfortable that the SharePoint farm is safe, gives site collection administrators the authority to manage applications in their site collection, and provides developers with the flexibility to create solutions they know will be deployed in a safe and rapid manner.

Paul Stubbs

MSDN Magazine November 2009

C++ Q&A: Performance Monitoring, Managed Extensions, and Lock Toolbars


In the June 2004 issue of MSDN®Magazine, I described a class called ShowTime that you can use to do simple performance monitoring for your app. ShowTime uses its constructor/destructor to record the start/stop times of its existence so you can instantiate it in a block of code like so: { ShowTime st(_T("Total time is:")); // some lengthy operation } .

Paul DiLascia

MSDN Magazine September 2004

Redirect to Security Questions if Site accessed from unrecognized computer?


I'm fairly new to ASP.NET and i'm using the Membership Provider.  I have the need to do similar to some banking sites. Baically I need to track "authorized" computers/ip's for a user.  If the user accesses the site form a recognized Computer/IP then the user is allowed into the app after successful login.  If the computer/IP is not recognized I need to redirect them to a screen to answer the security question setup in fhte Membership Provider.

Has anyone done anything like this or can anyone point me to any examples?  I did a search, but can't seem to find anything.

My idea is to maintain a list of authorized computers/IP addresses and check them on initial login.  If the IP address isn't found I can redirect them to the questions.  My concern is that they are then actually authenticated and could enter any of the site URL's as an authenticated user.

Any suggestions greatly appreciated. 

This forum is ONLY for accessibility questions about the physically challenged

Nothing more. A mistake was made when changing the description of the forum when adding the 2010 information.
FAQ sites: (SP 2010) http://wssv4faq.mindsharp.com; (v3) http://wssv3faq.mindsharp.com and (WSS 2.0) http://wssv2faq.mindsharp.com
Complete Book Lists (incl. foreign language) on each site.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend