Concurrent queries

Where do I change the setting for concurrent queries? I
keep seeing the following in my sql log.
This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 1 queries and
performance may be adversely affected.
ThanksHi Jeanie,
You will only see that message on MSDE or SQL Server Personal Edition, and
it is a limitation built in to these (basically free) versions, so that they
can't be used for large systems. If you don't want to see it anymore you
will have to upgrade to SQL Server Standard Edition.
Jacco Schalkwijk
SQL Server MVP
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...

quote:

---

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

---

|||Jeanie,
Are you running either MSDE or Personal Edition of SQL Server? If so, these
are scaled down in size from the full SQL Server. Your choices would then
be:
1 - Accept the reduced performance
2 - In a development environment, upgrade to SQL Server Developer Edition
3 - In a production environment, upgrade to SQL Server Standard Edition
Russell Fields
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...

quote:

---

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

---

|||If you download the latest BOL update (January 2004) it has new material
specifically about the MSDE 2000 Workload Governor.
http://www.microsoft.com/sql/techin.../2000/books.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jeanie" <jfhayes@.godwingruber.com> wrote in message
news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...

quote:

---

> Where do I change the setting for concurrent queries? I
> keep seeing the following in my sql log.
>
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 1 queries and
> performance may be adversely affected.
> Thanks

---

|||Jacco
Is it relative easy to update the Personal Edition to Sql
Server Standard. Where can I find the white papers.
Thanks
Jeanie

quote:

---

>--Original Message--
>Hi Jeanie,
>You will only see that message on MSDE or SQL Server

---

Personal Edition, and

quote:

---

>it is a limitation built in to these (basically free)

---

versions, so that they

quote:

---

>can't be used for large systems. If you don't want to

---

see it anymore you

quote:

---

>will have to upgrade to SQL Server Standard Edition.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Jeanie" <jfhayes@.godwingruber.com> wrote in message
>news:67a901c3e672$9083c1c0$a001280a@.phx.gbl...
I[QUOTE]
>
>.
>

---

|||Hi Jeanie,
It is fairly straightforward to do an edition upgrade of SQL Server. Just
make sure you back up all your databases first, including the master and
msdb databases.
See the topic "upgrading SQL Server, edition upgrades" for the details.
Jacco Schalkwijk
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:6eb301c3e6b7$5bb1f9e0$a501280a@.phx.gbl...[QUOTE]
> Jacco
> Is it relative easy to update the Personal Edition to Sql
> Server Standard. Where can I find the white papers.
> Thanks
> Jeanie
> Personal Edition, and
> versions, so that they
> see it anymore you
> I