Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have TFS 2010 setup and we are using Visual Studio 2010 Ultimate. During bulk edit (publishing) of work items using Excel frezes everything for 5 minutes.

Data Tier have 16 gb of RAM and both app tier and build tier has 8 gb RAM.

It happens when it is accessed by TFS Web Access and VS both.

Could you please suggest

share|improve this question
    
Does it happen if you use a different client machine to do the bulk edit? What version of Excel? Use MS update to update Excel. –  Tim Elhajj Jul 18 '12 at 15:45

1 Answer 1

Here are the first things I would consider to solve this:

Large lists of options in work-item fields/drop-downs, especially lists of users. Have a big company? By default your Assigned To field will show all users who have access to the team projects. This could be a VERY large list that will take time to load and work with in Excel. Solution: Limit the users shown in the drop-down to only the ones required. I found this blog post that has the steps for you.

Anti-virus? I've found anti-virus to be an issue with some clients I have; more specifically, real-time scanning of files. I'm not sure how it works with the Excel publishing but there are various caches that could be effected during getting and refreshing or publishing of data depending on what you are doing. You can look at excluding the cache directories from live/real-time scanning of the anti-virus if this is the case. This steps to perform this vary depending on the system you use and how it is managed (centrally via policy or locally). There location of the cache on the client side can vary depending on the OS being used but you can look for the work item cache under the user profile directory or more likely under the hidden Program Data folder in windows (sometimes clearing this cache by deleting the files in this dir can solve problems too, but I'm assuming your behavior is the same on different compters so that probably won't help you)... Example of cache location is:

 C:\Users\username(Team Explorer user name)\AppData\Local\Microsoft\Team Foundation\3.0\Cache(os: Windows Server 2008 R2)

As for the server cache directories there default location for the web access cache is:

 C:\ProgramData\Microsoft\Team Foundation\Web Access\Cache_v10.0.30319 

SQL Server Performance. If other operations are slow you may want to check the performance of your SQL Server hosting the TFS data.

Tracing TFS. Other than that you can turn on tracing on the TFS server and see more detail about what is going on.

share|improve this answer
    
Thanks Ryan. We would update you once we perform above actions. –  Kabir Rao Jul 26 '12 at 8:33
    
@Kabir, did this answer help you - how's it going with Excel? –  Ryan Riehle Feb 20 at 18:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.