Forum Replies Created

Viewing 12 posts - 1 through 12 (of 12 total)

  • RE: Can starting a snapshot cause blocking?

    There is an option in the snapshot generation that 'Do not lock table'.  Not sure if it work.

    Does anyone use his option? and does it work? Checking this option, SQLServer...

  • RE: reinit merge pull article.

    I don't think you can re-iniytialize an article for a PULL subscription. Check out the command line parameters.  One can apecify Article in Push not in Pull.

    Good Luck!!

  • RE: CPU utilization

    Below explans this counter: (<10 is considered OK)

     

    Processor Queue Length is the number of threads in the processor queue.  Unlike the disk counters, this counter counters, this counter shows ready...

  • RE: 3rd Party database with weird indexes?

    Check to make sure which file group the index(es) were created.  That may be reason you don't see them in EM. (they are in a different file group).

    Good Luck !!

  • RE: Performance tuning for ETL

    Extend your file group before loading large amount of data.  Extending datafile during the loading process is very slow.   For ETL, If the data require further processing, it is alway better...

  • RE: Merge Replication error could not deliver snapshot

    Check the profile in the publiscation database on the articles.  looks like it is trying to re-create your articles (tables).

    Good Luck !!

  • RE: High keys and replication

    What replication mode you are using - transactional or merge? Merge replication have to resole key value confict.

    Good Luck !!

  • RE: Question about High Availablility Configuration

    If your users cannot tolerate more than a handful of minutes.  Lomg ship is not a solution.  I would consider the followings:

    1. SQL Cluster locally (with disk mirroing etc) for High...

  • RE: One of two subscribers not in sycn

    Craete a user in the subscription DB with readonly access.  Change the existing devloper access users' password.  All developer should only have read-only access.  The SPs have to update to...

  • RE: SOA (multiple database)

    If one is implmenting applications for different client of similiar business and out them all in one DB. You are putting all eggs in one basket (single point of failure...

  • RE: Error using ''''Do not lock tables during snapshot generation''''

    We are on 'Microsoft SQL Server  2000 - 8.00.2040.'  (i.e SP4). I was not allow to post company scripts and schema without approval.  We are using transactional replication without filtering...

  • RE: Log Reader Rolling Back

    Change the Query time out for the logreader's profile.  default is 300 sec.  Increase it to a value that stop the timeout error.

Viewing 12 posts - 1 through 12 (of 12 total)