Configuration question

I've looked for the answer to this question, but can't find it. How do you
limit the number of report requests that execute at a given time? For
example, if I schedule 100 jobs to execute via a shared schedule at the same
time. How can I tell RS to only run 5 at a time until all 100 have
completed?
ThanksBy default RS will only take on work when it has the resources to do so.
Currently we rely on CPU usage to determine this. We will start working on
at most 2 * number of CPU. If the cpu usage stays low we will continue to
try and do more work. You can limit the total number RS will work on in the
RSReportServer.config file. The MaxQueueThreads tells RS at most how many
threads to use for processing reports. 0 means we will do as described
above, any other number will limit the total work that we can work on at one
time.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"troark" <t.roark@.excite.com.n0sp@.m> wrote in message
news:#R4snWxfEHA.1188@.TK2MSFTNGP11.phx.gbl...
> I've looked for the answer to this question, but can't find it. How do
you
> limit the number of report requests that execute at a given time? For
> example, if I schedule 100 jobs to execute via a shared schedule at the
same
> time. How can I tell RS to only run 5 at a time until all 100 have
> completed?
> Thanks
>|||Great explaination. Thanks!
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:OTHD4byfEHA.1428@.TK2MSFTNGP10.phx.gbl...
> By default RS will only take on work when it has the resources to do so.
> Currently we rely on CPU usage to determine this. We will start working
on
> at most 2 * number of CPU. If the cpu usage stays low we will continue to
> try and do more work. You can limit the total number RS will work on in
the
> RSReportServer.config file. The MaxQueueThreads tells RS at most how many
> threads to use for processing reports. 0 means we will do as described
> above, any other number will limit the total work that we can work on at
one
> time.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "troark" <t.roark@.excite.com.n0sp@.m> wrote in message
> news:#R4snWxfEHA.1188@.TK2MSFTNGP11.phx.gbl...
> > I've looked for the answer to this question, but can't find it. How do
> you
> > limit the number of report requests that execute at a given time? For
> > example, if I schedule 100 jobs to execute via a shared schedule at the
> same
> > time. How can I tell RS to only run 5 at a time until all 100 have
> > completed?
> >
> > Thanks
> >
> >
>sqlsql

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."
thanks
You 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
>
|||Hi
This may help if you are using MSDE
http://msdn.microsoft.com/library/de...r_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
>
|||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/de...r_sa2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>
|||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...[vbcol=seagreen]
> 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:

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 thr
ottling 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@.TK2MSFTNG
P12.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 h
as
> been exceeded by 1 queries and performance may be adversely affected."
> thanks
>|||Hi
This may help if you are using MSDE
_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d...r />
_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
>|||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 Viewe
r
logs.
"John Bell" wrote:

> Hi
> This may help if you are using MSDE
> a2_5fs6.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
a2_5fs6.asp
> John
> "harun" <kazi[remove]@.wideopenwest.com> wrote in message
> news:ea4O43tUEHA.1604@.TK2MSFTNGP12.phx.gbl...
> has
>
>|||My guess is that you have two instances or more of SQL Server and an MSDE in
stance 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...[vbcol=seagreen]
> Folks--
> Has anyone gotten this message when they have installed SQL Server Standar
d
> Edition ? I installed Standard Edition from original media purchased from
> CDW, and am now seeing this error message very frequently in the Event Vie
wer
> logs.
>
> "John Bell" wrote:
>

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
> > >
> > >
> >
> >
> >

Concurrent queries in SQL Server 2005 Express

If applicable, what's the limit on concurrent queries supported by SQL Server 2005 Express? Also, if there's a limit, does next connection after the max errors out or merely queues up?

Thanks,

Phillip

hi Pjhillip,

PhillipM wrote:

If applicable, what's the limit on concurrent queries supported by SQL Server 2005 Express? Also, if there's a limit, does next connection after the max errors out or merely queues up?

Thanks,

Phillip

