Location: List Archives

List Archives

This forum is an archive of all posts to our mailing list over the past few years.  The forum is set read only therefore to contribute you will need to join our list community.  See more info about this here.

 

When subscribed to the list you should use your standard email client to send your posts to ActiveDir@mail.activedir.org.

List Archives

Subject: RE: [ActiveDir] Adding custom fields to AD
Prev Next
You are not authorized to post a reply.

AuthorMessages
listmailUser is Offline

Posts:824

10/08/2005 3:39 AM  
> One thing I am curious about though is why MS opted for JET
> as the DB of choice for AD.. was it the only viable option
> at the time ?

What do you feel is wrong with ESE (aka Jet Blue)?
> What's the ceiling on actual database size before it caves in
(performance-wise)?

Max size for an ESE DB for AD is ~16TB (8KB pages * 2147483646 max pages
Ώ]). As for when it caves perf wise from an AD standpoint it really depends
on what you are doing with it and what you have indexed from what I have
seen. If someone is issuing crappy inefficient queries it will seem to be
pretty slow pretty fast with relatively little data.

The largest DB I have seen in production has been ~20GB and that was with
W2K on a GC and a bunch of that data shouldn't have been in the AD like
duplicated ACEs and misc unneeded objects, etc. Going to K3 would probably
reduce that DB to about 10-12GB or better due to single instance store,
cleanup would reduce it even further. One Fortune 5 company I have worked
with had a K3 GC DB in the area of 5GB and that was for some 250,000 users
with Exchange and multiple custom attributes.

joe

Ώ] See the docs for JetCreateDatabase -
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ese/ese/jet
createdatabase.asp?frame=true

-----Original Message-----
From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Mylo
Sent: Friday, October 07, 2005 9:04 PM
To: ActiveDir@xxxxxxxxxxxxxxxxxx
Subject: Re: [ActiveDir] Adding custom fields to AD

That's a good point about plonking stuff in AD.... a case of once a good
thing comes along everyone wants to climb aboard. I remember doing ZENworks
stuff with Novell where all the application configuration information for
software distribution was shunted into NDS/E-Directory... all that bloat
adds up replication-wise (still, at least there was partitioning).

One thing I am curious about though is why MS opted for JET as the DB of
choice for AD.. was it the only viable option at the time ? What's the
ceiling on actual database size before it caves in (performance-wise)?

Mylo

joe wrote:

>I am going to basically say what the other said only I am going to put
>it this way
>
>IF the data needs to be available at all locations or a majority of
>locations where your domain controllers are located, consider adding
>the data to AD.
>
>IF the data is going to be needed only at a couple of sites or a single
>site, put them into another store. My preference being AD/AM unless you
>need to do some complicated joins or queries of the data that LDAP
>doesn't support.
>
>There is also the possibility of using app partitions but if you were
>going to go that far, just use AD/AM.
>
>The thing I have about sticking this data into AD is that AD is
>becoming, in many companies, a dumping ground of all the crap that was
>in all the other directories in the company. I realize this was the
>initial view from MS on how this should work but I worked in a large
>company and thought that was silly even then.
>
>The number one most important thing for AD is to authenticate Windows
users.
>Every time you dump more crap into AD you are working towards impacting
>that capability or the capability to quickly restore or the ability to
>quickly add more DCs. The more I see the one stop everything loaded
>into ADs the more I think that the NOS directory should be NOS only.
>Plus, I wonder how long before we hit some interesting object size
>limits. I have asked for details from some MS folks a couple of times
>on the issues with admin limit exceeded errors that you get when
>overpopulating a normal multivalue attribute (i.e. not linked) and it
>causing no other attributes to be added to the object. I wonder what other
limits like that exist.
>
>
>
> joe
>
>
>-----Original Message-----
>From: ActiveDir-owner@xxxxxxxxxxxxxxxxxx
>[mailto:ActiveDir-owner@xxxxxxxxxxxxxxxxxx] On Behalf Of Steve Shaff
>Sent: Tuesday, August 09, 2005 12:16 PM
>To: ActiveDir@xxxxxxxxxxxxxxxxxx
>Subject: [ActiveDir] Adding custom fields to AD
>
>Group,
>
>My manager wanted me to check, even though, I don't think that it is
>possible, but, I will present the question.
>
>He would like to add some custom fields, about 30, to AD. He would
>like to add bio information into AD to be pulled by Sharepoint and
>other applications for people to read. I think that this is a waste of
>time, space and effort. However, it is not my call and if this is what he
wants....
>
>What are everyone's thoughts on the topic?
>
>Thanks
>S
>List info : http://www.activedir.org/List.aspx
>List FAQ : http://www.activedir.org/ListFAQ.aspx
>List archive:
>http://www.mail-archive.com/activedir%40mail.activedir.org/
>
>List info : http://www.activedir.org/List.aspx
>List FAQ : http://www.activedir.org/ListFAQ.aspx
>List archive:
>http://www.mail-archive.com/activedir%40mail.activedir.org/
>
>
>
>

List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/

List info : http://www.activedir.org/List.aspx
List FAQ : http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
You are not authorized to post a reply.
Forums >ActiveDir Mail List Archive >List Archives > RE: [ActiveDir] Adding custom fields to AD



ActiveForums 3.7
Friends

Friends

VisualClickButoton
Members

Members

MembershipMembership:
Latest New UserLatest:cajoe64
New TodayNew Today:0
New YesterdayNew Yesterday:0
User CountOverall:5291

People OnlinePeople Online:
VisitorsVisitors:36
MembersMembers:0
TotalTotal:36

Online NowOnline Now:

Ads

Copyright 2012 ActiveDir.org
Terms Of Use