8 concurrent queries?

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.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" wrote in message news:ubHAVExdDHA.748@.T=K2MSFTNGP10.phx.gbl...This occurs many times in our w2k event view application log with =variouschoices of numbers exceeded by.What is it referring to and how do I =increase the number of concurrentqueries?Thanks.17052 :This SQL Server has been optimized for 8 concurrent queries. =This limit hasbeen exceeded by 10 queries and performance may be adversely affected.

---

--=_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.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
> >.
> >

403 error: The remote server returned an error: (403) Forbidden.

When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2007-7-16
Time: 11:28:29
User: N/A
Computer: WEIGUANG
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2007-7-16 11:28:29
Event time (UTC): 2007-7-16 3:28:29
Event ID: 3c4daa414c89430786c106f3c9085b56
Event sequence: 10
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-2-128290300818412520
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: WEIGUANG
Process information:
Process ID: 4152
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 127.0.0.1
User: ASIAPACIFIC\liweig
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm using reporting service 2005, does anybody know the reason?

Many thanks.

Kevin

we encounter the same problem. did you already resolved it? can you give us a hint?

thx in advance,
rainer
|||

IIS permissions.

403?

You're not even touching the Report Server.

You need to get your IIS admin to allow your group/users permission to see the RS folders

|||well i am getting the following entry in the eventlog:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 24.07.2007
Time: 12:37:38
User: N/A
Computer: HERAS75
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24.07.2007 12:37:38
Event time (UTC): 24.07.2007 10:37:38
Event ID: f6730dc158f640c7924c590d73226477
Event sequence: 112
Event occurrence: 5
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/root/AdminReports-1-128297459440092913
Trust level: RosettaMgr
Application Virtual Path: /AdminReports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: HERAS75

Process information:
Process ID: 5052
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.

Request information:
Request URL: http://heras75/AdminReports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /AdminReports/Reserved.ReportViewerWebControl.axd
User host address: 10.101.7.26
User: HER\admin_arnken
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

if am opening a report page it starts rendering the page but then throws the following error and no data is shown:

The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
directory security
edit
select 'integrated windows authentication'
ok

right click 'permissions'
from here you can see which groups/users have access

it is better to administer with groups as that way, when someone bothers you to see a report, you can tell them to go and see the helpdesk/whoever manages AD groups instead, and get them to add them to the group

403 error: The remote server returned an error: (403) Forbidden.

When I try to view the report, I got the error "The remote server returned an error: (403) Forbidden. ". And in the event log , I got the detaiil excception:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 2007-7-16
Time: 11:28:29
User: N/A
Computer: WEIGUANG
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2007-7-16 11:28:29
Event time (UTC): 2007-7-16 3:28:29
Event ID: 3c4daa414c89430786c106f3c9085b56
Event sequence: 10
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-2-128290300818412520
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: WEIGUANG
Process information:
Process ID: 4152
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.
Request information:
Request URL: http://localhost/Reports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 127.0.0.1
User: ASIAPACIFIC\liweig
Is authenticated: True
Authentication Type: NTLM
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I'm using reporting service 2005, does anybody know the reason?

Many thanks.

Kevin

we encounter the same problem. did you already resolved it? can you give us a hint?

thx in advance,
rainer
|||

IIS permissions.

403?

You're not even touching the Report Server.

You need to get your IIS admin to allow your group/users permission to see the RS folders

|||well i am getting the following entry in the eventlog:

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 24.07.2007
Time: 12:37:38
User: N/A
Computer: HERAS75
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24.07.2007 12:37:38
Event time (UTC): 24.07.2007 10:37:38
Event ID: f6730dc158f640c7924c590d73226477
Event sequence: 112
Event occurrence: 5
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/root/AdminReports-1-128297459440092913
Trust level: RosettaMgr
Application Virtual Path: /AdminReports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: HERAS75

Process information:
Process ID: 5052
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: WebException
Exception message: The remote server returned an error: (403) Forbidden.

Request information:
Request URL: http://heras75/AdminReports/Reserved.ReportViewerWebControl.axd?OpType=StyleSheet&Version=2005.090.3042.00
Request path: /AdminReports/Reserved.ReportViewerWebControl.axd
User host address: 10.101.7.26
User: HER\admin_arnken
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WebForms.ServerReport.GetStyleSheet(String styleSheetName)
at Microsoft.Reporting.WebForms.ReportServerStyleSheetOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

if am opening a report page it starts rendering the page but then throws the following error and no data is shown:

The remote server returned an error: (403) Forbidden.|||Admin tools -> IIS
directory security
edit
select 'integrated windows authentication'
ok

right click 'permissions'
from here you can see which groups/users have access

it is better to administer with groups as that way, when someone bothers you to see a report, you can tell them to go and see the helpdesk/whoever manages AD groups instead, and get them to add them to the group

4 processors detected - but we only have two?

Each time our server is rebooted, and SQL Server restarts, it posts an event
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
MarkIt's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pí¹e v diskusním pøíspìvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an event
> log message like the one below. The thing is, we only have two processors.
> Does this indicate a misconfiguration, a problem, or nothing to be concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>

3455: Analysis of database is 100% complete

We're running SQL std. ed., v. 8.00.2039, SP4 using 'no-sync' replication (8
sites). In the Application log of the Event Viewer I get the following
message in groups of 3 every 15 minutes, "3455: Analysis of database
XXPROLAW' (7) is 100% complete (approximately 0 seconds)." I can't identify
what is triggering this analysis and it may be interferring with other
scheduled jobs causing them to fail. Couldn't find anything on Google or MS
N
K-base.
--
Steven PattonTry removing Auto Close from the database.
Found on another newsgroup and it works (but I don't know why).

3455: Analysis of database is 100% complete

We're running SQL std. ed., v. 8.00.2039, SP4 using 'no-sync' replication (8
sites). In the Application log of the Event Viewer I get the following
message in groups of 3 every 15 minutes, "3455: Analysis of database
XXPROLAW' (7) is 100% complete (approximately 0 seconds)." I can't identify
what is triggering this analysis and it may be interferring with other
scheduled jobs causing them to fail. Couldn't find anything on Google or MSN
K-base.
--
Steven PattonTry removing Auto Close from the database.
Found on another newsgroup and it works (but I don't know why).