Microsoft doesnt really support anything over 32 Databases(??)

19 Jan 2006 4:27 PM

Jens Mertens

Hi NG,

I've read the following statement on
http://www.sharepointu.com/forums/m_12060/tm.htm:
"Microsoft doesnt really support anything over 32 Databases". (This
statement was uttered concerning the creation of a large amount (ca. 200)
sharepoint-websites with stsadm -o CreateSiteInNewDb)

Can anyone confirm this or would you guys say, that there shouldn't be any
problems with about 200 databases in an MSSQL-Server (with each database
containing about 10MB upto 1GB).

I'd appreciate any help!
Cheers, Jens

P.S. I am doing exactly the same thing like the guy in the posting stated
above therefore it'd be interesting if anybody has infos about this special
case.

19 Jan 2006 4:36 PM

Robert Burks

No problem. I have close to 190 most at or over 100MB with a couple topping
2GB.

--
Robert Burks

bur***@bcsd.com

Show quoteHide quote

"Jens Mertens" <n*@no.com> wrote in message
news:uWbynURHGHA.2036@TK2MSFTNGP14.phx.gbl...
> Hi NG,
>
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
>
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
>
> I'd appreciate any help!
> Cheers, Jens
>
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>

19 Jan 2006 6:00 PM

Hal Berenson

The real limit is on the number of concurrently open databases, and if I
remember correctly it is actually a Windows handle limit that is hit. You
can use AutoClose to support a large number of databases that are not all in
use simultaneously. And, I suspect the handle limit isn't an issue at all
on 64-bit Windows. But I haven't looked into it.

--
Hal Berenson, President
PredictableIT, LLC
http://www.predictableit.com

Show quoteHide quote

"Jens Mertens" <n*@no.com> wrote in message
news:uWbynURHGHA.2036@TK2MSFTNGP14.phx.gbl...
> Hi NG,
>
> I've read the following statement on
> http://www.sharepointu.com/forums/m_12060/tm.htm:
> "Microsoft doesnt really support anything over 32 Databases". (This
> statement was uttered concerning the creation of a large amount (ca. 200)
> sharepoint-websites with stsadm -o CreateSiteInNewDb)
>
> Can anyone confirm this or would you guys say, that there shouldn't be any
> problems with about 200 databases in an MSSQL-Server (with each database
> containing about 10MB upto 1GB).
>
> I'd appreciate any help!
> Cheers, Jens
>
> P.S. I am doing exactly the same thing like the guy in the posting stated
> above therefore it'd be interesting if anybody has infos about this
> special case.
>

20 Jan 2006 9:36 AM

Michael Hotek

It's a handle limit from Windows. I've never hit it though.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quoteHide quote

"Hal Berenson" <hberen***@predictableit.com> wrote in message
news:uqec9ISHGHA.1288@TK2MSFTNGP09.phx.gbl...
> The real limit is on the number of concurrently open databases, and if I
> remember correctly it is actually a Windows handle limit that is hit. You
> can use AutoClose to support a large number of databases that are not all
> in use simultaneously. And, I suspect the handle limit isn't an issue at
> all on 64-bit Windows. But I haven't looked into it.
>
> --
> Hal Berenson, President
> PredictableIT, LLC
> http://www.predictableit.com
>
>
>
> "Jens Mertens" <n*@no.com> wrote in message
> news:uWbynURHGHA.2036@TK2MSFTNGP14.phx.gbl...
>> Hi NG,
>>
>> I've read the following statement on
>> http://www.sharepointu.com/forums/m_12060/tm.htm:
>> "Microsoft doesnt really support anything over 32 Databases". (This
>> statement was uttered concerning the creation of a large amount (ca. 200)
>> sharepoint-websites with stsadm -o CreateSiteInNewDb)
>>
>> Can anyone confirm this or would you guys say, that there shouldn't be
>> any problems with about 200 databases in an MSSQL-Server (with each
>> database containing about 10MB upto 1GB).
>>
>> I'd appreciate any help!
>> Cheers, Jens
>>
>> P.S. I am doing exactly the same thing like the guy in the posting stated
>> above therefore it'd be interesting if anybody has infos about this
>> special case.
>>
>
>