.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

STSADM ActivateFeature takes too long

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint


I have a solution installed to a web application, this Web App has a lot of Site Collections, these site collections were created with different versions of the wsp package. What I need is a way of activating the new features on the already provisioned site collections.

At first we made a Web Application scoped feature that went through all site collections that were using our template and then activated the features on each site collection but it was giving us a whole bunch of trouble were the code would skip entire site collections or enter the site collection, changing a field that we used for control and not activating anything... Now we have a Web scoped feature that activates all the features within the site collection at either Web or Site scope that we specify through an XML. This works like a charm for every site collection.

The problem is that we need a way of activating that feature on every site collection so I did a batch file that runs the STSADM ActivateFeature to do this. This also works properly but seing the many site collections that we have it is taking more than an hour and a half to finish the batch; is there a way of optimizing this so it runs quicker?

I think that the batch is actually waiting untill the feature is done activating to start to activate the feature on the next site collection, is there a way of a

View Complete Post

More Related Resource Links

WCF Service: takes very long time to start up

Hi, What could be the reasons, why my WCF service takes up to 40 seconds to get started? My service class is set to [ServiceBehavior(InstanceContextMode = InstanceContextMode.Single)] I am running a thread inside this class. The WCF service gets initialized and opened within the context of this thread. The Initialization: private void InitializeWCFService() {      // initialize servcie base addrresses      this.SetupBaseAddresses();      //MetaData behaviour : allow HttpGet      ServiceMetadataBehavior metaDataBehavior = new ServiceMetadataBehavior();      metaDataBehavior.HttpGetEnabled = true;      // initialize service host instance      this.seviceHost = new ServiceHost(this, this.httpBaseAddress, this.tcpBaseAddress);      // add service endpoints and behavior.      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Tcp), EndpointName);      this.seviceHost.AddServiceEndpoint(typeof(IUpdateServer), this.GetServerBinding(BindingType.Http), EndpointName);      this.seviceHost.Description.Behaviors.Add(metaDataBehavior);      // MEX endpoint      this.seviceHost.AddServic

Why does it takes such a long time to load a parameter?

Hi all,   I have a parameter which is filled with a set of about 90.000 rows. When running the report, it takes a long time to view the report. While it loads the report the CPU on the client is getting up with 50% and the memory stacks 300 MB. I think that I am doing something wrong as when I run the query directly at the cube, it takes just 9 seconds. Does anybody have coped with this problem? If so, what are the best practices in this? Your help will be greatly appreciated! Daniel

Full database backup takes so long

Today several full database backups took so long. Normally it took 2 hours to backup. But today the 5 backups didn't finish by the end of the work day. The backups went well until yesterday. I don't know what happened overnight. Is there a performance tool embedded in SQL Server? How can I find out why the backups take so long? What could be the possible reasons? Thank you,  

Query takes too long to run

I have the following query, which does an update statement but everytime I run it it took about 1hr and 20 mins to run so I created Indexes because that would solve the problem. After creating the Indexes I re-run the query but it was the same so I checked to see if it was blocked by running the following query and under the spid it had the same spid in under the blocked column, the lastwaittype is PAGEIOLATCH_SH. UPDATE table SET column1 = column2 FROM table1 JOIN table2 ON column1= column2 Thank you

Query takes too long to run

I have the following query, which does an update statement but everytime I run it it took about 1hr and 20 mins to run so I created Indexes because that would solve the problem. After creating the Indexes I re-run the query but it was the same so I checked to see if it was blocked by running the following query and under the spid it had the same spid in under the blocked column, the lastwaittype is PAGEIOLATCH_SH. UPDATE table SET column1 = column2 FROM table1 JOIN table2 ON column1= column2 Thank you

Query takes too long to run

Every time I'm trying to run a query it is taking too long to run the simplest query, in order to run the queries, I have to go to the Activity monitor and kill off processes that have been sitting even though they are not running. Is there a way the processes can be killed off when they have finished executing?

Thank you

Closing a WCF connection takes a long time when using SSL


I have a very puzzling problem closing WCF connections. We utilize several different protocols for different customers. The most common is net.tcp. We now have a customer that requires SSL encryption of their WCF calls. It does seem to work, but exhibits some strange behavior when we close the connection.

Closing the connection takes a long time. This could be caused by any number of problems, but the strange thing is that the more data that was transmitted on the connection, the longer it takes to close. Connections that get a small amount of data close reasonably fast, but if a large amount of data was transmitted, closing the connection can take as long as actually retrieving the data. It almost seems as if the data is being retransmitted back to the server for verification before the connection is closed.

We are using reliable sessions and Binary over HTTP protocol.

ALTER DATABASE AdventureWorks SET ENABLE_BROKER takes too long to finish, how long does it run

try to run ALTER DATABASE AdventureWorks SET ENABLE_BROKER ;
but still running after 8mins, is this normal, what is approximate time? can it be cancelled?

SSIS - OLE DB from VIEW takes long time



I have a question regarding SSIS 2008 and how it handles views. I hope the answer for this question will be a quick "Get a hotfix" heh.


I am experiencing a very odd behavior with setting up a View as a data-source in OLE DB. I have set up a a very simple package (for experimenting) with a Data Flow Task that has only two components, Data-Source and Data-Destination. I have set the data-source to a view and the destination to a table in the same database.

Note: I am developing the package on the server itself.


  • While trying to preview data-source I get an error, "Query Timeout expired (Microsoft SQL Server Native Client 10.0)
  • When executing the package Validation, Pre-Execute phases are complete but no rows are passing through the buffer. I have waited over 12 hours before stop the job. Checking the monitoring verified that IO was on 1. And that no object was locked , which may have caused the package to run so long or not to retrieve data.
  • When connecting to SSMS and doing export of data from the view - it also retrieves no data and the process seems to be stuck.


Additional data:

  • T

first login takes a long time


hi all,

i have set up a moss site, and i notice an interesting thing that the first login of every day usually takes a long time, while subsequent logins of the same day  take  much less time. what could be the problem? is it related to caching behavior?

any suggestions on how to improve the response speed?


Andrew Chen
BI, Data Mining, Analytical CRM

SQL Server 2005 Database recovery takes long when starting


I have a large database which is consistently taking between 30 and 60 minutes to come up after restarting SQL Server.  How can I speed this up?  Please read below before responding.

I have a Winows 2003, 2 node cluster running 1 instance of SQL Server 2005 enterprise ed.    The server has 64GB of RAM, and 4 Quad core chips (16 logical processors).  The storage is on SAN, and is a mix of RAID 10 and RAID 5 volumes.  The instance has multiple DB's in it but 1 is far and away the largest @ 2TB allocated (about 1TB actual data).   The database in question is broken into many datafiles as follows:


Primary filegroup = 1 10GB datafile

Secondary filegroup = 8 x 100GB datafiles spread evenly over 4 seperate volumes for I/O performance.

Partitioning filegroups = many many files used for a partitioned table (file sizes ranging from 1.5GB to 20GB)

Again, my issue is the following.   This 2TB database takes close to an hour to startup everytime the instance of SQL Server restarts, failsover etc...  

Couple of notes:

1) We have instant file initialization configured

