SQL Replication via Groups very Slow
-
Tuesday, May 22, 2012 2:57 PM
We have this forest/domain. The DC and SQL Server running cubes sit in one zone/extranet and the Sharepoint 2010 sits in the DMZ Zone on the internet. SQL and SP2010 is member of this domain. Both seperated by a firewall.
Issue: When we a create a new AD user and add it to a group which has access to the Sharepoint Site and to the appropriate Cubes ..it takes about 1 hour before that user can access his/her SP Site page and about 4 hours before they can access the cube/report/dashboards.
And IF we do not add the user to a group and just simply assign them access directly to the SP Site and the Cube it works right away.
Cannot seem to find out whats different when they are added to the Groups???
Any !deas guys???
Thanks Much.
All Replies
-
Wednesday, May 23, 2012 2:58 PMModerator You need to determine where it is slow. In Replication monitor, drill down on your publication on the left hand side. Then on the right hand side you should see a tab called Transaction tokens. This will help you to see if the problem is with the log reader agent or the distribution agent.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marked As Answer by Stephanie LvModerator Monday, June 04, 2012 7:43 AM
-
Thursday, May 24, 2012 3:07 PMIt must be definitely to do with the caching involved at the DNS or network layer which is not reflecting the change immediately. Try flushing the DNS cache to see if this helps.
Thanks, Adi
.png)
