MSDE question

Hi all
I want to know that can I use MSDE as server that other clients connect to
it'
If yes,what limitations does it have'
thanksperspolis wrote:
> Hi all
> I want to know that can I use MSDE as server that other clients
> connect to it'
> If yes,what limitations does it have'
> thanks
http://msdn2.microsoft.com/en-us/library/ms165672.aspx
http://www.microsoft.com/sql/msde/p...o/features.mspx
David Gugick
Quest Software|||Clients can connect to MSDE.
For the differences between SQL Server editions refer to the documentation
below:
http://www.microsoft.com/sql/techin...ing/ChoosEd.doc
http://www.microsoft.com/sql/evalua...ew/default.mspx
One of the main limitations on MSDE apart from the 2GB per Database size
limitation is the query governor. MSDE's query governor kicks in at above 8
concurrent operations. See
http://msdn.microsoft.com/library/d... />
_0ciq.asp.
Below is a quote from Greg Low on the MSDE query governor that was recentlty
posted to the that SQLDownUnder mailing List
~~~ Start Quote ~~~
When additional workload is detected, they don't queue the extra operations.
What occurs is a delay is inserted in each logical page read or write on the
data files (ie log files are not affected). The more you exceed 8, the more
delay is inserted on each page. The effect that it ends up having depends on
how much data you are reading or writing. Small delays (milliseconds) quickl
y
get multiplied up into large delays when you are doing scans of large
(relative to the MSDE) tables.
~~ End Quote ~~
- Peter Ward
WARDY IT Solutions
"perspolis" wrote:

> Hi all
> I want to know that can I use MSDE as server that other clients connect to
> it'
> If yes,what limitations does it have'
> thanks
>
>