.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

Capacity Planning

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

Hi Everyone,

Since I dont have the Previous growth rate values for my DB, I would like to know Is it possible to prepare capacity planning of my DB. If it so, kindly let me know the steps and procedure to be followed. Thanks in advance.


Ranjith Kumar Mohandas

Ranjith Kumar Mohandas

View Complete Post

More Related Resource Links

SharePoint Capacity Planning Tool and system Center Capacity Planner

Hi, It seems like we cannot use the SharePoint Capacity Planning Tool anymore. I downloaded this SharePoint Capacity Planning Tool but its prerequisite system Center Capacity Planner(SCCP 2007) has been discontinued, as per this URL, http://technet.microsoft.com/en-us/systemcenter/ff575746.aspx  So when I try to install SharePoint Capacity Planning tool, it ask me to install SCCP V2 first. Please share if somebidy has a copy SCCP V2 or do we have any other alternate tool that can be used for SharePoint Capacity planning? Thanks, San      

Capacity Planning Document


Hi Everyone,

Can anyone suggest me the link or document that will be helpful to me in doing Capacity Planning for my server for 5 years and can any one suggest me what all the factors I need to consider while doing CAPACITY PLANNING?

I googled it But I couldn't find it.

Thanks in Advance.



Ranjith Kumar

Ranjith Kumar Mohandas

VSTS 2010: Agile Planning Tools In Visual Studio Team System 2010


Visual Studio Team System (VSTS) 2010 introduces product backlog and iteration backlog workbooks and reports that will help agile teams plan and manage releases and iterations.

Ajoy Krishnamoorthy

MSDN Magazine January 2009

Design: Place XML Message Design Ahead of Schema Planning to Improve Web Service Interoperability


Web Services are all about exchanging data in the form of XML messages. If you were about to design a database schema, you probably wouldn't let your tool do it for you. You'd hand-tool it yourself to ensure maximum efficiency. In this article, the author maintains that designing a Web Service should be no different. You should know what kind of data will be returned by Web Service requests and use the structure of that data to design the most efficient message format. Here you'll learn how to make that determination and how to build your Web Service around the message structure.

Yasser Shohoud

MSDN Magazine December 2002

Planning common membership provider for different authentication providers

I am trying to implement form based authentication (FBA) membership provider that is able to support multiple authentication mechanisms. Take it as an self-training experiment. In this posting I will introduce bases of my experiment and introduce my current plans and ideas. Why membership provider for multiple authentication mechanisms? There are many people in the world who are users of some social network or some open services provider. Today Facebook and Twitter are very popular social networks. Also Google and Microsoft Live services are very popular although they are not social networks. But all mentioned systems provide their own authentication channels also to other applications. The question is: why should I have another username and password if I have already one at some of systems I mentioned before? Here, in Estonia, we are building local Microsoft community portal with local Microsoft. We analyzed the situation and decided to use Live ID as authentication mechanism in our portal. We were a little it worried too because we were afraid that there are load of users who are not happy with Live ID as authentication mechanism. And guess what - as time has shown us there is no reason to worry! Our ~2000 users (Estonia is small country) are all happy with Live ID and the ones who doesn't have Live ID yet can go and join Live ID - it's free. If you have no idea where I l

query w.r.t to SharePoint 2010 Performance Planning & Extranet Topology

  1.      Which extranet topology to go with in case of exposing Intranet to Remote Employees / Partners ?   My understanding:   There are 3 extranet topologies : Edge Firewall , Back to Back , Split back to back   If Scenario is : a)      Only Employees needs to access Intranet from Home ,we can go for Edge Firewall b)      If partners & Employees , both needs to access Intranet ( it will have some partner sites ) , then we can go for Back to Back OR Split back to back .   Questions: ·         Is Understanding correct ? ·         Is there any factor which can help in making a decision between Back to Back Or Split back to back ?   2.      As part of sizing , I read that we should capture following information -          What should be maximum acceptable CPU utilization in production servers ? ( Example : 70%) -          What will be the concurrent number of users accessing portal during peak hour of a day ? ( Example 1000 users from total of 18000 users ) -          How many request per second are done to portal

Stringbuilders default capacity

Stringbuilder's default capacity is 16 bytes according to my 70-536 ms press book. Now a char in .NET is 2 bytes so does that mean the default capacity of a stringbuilder is 8 chars?

Server 2008 R2 - SQL 2008 R2 Cluster - Planning

Hey SQL Experts, I'm in the planning time for a Server 2008R2/SQL 2008 R2 Cluster. As far as I know, the SQL 2008R2 Cluster is based on the cluster functions of Server 2008R2, right? Is it right to say (view on licenses): - for a sql cluster (2 nodes) you need server 2008R2 Enterprise licenses under it? -sql server 2008r2 enterprise license is only required, when I want to build a sql cluster bigger than 2 nodes, right? so on: -I know the active/passive cluster for failover, but is there a possibility to use a active/active cluster for loadbalancing/performace improves? (and failover, too? in case of failover, I know the performance in a Active/Active cluster will be bad...) -I need for every cluster functions (related to sql) a shared storage under the server, right?   Thanks for your help! regards, Tim      Thanks, regards, tim