as in MSDE 2000 (and full blown SQL Server's editions), there's a "tecnical" limit of 32767 connections... and this can not be workarounded..

MSDE has another "limit", a built in Governer, but it does not prevent futher connections when the magic number of 8 concurrent workloads is reached.. it simply linearly slows down every I/O activity for all active connections...

SQLExpress does not include this query governor, but addresses the edition limitation reducing memory the process can address to 1gb (instead of 2gb for MSDE)...

this 1gb of memory includes all memory segments used by the server, so that data (and pages) cahed as long as query plans, memory structures for locks and additional providers are held within this "container"...
connections cost as well in term of memory strucures, so they are held within the very same limited "container"...

so, when no additional resources are available for the "next connection", the connecting process will hang up waiting for released resources... as soon as this task times out (connection timeout property), an exception will be raised...

regards

|||

Andrea,

Thanks a lot! I should extend my query timeout property then to be on the safe side.

Phillip

Concurrent queries exceeded

I am getting the following error message on a test SQL
Server:
'This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 7 queries and
performance may be adversely affected.'
However, I can't seem to find any reference to this
anywhere let alone how to actually change the number of
concurrent queries!
Has anybody else had this problem or know's how to chnage
the setting?
Cheers
Lee.Looks like you are running MSDE. MSDE is optimized for 5 client and 3 server
process concurrent queries.
MSDE is free but is governed to limit performance.
If you need more concurrent connections and queries, you need to install a
full version of SQL Server.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Lee Pantling" <Lee.Pantling@.SGP.co.uk> wrote in message
news:054f01c3d9e4$83b146b0$a001280a@.phx.gbl...
> I am getting the following error message on a test SQL
> Server:
> 'This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 7 queries and
> performance may be adversely affected.'
> However, I can't seem to find any reference to this
> anywhere let alone how to actually change the number of
> concurrent queries!
> Has anybody else had this problem or know's how to chnage
> the setting?
> Cheers
> Lee.|||This is generated by the workload governor that is in SQL Server 2000
Personal Edition and SQL Server 2000 Desktop Engine (MSDE 2000). Information
about the governor is at this Web page:
http://www.microsoft.com/sql/msde/techinfo/workloadgov.asp
You cannot change the setting of the workload governor. If it is limiting
the performance of your instance of SQL Server, you would have to upgrade to
SQL Server 2000 Standard Edition or Enterprise Edition to get a version of
SQL Server that does not have the governor. If the governor is not getting
invoked often, it may not have much of an effect on the performance of your
systsem.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Concurrent queries exceeded

I am getting the following error message on a test SQL
Server:
'This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 7 queries and
performance may be adversely affected.'
However, I can't seem to find any reference to this
anywhere let alone how to actually change the number of
concurrent queries!
Has anybody else had this problem or know's how to chnage
the setting?
Cheers
Lee.Looks like you are running MSDE. MSDE is optimized for 5 client and 3 server
process concurrent queries.
MSDE is free but is governed to limit performance.
If you need more concurrent connections and queries, you need to install a
full version of SQL Server.
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.NOSPAMepprecht.net
Specialist SQL Server Solutions and Consulting
"Lee Pantling" <Lee.Pantling@.SGP.co.uk> wrote in message
news:054f01c3d9e4$83b146b0$a001280a@.phx.gbl...

quote:

---

> I am getting the following error message on a test SQL
> Server:
> 'This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 7 queries and
> performance may be adversely affected.'
> However, I can't seem to find any reference to this
> anywhere let alone how to actually change the number of
> concurrent queries!
> Has anybody else had this problem or know's how to chnage
> the setting?
> Cheers
> Lee.

---

|||This is generated by the workload governor that is in SQL Server 2000
Personal Edition and SQL Server 2000 Desktop Engine (MSDE 2000). Information
about the governor is at this Web page:
http://www.microsoft.com/sql/msde/t...workloadgov.asp
You cannot change the setting of the workload governor. If it is limiting
the performance of your instance of SQL Server, you would have to upgrade to
SQL Server 2000 Standard Edition or Enterprise Edition to get a version of
SQL Server that does not have the governor. If the governor is not getting
invoked often, it may not have much of an effect on the performance of your
systsem.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights