I am using Win Server 2008 R2 / SQL Server 2008 R2 and i am trying to add about 2K + articles to the existing publication and the screen hangs @ the articles screen.
The screen has been there and hanged since 12 hours ago .
Based on the server spec : 256GB Ram with loads of core and threads, running on SSD/SAS.
it's highly unlikely due to hardware, it has to be due to some bug in the software.
When such scenario happens, what should I do to rectify or analyze the problem ?
Did some script via
sp_addarticle but it still takes around 40 seconds per article.
I in fact have over 6k articles.
Sample script I used :
EXEC Sp_addarticle @publication = 'DB_live_Pub', @article = N'vw_AuditLog', @source_owner = N'dbo', @source_object = N'vw_AuditLog', @type = N'view schema only', @description = NULL, @creation_script = NULL, @pre_creation_cmd = N'drop', @schema_option = 0x0000000008000001, @destination_table = N'vw_AuditLog', @destination_owner = N'dbo'
Update 2 :
I killed the job, stop all related agents, drop all publications, drop all subscriptions, Recreated new subscription from scratch. Surprisingly, everything speeds up fast. I managed to create 5k+ Articles in 2 hours. After that i proceed with the snapshot, after some error debugging, managed to create a snapshot.
Now i am creating a subscription to the publisher.