I need to know the how much database size will be occupied if i user 200 users using jira + green hopper .can any one give some analysis.
Not a clue. You can't even begin to guess a sizing based on users - they're a tiny fraction of your data and mostly irrelevant when it comes to data size.
Your data size is mostly determined by (number of issues * complexity * activity). To do even a basic estimate, you'll have to explain your setup and usage in quite a lot of detail.
What I would say is that the size of the database is utterly irrelevant today - the cheapest smallest hard disk you can find will have more than enough space for the database for a very long time (start with a couple of Gb allocated and then monitor the size - that will be far more useful because it will tell you how YOU chew up space, rather than some arbitrary and unrepresentative calculations)
I might worry about attachments though - they live outside the database, and your users can attach quite a lot if they try.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.