…….Replication……. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

…….Replication…….

We have running ACCPAC on our 2node clustered machine. 100-130 concurrent users access the database (SQL Server 2000).
Hardware configuration
Users who make entries have no complaints but the users who work with reports, have complaint for slow reponse, even when they search some an item they claim it takes long time to response. Now I want to split reports from our production server. Let me know what should I do?
Do I need replication if answer is yes then what kind of? or other possible solution. Thanks
Aman
DBA
Chenab Ltd
How about log shipping, its easy, reliable and ideal to setup. I will not recommend Replication setup on above of cluster, not that it will not work but more hassle to maintain. Refer to books online andhttp://www.sql-server-performance.com/sql_server_log_shipping.asp link about setting up LS. And this linkhttp://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/en/wc021501/wct021501.asp too. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Another good option (although it will take a lot of work) is to create a cube using Analysis Services and have users report off of it. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com
Thanks Satya…I go through those topic then will discuss with you. Aman
DBA
Chenab Ltd.
Another handy linkhttp://www.sql-server-performance.com/articles_clustering_log_shipping.asp by Brad about clustering and log shipping. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |