MSDE size

Hi,
I am not quite sure about the MSDB maximum dabatase size.
Is the 4 GB maximum size applicable for each database
size or a table?
Can a single table size be more than 3 GB?. I have a
single table of size over 2.5 GB. If the size of a single
table is limited to 2 GB (I heard from my friend ... but
not sure) then should I split that large table into 2 or
3 tables such that I can take the maximum benefit of 4 GB
of MSDE size.
Please share your opinion and any new ideas other than
what I have written over here.
I appreciate it in advance !!
David
Currently with MSDE, the maximum database size, excluding logs is 2Gb.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:08bd01c4e062$7dd4ee60$a501280a@.phx.gbl...
> Hi,
> I am not quite sure about the MSDB maximum dabatase size.
> Is the 4 GB maximum size applicable for each database
> size or a table?
> Can a single table size be more than 3 GB?. I have a
> single table of size over 2.5 GB. If the size of a single
> table is limited to 2 GB (I heard from my friend ... but
> not sure) then should I split that large table into 2 or
> 3 tables such that I can take the maximum benefit of 4 GB
> of MSDE size.
> Please share your opinion and any new ideas other than
> what I have written over here.
> I appreciate it in advance !!
> David
|||Though be aware that this is changing with 2005 Personal Edition, MSDE's
successor. The 2005 version will only recogognoze 1 GIG of memory, but I
believe it did increase the allowable db size to 4 GB. It also removed the 5
concurrent batch restriction and stopped shipping the SQL Agent. If you want
to autoamte task in 2005 you will have to use the NT scheduler.
Caveat: This was my understanding as of my last check. MS loves to change
things before final release
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIAZ3aG4EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Currently with MSDE, the maximum database size, excluding logs is 2Gb.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "David" <anonymous@.discussions.microsoft.com> wrote in message
> news:08bd01c4e062$7dd4ee60$a501280a@.phx.gbl...
>
|||I believe you mean Express Edition not personal Edition.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob Castleman" <nomail@.here> wrote in message
news:OVGrezS4EHA.3596@.TK2MSFTNGP12.phx.gbl...
> Though be aware that this is changing with 2005 Personal Edition, MSDE's
> successor. The 2005 version will only recogognoze 1 GIG of memory, but I
> believe it did increase the allowable db size to 4 GB. It also removed the
5
> concurrent batch restriction and stopped shipping the SQL Agent. If you
want
> to autoamte task in 2005 you will have to use the NT scheduler.
> Caveat: This was my understanding as of my last check. MS loves to change
> things before final release
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uIAZ3aG4EHA.3416@.TK2MSFTNGP09.phx.gbl...
>

MSDE Maximum Connections

Quick question on MSDE maximum connections. If you use MSDE on several and
the MSDE on each computers is pointing to one PCs MSDE, does that mean they
are always connected regardless if the software you are using is requesting
data or not? Meaning if you have 5 PCs pointing to one PC's MSDE, does that
mean there are 5 constant concurrent connections?
Also, if this is the case, whats the max connections you can have?
Thanks,
Matt
There is no limitation in connections; but in MSDE the performance will slow
down if you have more than 5 concurrent batch (connections) running.
After the 5th batch the Query Governer will stop working and will degrade
performance.
If 5 machines are connected using an application to MSDE, yes there will be
5 connections.
Thanks
Hari
"medentmatt" <mattd@.medent(dot)com.(donotspam)> wrote in message
news:CDDC7137-2D58-436B-967B-CF1A6111FD1E@.microsoft.com...
> Quick question on MSDE maximum connections. If you use MSDE on several and
> the MSDE on each computers is pointing to one PCs MSDE, does that mean
> they
> are always connected regardless if the software you are using is
> requesting
> data or not? Meaning if you have 5 PCs pointing to one PC's MSDE, does
> that
> mean there are 5 constant concurrent connections?
> Also, if this is the case, whats the max connections you can have?
> --
> Thanks,
> Matt
|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ep%23Obh4SHHA.5016@.TK2MSFTNGP05.phx.gbl...
> There is no limitation in connections; but in MSDE the performance will
> slow down if you have more than 5 concurrent batch (connections) running.
> After the 5th batch the Query Governer will stop working and will degrade
> performance.
> If 5 machines are connected using an application to MSDE, yes there will
> be 5 connections.
It also depends on how the application that access MSDE is designed. If it
is designed in a ideal way, that is, connect to database server only needed
and close the connection as soon as the access is done. Then even with
MSDE's 5 concurrent work load limitation, an MSDE can well serve a lot more
users who need to access data from time to time 20, 50 or even hundreds,
really depends how the the data is accessed.

MSDE Max Connections?

Hi, can anyone tell me whats the maximum number of connections you can have to MSDE? Eg, is it enough to host an intranet site for a relativly small business?There is no practical maximum. There is a throttle, however, when there are more than five concurrent sessions that are processing data. I've seen apps with many dozens of users use MSDE without the throttle kick in, when their data usage was relatively light.

There are lots of subtleties, but it's a good chance that it'll work for you.

Don|||Thanks Don :)