concurrent query limit

i am getting this message in the SQL server logs. But i dont know where to
make the changes to increase the limit...
"This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected."
thanksYou are running either MSDE or Personal Edition. These has a performance throttling mechanism that you have
hit. Evaluate whether you want to install a "proper" SQL Server (Standard or Enterprise edition).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"harun" <kazi[remove]@.wideopenwest.com> wrote in message news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "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
>|||From BOL:
"SQL Server 2000 Desktop Engine and SQL Server 2000
Personal Edition have a concurrent workload governor that
limits performance when more than eight operations are run
concurrently". Have a look at DBCC CONCURRENCYVIOLATION to
get more info, but as far as I understand this limit is
not configurable (unless you upgrade to another edition of
course).
HTH,
Paul Ibison|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
John
"harun" <kazi[remove]@.wideopenwest.com> wrote in message
news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> i am getting this message in the SQL server logs. But i dont know where to
> make the changes to increase the limit...
> "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
>|||My guess is that you have two instances or more of SQL Server and an MSDE instance is giving you the
messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"mxnova" <mxnova@.discussions.microsoft.com> wrote in message
news:AE404F97-2F1B-4F73-9C3B-A322A6E24677@.microsoft.com...
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standard
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Viewer
> logs.
>
> "John Bell" wrote:
> > Hi
> >
> > This may help if you are using MSDE
> >
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_5fs6.asp
> >
> > John
> > "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> > news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> > > i am getting this message in the SQL server logs. But i dont know where to
> > > make the changes to increase the limit...
> > >
> > > "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
> > >
> > >
> >
> >
> >