2) Recovery model = simple

3) Recovery interval = 0

4) There are no active large transactions running when the instance goes down


Why WPF bug fixes takes so long time?



Why the feedbacking takes so long time to get official comments? I'm not speaking about getting the issues to be fixed as it takes even more.

The perfect sample:


It is a known bug for a three years (there is a link to a first discussion in a feedback comment), and the offical answer is:

Posted by Microsoft on 8/21/2009 at 2:35 PM
I do understand your concern, but we are beyond our ZBB date, therefore only ship-blocker bugs make the bar at this point. Considering that we have shipped this bug before, it is hard to make a case that we need to fix it in this release since it did not block our previous release. Thank you.

So, the official policy is "Now, we have a six months before RTM but we will not fix any bugs but those that blocks tth product shipment"? Perfect!

I've a bunch of bugs/suggestions submitted and (for most of them) there's no single comment neither reaction for a six month for now. I'm

Update takes too long - Very Large table update


I have 2 tables Fact_Bill(25 million rows) and Dim_Claim(2 million rows).Relevent columns: Fact_Bill(sk_Bill Int, Claim_Code Varchar,sk_Claim_Key Int) , Dim_Claim(sk_Claim_Key Int, Claim_Code varchar). All the mentioned 5 columns has independent non clustered index. I am doing a Update to Fact table in batches.

sk_Bill in Fact_Bill is an identity column

While (Taking 100,000 records by giving a condition to sk_Bill in fact)

        Update Fact_Bill Set sk_Claim_Key=C.sk_Claim_Key From Fact_Bill Inner Join Dim_Claim C On Fact_Bill.Claim_Code=C.Claim_COde Where Fact_Bill.sk_Bill =@batchRowcount and Fact_Bill.sk_Bill @batchRowCount - 100000.

My problem is the query is running very long , i stopped after 10 hours. Can anybody suggest some tips to increase the performance. Thanks

Bineesh Thomas

SQL Server 2005 Restore a 110G database takes too long


Hello ,


I am not sure this is the right place to ask SQL Server restore question or not.

If not, please move my question to the related forum.

My question is: I have a database around 110G, I'd like to restore to my test environment, but it takes me around 7 hours to restore. Is it normal? how can I make the restore faster?

WorkflowApplication.Load takes a long time


When I load a persisted WF instance, I can watch a profiler of the DB activity.  From the time I step over .Load until I see the LoadInstance stored procedure execute is taking anywhere from 5 to 10 seconds.  Is there a way to alter this behavior?

Here is how I am creating the Instance Store:

 public class WorkflowLoader : IDisposable
  public SqlWorkflowInstanceStore InstanceStore { get; private set; }
  InstanceHandle mInstanceHandle;
  private string mConnectionString;

  public WorkflowLoader(string connectionString)
   mConnectionString = connectionString;

  public WorkflowApplication CreateInstance(Activity activity, IDictionary<string,object> inputs)
   // if we dont have an instance store, then we have been disposed already

SqlCeConnection.Open() takes very long time


SqlCeConnection.Open() takes very long time if the sdf file is more than 300MB, actually, SqlCeConnection.Open()  will not response in Windows Mobile 6.5 device, but it works in Windows 7.

string connectionString = @"Data Source=\Navigator\tnmsdb_DISTRICT-00001-00008-00017.sdf;Max Database Size = 280";

ASP.NET Workflow: Web Apps That Support Long-Running Operations


Integrating workflow into ASP.NET applications means communicating with activities via a workflow queue and hosting the runtime in the global application class. We'll show you how.

Michael Kennedy

MSDN Magazine January 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend