Tim Elhajj

Off the Microsoft stack!

Upgrade SQL Server 2012 for TFS 2013 to SQL Server 2014

Leave a comment

Azure DevOps and Visual Studio Awesomeness

Starting July 1st, Microsoft will be adding SQL Server 2014 to the list of license grants for Team Foundation Server 2013.  SQL Server 2014 is supported by TFS 2013 with the caveat that it has increased hardware requirements compared with previous versions.

Microsoft also has a KB Article titled “Performance decreases in TFS 2013 Update 2 after you upgrade to SQL Server 2014” which you should also be aware of if you have a large configuration (> 500 users).  It specifically addresses a Work Item Tracking performance issue and can be easily mitigated by increasing the RAM by 410MB on the server hosting the SQL Server instance for each Team Project Collection database.

Example: two (2) Team Project Collections X 0.4 GB = 0.8 GB of RAM

Note:  If you have SQL Server Reporting Services deployed on a separate server in your TFS 2013 environment make sure you don’t forget…

View original post 109 more words

Author: Tim Elhajj

Tim is probably walking his dog.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s