choices of numbers exceeded by.
What is it referring to and how do I increase the number of concurrent
queries?
Thanks.
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 10 queries and performance may be adversely affected.This is a multi-part message in MIME format.
--=_NextPart_000_05A6_01C376F0.628EA510
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Sounds like you are using MSDE or SQL Server Personal Edition. If you =want to run a bunch of concurrent queries - without performance =degradation - then you will need to go to SQL Server Standard or =Enterprise Edition.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Todd A. Carter" <tcarter@.activelinkarts.com> wrote in message =news:ubHAVExdDHA.748@.TK2MSFTNGP10.phx.gbl...
This occurs many times in our w2k event view application log with =various
choices of numbers exceeded by.
What is it referring to and how do I increase the number of concurrent
queries?
Thanks.
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit =has
been exceeded by 10 queries and performance may be adversely affected.
--=_NextPart_000_05A6_01C376F0.628EA510
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Sounds like you are using MSDE or SQL =Server Personal Edition. If you want to run a bunch of concurrent queries =- without performance degradation - then you will need to go to SQL Server =Standard or Enterprise Edition.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Todd A. Carter"
--=_NextPart_000_05A6_01C376F0.628EA510--|||What it refers to is that the governor in MSDE (or SQL Server Personal
Edition) has been activated as the result of too many queries being
submitted concurrently. The implication is that the users of MSDE will
experience a slowdown until the number of concurrent queries drops below 8.
If this is a rare event, then I wouldn't worry about it. If you are seeing
this message frequently (as you indicate), then check to see if your users
are experiencing performance problems running the application that is using
MSDE. If they are then you need to purchase and upgrade to SQL Server 2000
Standard Edition. But if your users aren't complaining, then you can just
ignore the messages and keep in mind that should they start complaining
about the performance then you know the likely reason.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Todd A. Carter" <tcarter@.activelinkarts.com> wrote in message
news:ubHAVExdDHA.748@.TK2MSFTNGP10.phx.gbl...
> This occurs many times in our w2k event view application log with various
> choices of numbers exceeded by.
> What is it referring to and how do I increase the number of concurrent
> queries?
> Thanks.
>
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 10 queries and performance may be adversely affected.
>
>|||It is personal edition. Is there a clean method for
upgrading? We own the software license already.
Todd
>--Original Message--
>Thank you everyone... but this is supposed to be an
Enterprise Server. How
>can I verify/validate that the correct software was
loaded?
>Thanks.
>Todd
>"Hal Berenson" <haroldb@.truemountainconsulting.com>
wrote in message
>news:uJ1v#1ydDHA.560@.tk2msftngp13.phx.gbl...
>> What it refers to is that the governor in MSDE (or SQL
Server Personal
>> Edition) has been activated as the result of too many
queries being
>> submitted concurrently. The implication is that the
users of MSDE will
>> experience a slowdown until the number of concurrent
queries drops below
>8.
>> If this is a rare event, then I wouldn't worry about
it. If you are
>seeing
>> this message frequently (as you indicate), then check
to see if your users
>> are experiencing performance problems running the
application that is
>using
>> MSDE. If they are then you need to purchase and
upgrade to SQL Server
>2000
>> Standard Edition. But if your users aren't
complaining, then you can just
>> ignore the messages and keep in mind that should they
start complaining
>> about the performance then you know the likely reason.
>> --
>> Hal Berenson, SQL Server MVP
>> True Mountain Group LLC
>>
>> "Todd A. Carter" <tcarter@.activelinkarts.com> wrote in
message
>> news:ubHAVExdDHA.748@.TK2MSFTNGP10.phx.gbl...
>> > This occurs many times in our w2k event view
application log with
>various
>> > choices of numbers exceeded by.
>> >
>> > What is it referring to and how do I increase the
number of concurrent
>> > queries?
>> >
>> > Thanks.
>> >
>> >
>> >
>> > 17052 :
>> >
>> > This SQL Server has been optimized for 8 concurrent
queries. This limit
>> has
>> > been exceeded by 10 queries and performance may be
adversely affected.
>> >
>> >
>> >
>>
>
>.
>|||I do not think you can upgrade Personal SQL 2k to Enterprise SQL 2k, only to
Standard and then To Enterprise.
for more Info go here
http://msdn.microsoft.com/library/en-us/instsql/in_overview_2xtf.asp
"Todd A. Carter" <tcarter@.activelinkarts.com> wrote in message
news:001a01c37741$e151cd40$a001280a@.phx.gbl...
> It is personal edition. Is there a clean method for
> upgrading? We own the software license already.
> Todd
> >--Original Message--
> >Thank you everyone... but this is supposed to be an
> Enterprise Server. How
> >can I verify/validate that the correct software was
> loaded?
> >
> >Thanks.
> >
> >Todd
> >
> >"Hal Berenson" <haroldb@.truemountainconsulting.com>
> wrote in message
> >news:uJ1v#1ydDHA.560@.tk2msftngp13.phx.gbl...
> >> What it refers to is that the governor in MSDE (or SQL
> Server Personal
> >> Edition) has been activated as the result of too many
> queries being
> >> submitted concurrently. The implication is that the
> users of MSDE will
> >> experience a slowdown until the number of concurrent
> queries drops below
> >8.
> >> If this is a rare event, then I wouldn't worry about
> it. If you are
> >seeing
> >> this message frequently (as you indicate), then check
> to see if your users
> >> are experiencing performance problems running the
> application that is
> >using
> >> MSDE. If they are then you need to purchase and
> upgrade to SQL Server
> >2000
> >> Standard Edition. But if your users aren't
> complaining, then you can just
> >> ignore the messages and keep in mind that should they
> start complaining
> >> about the performance then you know the likely reason.
> >>
> >> --
> >> Hal Berenson, SQL Server MVP
> >> True Mountain Group LLC
> >>
> >>
> >> "Todd A. Carter" <tcarter@.activelinkarts.com> wrote in
> message
> >> news:ubHAVExdDHA.748@.TK2MSFTNGP10.phx.gbl...
> >> > This occurs many times in our w2k event view
> application log with
> >various
> >> > choices of numbers exceeded by.
> >> >
> >> > What is it referring to and how do I increase the
> number of concurrent
> >> > queries?
> >> >
> >> > Thanks.
> >> >
> >> >
> >> >
> >> > 17052 :
> >> >
> >> > This SQL Server has been optimized for 8 concurrent
> queries. This limit
> >> has
> >> > been exceeded by 10 queries and performance may be
> adversely affected.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
> >.
> >|||First you need to check your operating system. If it is a desktop operating
system such as Windows XP then you need to upgrade that first as Enterprise
Edition will only install on server operating systems. Then take a look at
the link that Yovan provided. If you can't do a direct upgrade then you can
look at detaching the databases, installing Enterprise Edition, and
re-attaching the databases.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Todd A. Carter" <tcarter@.activelinkarts.com> wrote in message
news:001a01c37741$e151cd40$a001280a@.phx.gbl...
> It is personal edition. Is there a clean method for
> upgrading? We own the software license already.
> Todd
> >--Original Message--
> >Thank you everyone... but this is supposed to be an
> Enterprise Server. How
> >can I verify/validate that the correct software was
> loaded?
> >
> >Thanks.
> >
> >Todd
> >
> >"Hal Berenson" <haroldb@.truemountainconsulting.com>
> wrote in message
> >news:uJ1v#1ydDHA.560@.tk2msftngp13.phx.gbl...
> >> What it refers to is that the governor in MSDE (or SQL
> Server Personal
> >> Edition) has been activated as the result of too many
> queries being
> >> submitted concurrently. The implication is that the
> users of MSDE will
> >> experience a slowdown until the number of concurrent
> queries drops below
> >8.
> >> If this is a rare event, then I wouldn't worry about
> it. If you are
> >seeing
> >> this message frequently (as you indicate), then check
> to see if your users
> >> are experiencing performance problems running the
> application that is
> >using
> >> MSDE. If they are then you need to purchase and
> upgrade to SQL Server
> >2000
> >> Standard Edition. But if your users aren't
> complaining, then you can just
> >> ignore the messages and keep in mind that should they
> start complaining
> >> about the performance then you know the likely reason.
> >>
> >> --
> >> Hal Berenson, SQL Server MVP
> >> True Mountain Group LLC
> >>
> >>
> >> "Todd A. Carter" <tcarter@.activelinkarts.com> wrote in
> message
> >> news:ubHAVExdDHA.748@.TK2MSFTNGP10.phx.gbl...
> >> > This occurs many times in our w2k event view
> application log with
> >various
> >> > choices of numbers exceeded by.
> >> >
> >> > What is it referring to and how do I increase the
> number of concurrent
> >> > queries?
> >> >
> >> > Thanks.
> >> >
> >> >
> >> >
> >> > 17052 :
> >> >
> >> > This SQL Server has been optimized for 8 concurrent
> queries. This limit
> >> has
> >> > been exceeded by 10 queries and performance may be
> adversely affected.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
> >.
> >
No comments:
Post a Comment