Problem with content DB planning SharePoint 2010


Hi Guys

I need to find out what to do regarding planning out content databases. The problem is that I need to design a solution where I would have two different types of content. I want to keep the site collections as simple as possible so I want to use a records centre with two document libraries for each content type.

Now the problem I have is that there is going to be about 8 Site Collections each with up to 8 terrabytes of content I need to store.

This will obviously affect performance. What can I look at here?


Document Center capacity



What is the capacity of a document center template? We need to plan a document management solution and migrate documents from a few sites in previous version. It is ok from a functional point of view to set a unified site collection to manage most of the documents. the question is whether this site template may support that storage or may support managing the documents in some content_db (which as far as i know can be done only on a site collection basis)

keren tsur

Planning for DRP. Reinstalling SQL Server. How?


I'm planning for DRP. We have 2 servers and mirroring between them.

If both servers die and we need to recreate the servers, we need to reinstall the OS and then reinstall SQL Server (we have a backup of all DBs and backup of OS stats.)

If we install new OS and then istall SQL Server with same settings like in the first place, then apply the restore of OS stats with the old registry in it. what will it do to the new installation of the SQL Server?

Is this is the correct way to reinstall the new machine?

Planning Phase for Moss 2010 Implementation



Im on the planning phase for a Moss 2010 roll out with 15 sites and 3600 clients...

Allot i have to consider... firstly i must make recommendation's for connectivity and and where secondary servers must be located...

So, there is brob going to be a few questions but lets start with this:

  • Looks to me like on average each site has got about 240 clients. So guess i will have to have a Moss and SQL server at each site.                                        How do i create secondary multiple Moss servers for each site...
  • How much Kbps is required per user

I'm starting to think a server in a data center might be the better way to go.

Does Dictionary adjust initial Capacity to a quantum value


Dictionary<K, V> will automatically resize when needed. Presumably, the Capacity values it uses are in monotically increasing values determined by some algorithm, and thus one can assume that all dictionaries size up on these boundaries. Our system uses lots of Dictionaries, some of which get quite large and end up in the Large Object Heap. But because they all currently grow from 0, I assume (based on memory profiling) that I am allocating always exact sized chunks from LOH. so in practice, this never leads to a seriously fragmented LOH because all the allocated blocks are exact even multiples of some basic value.

I want to enhance the system by using the initial Capacity constructor based on an estimated capacity. But my big worry is that it will allocate that exact amount, and that this will therefore lead to serious fragmentation of the heap. List<V> provides an explicit Capacity property, so I could experiment with that collection to determine its behavior, but Dictionary does not provide any access to its current capacity. Does anyone know about this? Basically I want to know if when I request the initial Capacity in the ctor, will it actually round that up to one of its magic values that I would have hit had I increased its contents one by one; or is it going to just request that exact amount of capacity?

Document Library/Content Type Planning


Im in the process of moving a network drives content to a new document library.

The network contains all our IT Sarbanes Oxley documentation/checks


What im struggling with is how to plan the document library.

Should I create a team site for this network drive and have multiple document libraries?
Or should I create just one document library?

What im struggling with is how to plan andocument library.


for example,
currently every morning a member of staff completes a check of server backups.
They modify an Excel spreadsheet which contains a row for each site/server and a column for each day.
This Document is located at O:\IT Procedures Policies & Controls\Controls\KC202 - Monitor Backups
Every month a new Spreadsheet is started which is based on a template.

My first idea was to create a content type for this check called 'KC202' as a template can be assigned then each month the user just needs to hit the dropdown button and then 'new KC202'.
the problem with this is we have 37 folders within 'Controls' ranging from KC000 to KC507 all of which will need template documents (each being Unique)

Then I thought the best idea would be to have a content type for 'Controls' with metadata for the 'KC' number. Whenever a new document is created the user can

Alternative of PPS Planning server on Sharepoint 2010



I believe that the PPS planning server is no longer a part of sharepoint 2010.

Are there any alternatives to build a financial / business planning model on sharepoint 2010 in absence of the PPS Planning Server? If not, is anyone aware of this being a part of road map? I think this is an important piece of a BI suite especially considering the competition. 

Thanks for your help and support. 




Increase The Capacity Of SharePoint 2010 List


 Hi guys ..


I Have an External List in SharePoint2010 ,, the Data Increase day By day(It May Contain more than 2000 record)  ,, and According To my Knowledge The List In Sharepoint Contain Only 2000 Record ,,

So How I Can configure The SharePoint2010 External List To Contain More Than 2000 Record , according to My Needs.


Best Regards .

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