SQL server sizing impact of using Web Interface/NFuse Enterprise

RoyATokeshi
March 26, 2004 4:16 am

Citrix states in their article: CTX103627

CTX103627 - SQL server sizing impact of using Web Interface/NFuse Enterprise

This document was published at: http://support.citrix.com/kb/entry.jspa?externalID=CTX103627

Document ID: CTX103627, Created on: Mar 25, 2004, Updated: Mar 26, 2004

Products: Web Interface Extension 2.0

Title

SQL server sizing impact of using Web Interface Extension / NFuse Enterprise

Additional Information

The following information applies to Web Interface Version 2.0 and all versions of NFuse Enterprise:

What will the SQL database size be at a minimum with no configured users?

The biggest segment of data in the Web Interface/NFuse Enterprise database is actually the list of applications published by the MetaFrame farms. All the information that is configured in the Management Console is stored in the database together with an expanded and flattened table of users and group membership relationships.

For example, a database for a Web Interface/NFuse Enterprise installation with one farm and 11 applications in it consumes 3.3MB of space with 500 users in the MetaFrame domain. However, not all of these user accounts had used the Web Interface site.

How quickly will the database grow and to what extent as the user data is added?

As each user is added from the domain in which the Web Interface/NFuse Enterprise server is a member, minimal additional data is added. This includes the user name, domain name, and the references to the MetaFrame users with an encrypted password, if necessary.

However, when adding a farm from another domain, the entire list of users and group memberships from the secondary domain gets added to the database. Even users who are not logged on to Web Interface/NFuse Enterprise yet are represented in the database, with the password field set to until the users log on and configure their User ID mappings. Therefore, adding a farm from a secondary domain with 10,000 users creates a much larger database than if the Web Interface were used only for farms in the local domain.

For example, a Web Interface server installed in a very small primary domain (approximately 10 users, 6 applications) was augmented to include a new farm from a larger domain with over 1500 user accounts. The database size is now approximately 30MB, even though only one user from the larger domain ever logged on. The ss_user table contains a list of all the accounts from that other domain.



Primary links

Custom Search

User login

Who's new

  • maczugaher
  • locksgydff
  • isotheces
  • ahundredyears7
  • Jacomijntjefu

Who's online

There are currently 0 users and 2 guests online.

KrissysCorner.com RuthSwensonLaw.com CreativeLizardProductions.com

DISCLAIMER:

None of this has anything to do with us, someone else is responsible for the entire thing, and we have no idea who or why. We do not know anything about it. It may be alien life forms for all we know: we haven't a clue. You cannot blame us for anything that may result from your visit. That was entirely your own personal choice, made by you of your own volition, and without our knowledge. We do not, after all, have any control over you and cannot by any stretch of the imagination be expected to accept or acknowledge, be it legally or morally, any accountability for decisions made by you on an independent basis, utilizing your own free will, and without our intervention. We are therefore in no way, shape, or form answerable to anyone for any consequences arising from the aforementioned or indeed any other actions, similar or otherwise, because it was not us that did, or did not do anything. It is not even remotely our fault, and we are in no way prepared or willing to accept any liability, not even slightly, ever. We are, in fact completely and utterly blameless, in that it is definitely not our concern, and no blame can possibly be laid at our doorstep, even if we had one, the possession of which we hereby reserve as being entirely our own free choice. The onus is not on us at all, and furthermore, never has been. The entire matter is wholly beyond our control, and completely out of our hands, each of which are washed scrupulously clean of the whole business. We are not accountable for anything at all, and we hereby categorically deny all responsibility for all that has ever, or will ever happen. Our innocence is therefore wholly beyond doubt and absolutely unimpeachable, and so cannot, under even the remotest or unlikeliest circumstances, be brought into question. By clicking either on a link on this site, clicking on a link that leads to this site, or by arriving at this site by natural or supernatural means, you are in effect accepting responsibility for the fact that it is all entirely your own fault, down to the most miniscule detail, and that you are wholly accountable for whatever outcome may arise as a consequence of the aforementioned action or actions insofar as they were undertaken personally by you on an entirely voluntary basis and without any persuasion, coercion or influence from any party or parties other than yourself. Don't come sniveling to us, we are only figments of your imagination. I also agree that if I am ever with a contributor to this website during mealtimes I agree to pay for any super-sizing of their meal, or at least a nice dessert or one of those foo-foo drinks with an umbrella or a monkey. By admitting to have seen the worthless spineless drivel on this website (also known as content)

I Agree Wholeheartedly and Without Reservation to the above. (Except maybe for that part about the monkey.)

All Your Base Are Belong To Us.

Soylent Green Is People!

Never make a bet with a Sicilian when Death is on the Line!

No. Really, I do agree.