Search Results | SQL Server Performance Forums

Adding a article causes ALL articles to be refreshed/reloaded

Post by: ac_786, Sep 6, 2007 in forum: SQL Server 2005 Replication

As soon as I execute the first statement (sp_addarticle) I get the error: Cannot make the change because a snapshot is already generated. Set...

Adding a article causes ALL articles to be refreshed/reloaded

Post by: ac_786, Sep 6, 2007 in forum: SQL Server 2005 Replication

I looked at Properties of the Publication, Subscription and all articles and could not find any property that could be set to ensure that the...

Adding a article causes ALL articles to be refreshed/reloaded

Thread by: ac_786, Sep 6, 2007, 11 replies, in forum: SQL Server 2005 Replication

I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I...

Testing Performance: How can this ever happen ?

Post by: ac_786, Apr 30, 2004 in forum: Analysis Services/Data Warehousing

Also, in this case, which performance counters would you recommend paying attention to ? Amir

Testing Performance: How can this ever happen ?

Post by: ac_786, Apr 30, 2004 in forum: Analysis Services/Data Warehousing

Hi Steve, Thanks for the detailed response. I will check into the network and performance counters. I am tracking the time programatically and the...

Testing Performance: How can this ever happen ?

Post by: ac_786, Apr 29, 2004 in forum: Analysis Services/Data Warehousing

No. No one is using the cubes except my process. But the RPT server is a reporting server where there are other applications being run. But when I...

Testing Performance: How can this ever happen ?

Thread by: ac_786, Apr 29, 2004, 11 replies, in forum: Analysis Services/Data Warehousing

Hi all, I have the same Analysis services database on three different machines (including my local machine). Somehow the fastest machine (which is...