Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transactional Replicatoin in SQL 2005, with Full Text Catalog enabled and using full text search using contains Expand / Collapse
Author
Message
Posted Friday, July 19, 2013 5:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, March 07, 2014 12:29 AM
Points: 330, Visits: 948
Please help in this.

i have a scenario in AWS Cloud,

The SQL DB Server is with below configuration.

SQL Server 2005 with Service pack 1 and 8 GB RAM with 2.99 GHz Windows 2003 Server 64 Bit with Service pack 2.

we are using sql server 2005 which has Full Text Catalog enabled and trying to search certain keyword matches. This DB is enabled with SQL Replication and this is the DB which is pointing for application, this db is replicated to another server (zone) with Transactional Replication. While searching the keywords with SQL server replication enabled the SP execution is taking 1.5 minutes where as after disabling the replication or removing the replication it took nearly 30 seconds and due to the time consuming of the SP, CPU and PF Usage of the SQL Server was going high and search was not happening. SO kindly help me what needs to be done.

With Regards
Dakshina Murthy
Post #1475398
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse