Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar
You are running either MSDE or Personal Edition and have hit the roof of that edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to Standard or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar
|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||Run:
select serverproperty ('Edition')
and post the results.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>
|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||Why didn't you run the query I gave you?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can[vbcol=seagreen]
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade
> has
>
|||http://www.microsoft.com/sql/techinf...skChooseEd.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> can
> degrades
> space
> upgrade
>
|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techinf...skChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
How[vbcol=seagreen]
have[vbcol=seagreen]
of[vbcol=seagreen]
limit[vbcol=seagreen]
affected.
>

Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani OmarYou are running either MSDE or Personal Edition and have hit the roof of tha
t edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to
Standard or Enterprise Edition.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...[v
bcol=seagreen]
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit ha
s
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>[/vbcol]|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
can someone help me please?
Thank you
Milani Omar|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Run:
select serverproperty ('Edition')
and post the results.
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||Why didn't you run the query I gave you?
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
degrades[vbcol=seagreen]
space[vbcol=seagreen]
upgrade[vbcol=seagreen]
> has
>|||http://www.microsoft.com/sql/techin...eskChooseEd.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...

> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> can
> degrades
> space
> upgrade
>|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techin...eskChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
How[vbcol=seagreen]
have[vbcol=seagreen]
of[vbcol=seagreen]
limit[vbcol=seagreen]
affected.[vbcol=seagreen]
>

Concurrent query problem

hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
--
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 ?B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
--
can someone help me please?
Thank you
Milani OmarYou are running either MSDE or Personal Edition and have hit the roof of that edition. I.e., the performance
throttling has kicked in. This is a good indication that you want to move to Standard or Enterprise Edition.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 oB.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||You are running either MSDE or SQL Server 2000 Professional. These have
been optimized for 8 concurrently running queries and performance degrades
when you have more queries running at the same time. Either you can space
out your queries so that fewer are running concurrently or you can upgrade
to a server version of SQL Server.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
hello,
I have an SQL SERVER 2000.
sometimes this server become slow. In the event log I see this king of
informations:
--
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 22.04.2004
Time: 15:01:12
User: N/A
Computer: ***
Description:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has
been exceeded by 1 queries and performance may be adversely affected.
Data:
0000: 9c 42 00 00 0a 00 00 00 ?B.....
0008: 04 00 00 00 53 00 51 00 ...S.Q.
0010: 4c 00 00 00 07 00 00 00 L......
0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
0020: 65 00 72 00 00 00 e.r...
--
can someone help me please?
Thank you
Milani Omar|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Run:
select serverproperty ('Edition')
and post the results.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> You are running either MSDE or SQL Server 2000 Professional. These have
> been optimized for 8 concurrently running queries and performance degrades
> when you have more queries running at the same time. Either you can space
> out your queries so that fewer are running concurrently or you can upgrade
> to a server version of SQL Server.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> hello,
> I have an SQL SERVER 2000.
> sometimes this server become slow. In the event log I see this king of
> informations:
> --
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 22.04.2004
> Time: 15:01:12
> User: N/A
> Computer: ***
> Description:
> 17052 :
> This SQL Server has been optimized for 8 concurrent queries. This limit
has
> been exceeded by 1 queries and performance may be adversely affected.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> 0010: 4c 00 00 00 07 00 00 00 L......
> 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> 0020: 65 00 72 00 00 00 e.r...
> --
> can someone help me please?
> Thank you
> Milani Omar
>
>|||Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||Why didn't you run the query I gave you?
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Milani Omar" <omar@.tio.ch> wrote in message
news:eN3PbxHKEHA.2452@.TK2MSFTNGP09.phx.gbl...
Hello,
I'm running che SQL Server 2000 Standard edition. But I'm not sure. How can
I see witch version I'm running?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||result:
Personal Edition
Sorry, how can I upgrade it to the standard edition?
What is the difference between the Standard and Enterprise edition?
Thank you
Milani Omar
"Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> Run:
> select serverproperty ('Edition')
> and post the results.
> --
> Tom
> ---
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
> "Milani Omar" <omar@.tio.ch> wrote in message
> news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hello,
> I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
can
> I see witch version I'm running?
>
> Thank you
> Milani Omar
>
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > You are running either MSDE or SQL Server 2000 Professional. These have
> > been optimized for 8 concurrently running queries and performance
degrades
> > when you have more queries running at the same time. Either you can
space
> > out your queries so that fewer are running concurrently or you can
upgrade
> > to a server version of SQL Server.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > hello,
> > I have an SQL SERVER 2000.
> > sometimes this server become slow. In the event log I see this king of
> > informations:
> >
> > --
> >
> > Event Type: Information
> > Event Source: MSSQLSERVER
> > Event Category: (2)
> > Event ID: 17055
> > Date: 22.04.2004
> > Time: 15:01:12
> > User: N/A
> > Computer: ***
> > Description:
> > 17052 :
> > This SQL Server has been optimized for 8 concurrent queries. This limit
> has
> > been exceeded by 1 queries and performance may be adversely affected.
> >
> > Data:
> > 0000: 9c 42 00 00 0a 00 00 00 ?B.....
> > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > 0010: 4c 00 00 00 07 00 00 00 L......
> > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > 0020: 65 00 72 00 00 00 e.r...
> >
> > --
> >
> > can someone help me please?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
>|||http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Milani Omar" <omar@.tio.ch> wrote in message news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> result:
> Personal Edition
> Sorry, how can I upgrade it to the standard edition?
> What is the difference between the Standard and Enterprise edition?
> Thank you
> Milani Omar
>
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > Run:
> >
> > select serverproperty ('Edition')
> >
> > and post the results.
> >
> > --
> > Tom
> >
> > ---
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> > I'm running che SQL Server 2000 Standard edition. But I'm not sure. How
> can
> > I see witch version I'm running?
> >
> >
> > Thank you
> > Milani Omar
> >
> >
> >
> >
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > You are running either MSDE or SQL Server 2000 Professional. These have
> > > been optimized for 8 concurrently running queries and performance
> degrades
> > > when you have more queries running at the same time. Either you can
> space
> > > out your queries so that fewer are running concurrently or you can
> upgrade
> > > to a server version of SQL Server.
> > >
> > > --
> > > Tom
> > >
> > > ---
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > >
> > >
> > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > hello,
> > > I have an SQL SERVER 2000.
> > > sometimes this server become slow. In the event log I see this king of
> > > informations:
> > >
> > > --
> > >
> > > Event Type: Information
> > > Event Source: MSSQLSERVER
> > > Event Category: (2)
> > > Event ID: 17055
> > > Date: 22.04.2004
> > > Time: 15:01:12
> > > User: N/A
> > > Computer: ***
> > > Description:
> > > 17052 :
> > > This SQL Server has been optimized for 8 concurrent queries. This limit
> > has
> > > been exceeded by 1 queries and performance may be adversely affected.
> > >
> > > Data:
> > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > 0020: 65 00 72 00 00 00 e.r...
> > >
> > > --
> > >
> > > can someone help me please?
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> >
> >
>|||Hello,
how can I upgrade it to standard edition. We have buyed bevore the license
for satandard edition but I have installed the pro edition erroneously.
Thank you
Milani Omar
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "Milani Omar" <omar@.tio.ch> wrote in message
news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> > result:
> > Personal Edition
> >
> > Sorry, how can I upgrade it to the standard edition?
> >
> > What is the difference between the Standard and Enterprise edition?
> >
> > Thank you
> > Milani Omar
> >
> >
> >
> >
> > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > > Run:
> > >
> > > select serverproperty ('Edition')
> > >
> > > and post the results.
> > >
> > > --
> > > Tom
> > >
> > > ---
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > >
> > >
> > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > > I'm running che SQL Server 2000 Standard edition. But I'm not sure.
How
> > can
> > > I see witch version I'm running?
> > >
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > > You are running either MSDE or SQL Server 2000 Professional. These
have
> > > > been optimized for 8 concurrently running queries and performance
> > degrades
> > > > when you have more queries running at the same time. Either you can
> > space
> > > > out your queries so that fewer are running concurrently or you can
> > upgrade
> > > > to a server version of SQL Server.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ---
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > SQL Server MVP
> > > > Columnist, SQL Server Professional
> > > > Toronto, ON Canada
> > > > www.pinnaclepublishing.com/sql
> > > >
> > > >
> > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > > hello,
> > > > I have an SQL SERVER 2000.
> > > > sometimes this server become slow. In the event log I see this king
of
> > > > informations:
> > > >
> > > > --
> > > >
> > > > Event Type: Information
> > > > Event Source: MSSQLSERVER
> > > > Event Category: (2)
> > > > Event ID: 17055
> > > > Date: 22.04.2004
> > > > Time: 15:01:12
> > > > User: N/A
> > > > Computer: ***
> > > > Description:
> > > > 17052 :
> > > > This SQL Server has been optimized for 8 concurrent queries. This
limit
> > > has
> > > > been exceeded by 1 queries and performance may be adversely
affected.
> > > >
> > > > Data:
> > > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > > 0020: 65 00 72 00 00 00 e.r...
> > > >
> > > > --
> > > >
> > > > can someone help me please?
> > > >
> > > > Thank you
> > > > Milani Omar
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Milani,
SQL2000 personal edition can be upgraded to SQL2000 standard edition.Refer
the below snippet from BooksOnLine topic 'Upgrading an Existing Installation
of SQL Server' for the upgrade procedure:
<begin quote>
How to perform an edition upgrade within SQL Server 2000 (Setup)
To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000
1.. Insert the Microsoft® SQL Server 2000T compact disc for the edition
you want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.
2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.
3.. In Computer Name dialog box, select Local Computer or Remote computer.
4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.
5.. In the Instance Name dialog box, click Next.
6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.
7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.
8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next.
You can select an item in the Components list, and then select items from
the related Sub-Components list. Click to select items you want to install;
clear the check box of the items you do not want to install.
9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.
10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.
<end quote>
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Milani Omar" <omar@.tio.ch> wrote in message
news:#bGzToIKEHA.1272@.tk2msftngp13.phx.gbl...
> Hello,
> how can I upgrade it to standard edition. We have buyed bevore the license
> for satandard edition but I have installed the pro edition erroneously.
> Thank you
> Milani Omar
>
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
> scritto nel messaggio news:OxiUrhIKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> > http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "Milani Omar" <omar@.tio.ch> wrote in message
> news:%23BtmUOIKEHA.4004@.TK2MSFTNGP11.phx.gbl...
> > > result:
> > > Personal Edition
> > >
> > > Sorry, how can I upgrade it to the standard edition?
> > >
> > > What is the difference between the Standard and Enterprise edition?
> > >
> > > Thank you
> > > Milani Omar
> > >
> > >
> > >
> > >
> > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > news:eN%23G9THKEHA.3592@.TK2MSFTNGP09.phx.gbl...
> > > > Run:
> > > >
> > > > select serverproperty ('Edition')
> > > >
> > > > and post the results.
> > > >
> > > > --
> > > > Tom
> > > >
> > > > ---
> > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > SQL Server MVP
> > > > Columnist, SQL Server Professional
> > > > Toronto, ON Canada
> > > > www.pinnaclepublishing.com/sql
> > > >
> > > >
> > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > news:ux1naRHKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > > > Hello,
> > > > I'm running che SQL Server 2000 Standard edition. But I'm not sure.
> How
> > > can
> > > > I see witch version I'm running?
> > > >
> > > >
> > > > Thank you
> > > > Milani Omar
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Tom Moreau" <tom@.dont.spam.me.cips.ca> ha scritto nel messaggio
> > > > news:%23UFtmAHKEHA.2380@.TK2MSFTNGP09.phx.gbl...
> > > > > You are running either MSDE or SQL Server 2000 Professional.
These
> have
> > > > > been optimized for 8 concurrently running queries and performance
> > > degrades
> > > > > when you have more queries running at the same time. Either you
can
> > > space
> > > > > out your queries so that fewer are running concurrently or you can
> > > upgrade
> > > > > to a server version of SQL Server.
> > > > >
> > > > > --
> > > > > Tom
> > > > >
> > > > > ---
> > > > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > > > > SQL Server MVP
> > > > > Columnist, SQL Server Professional
> > > > > Toronto, ON Canada
> > > > > www.pinnaclepublishing.com/sql
> > > > >
> > > > >
> > > > > "Milani Omar" <omar@.tio.ch> wrote in message
> > > > > news:eRQZI9GKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> > > > > hello,
> > > > > I have an SQL SERVER 2000.
> > > > > sometimes this server become slow. In the event log I see this
king
> of
> > > > > informations:
> > > > >
> > > > > --
> > > > >
> > > > > Event Type: Information
> > > > > Event Source: MSSQLSERVER
> > > > > Event Category: (2)
> > > > > Event ID: 17055
> > > > > Date: 22.04.2004
> > > > > Time: 15:01:12
> > > > > User: N/A
> > > > > Computer: ***
> > > > > Description:
> > > > > 17052 :
> > > > > This SQL Server has been optimized for 8 concurrent queries. This
> limit
> > > > has
> > > > > been exceeded by 1 queries and performance may be adversely
> affected.
> > > > >
> > > > > Data:
> > > > > 0000: 9c 42 00 00 0a 00 00 00 oB.....
> > > > > 0008: 04 00 00 00 53 00 51 00 ...S.Q.
> > > > > 0010: 4c 00 00 00 07 00 00 00 L......
> > > > > 0018: 6d 00 61 00 73 00 74 00 m.a.s.t.
> > > > > 0020: 65 00 72 00 00 00 e.r...
> > > > >
> > > > > --
> > > > >
> > > > > can someone help me please?
> > > > >
> > > > > Thank you
> > > > > Milani Omar
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>

Concurrent queries

I have an accounting program that is runing very slow. The
only error that shows in the errorlog is "spid12 This SQL
Server has been optimized for 8 concurrent queries. this
limit has been exceeded by 12 queries and performance may
be adversely affected." What dose this mean? the program
runs on SQL Server 2000.
Thaks,Daniel,
It means that you are running either MSDE or SQL2000 personal engine and
this behavior is by design.They are not meant for heavy workload and you may
want to upgrade to a retail edition.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel Barnaby" <dbarnaby@.beltonschools.org> wrote in message
news:658101c37d52$ff644ee0$a601280a@.phx.gbl...
> I have an accounting program that is runing very slow. The
> only error that shows in the errorlog is "spid12 This SQL
> Server has been optimized for 8 concurrent queries. this
> limit has been exceeded by 12 queries and performance may
> be adversely affected." What dose this mean? the program
> runs on SQL Server 2000.
> Thaks,

Conceptual and speed question

Conceptual and speed question
Hi,
My program seems to slow down drastically because as I fill my array and
table with many values, the program suffers tremendously. The first thing my
program does is to search the jagged array to try to find an element in that
array. If it does not find that element in that array, then it adds another
element and that is the problem. Once I have many elements in that array, it
takes a long time to do a search. Furthermore, not only do I add an element
to that array if it does not find it, but I also add it to my table and as
my table gets bigger, it also slows everything down drastically.
What I thought may be possible is to create many arrays instead of only 1
array and that would speed up the search. The problem is that I do not know
what the size of each array will be at the beginning as some of the arrays
might be much larger than others. Is there a way to declare arrays and then
to dynamically increase their size when needed, and if it is possible would
this hamper the performance because my arrays will be quite large. I also
thought of maybe sorting the array, but that would take too long. Is there a
way to index an array to speed up the search?
As for my table in the database, I was wandering if I created many tables
would that also help speed up the process or will it not make a difference
because it is in the same database. And if that is the case that it does not
make a difference in speed because it is in the same database, then can I
save it to a different database? Another possibility I thought of is to save
the rows to another database and delete the rows in original database after
a certain number of rows have been added.
TIA
Roy"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:qKrff.23031$AZ3.235633@.wagner.videotron.net...
> Conceptual and speed question
>
> Hi,
>
> My program seems to slow down drastically because as I fill my array and
> table with many values, the program suffers tremendously. The first thing
> my program does is to search the jagged array to try to find an element in
> that array. If it does not find that element in that array, then it adds
> another element and that is the problem. Once I have many elements in that
> array, it takes a long time to do a search. Furthermore, not only do I add
> an element to that array if it does not find it, but I also add it to my
> table and as my table gets bigger, it also slows everything down
> drastically.
>
> What I thought may be possible is to create many arrays instead of only 1
> array and that would speed up the search. The problem is that I do not
> know what the size of each array will be at the beginning as some of the
> arrays might be much larger than others. Is there a way to declare arrays
> and then to dynamically increase their size when needed, and if it is
> possible would this hamper the performance because my arrays will be quite
> large. I also thought of maybe sorting the array, but that would take too
> long. Is there a way to index an array to speed up the search?
>
> As for my table in the database, I was wandering if I created many tables
> would that also help speed up the process or will it not make a difference
> because it is in the same database. And if that is the case that it does
> not make a difference in speed because it is in the same database, then
> can I save it to a different database? Another possibility I thought of is
> to save the rows to another database and delete the rows in original
> database after a certain number of rows have been added.
>
> TIA
> Roy
>
I'll skip the question about arrays. There are no arrays in SQL Server and
you didn't mention what other product you might be using.
On the database side you should first be considering what indexes might
support your application better. Indexes are likely to have much more impact
on performance than splitting the table up.
David Portas
SQL Server MVP
--|||Array, what programming language are you using? This group is for SQL Server
T-SQL.
Loading a large resultset into an application array is very slow, especially
if you are using something like ReDim to increase the size of the array each
time you loop through a client side cursor. Whatever, you are doing with an
array, consider just using an ADO recordset.
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:qKrff.23031$AZ3.235633@.wagner.videotron.net...
> Conceptual and speed question
>
> Hi,
>
> My program seems to slow down drastically because as I fill my array and
> table with many values, the program suffers tremendously. The first thing
> my program does is to search the jagged array to try to find an element in
> that array. If it does not find that element in that array, then it adds
> another element and that is the problem. Once I have many elements in that
> array, it takes a long time to do a search. Furthermore, not only do I add
> an element to that array if it does not find it, but I also add it to my
> table and as my table gets bigger, it also slows everything down
> drastically.
>
> What I thought may be possible is to create many arrays instead of only 1
> array and that would speed up the search. The problem is that I do not
> know what the size of each array will be at the beginning as some of the
> arrays might be much larger than others. Is there a way to declare arrays
> and then to dynamically increase their size when needed, and if it is
> possible would this hamper the performance because my arrays will be quite
> large. I also thought of maybe sorting the array, but that would take too
> long. Is there a way to index an array to speed up the search?
>
> As for my table in the database, I was wandering if I created many tables
> would that also help speed up the process or will it not make a difference
> because it is in the same database. And if that is the case that it does
> not make a difference in speed because it is in the same database, then
> can I save it to a different database? Another possibility I thought of is
> to save the rows to another database and delete the rows in original
> database after a certain number of rows have been added.
>
> TIA
> Roy
>|||Hi,
Sorry, I am using C# and SQL Server 2005 Express edition.

> On the database side you should first be considering what indexes might
> support your application better. Indexes are likely to have much more
> impact on performance than splitting the table up.
What do you mean by indexes. I am not searching the database, as I am only
adding a row sequentially. The only search that I am doing is in my jagged
array and if the search fails to find the element in the array, then it is
added to the array and then to the table. So you see, I am just using the
table as a permanent repository, the search is conducted in the database.
The problem is that I have millions of rows to fill and as the table gets
larger, it slows down drastically.
Any suggestions.
Thanks
Roy
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:xJadnQanRPrN0ePeRVnyjA@.giganews.com...
> "Roy Gourgi" <royng@.videotron.ca> wrote in message
> news:qKrff.23031$AZ3.235633@.wagner.videotron.net...
> I'll skip the question about arrays. There are no arrays in SQL Server and
> you didn't mention what other product you might be using.
> On the database side you should first be considering what indexes might
> support your application better. Indexes are likely to have much more
> impact on performance than splitting the table up.
> --
> David Portas
> SQL Server MVP
> --
>|||Sorry there is an error, as this:
So you see, I am just using the table as a permanent repository, the search
is conducted in the database.
should be:
So you see, I am just using the table as a permanent repository, the search
is conducted in the array.
Roy
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:ufsff.23045$AZ3.243450@.wagner.videotron.net...
> Hi,
> Sorry, I am using C# and SQL Server 2005 Express edition.
>
> What do you mean by indexes. I am not searching the database, as I am only
> adding a row sequentially. The only search that I am doing is in my jagged
> array and if the search fails to find the element in the array, then it is
> added to the array and then to the table. So you see, I am just using the
> table as a permanent repository, the search is conducted in the database.
> The problem is that I have millions of rows to fill and as the table gets
> larger, it slows down drastically.
> Any suggestions.
> Thanks
> Roy
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:xJadnQanRPrN0ePeRVnyjA@.giganews.com...
>|||"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:ufsff.23045$AZ3.243450@.wagner.videotron.net...
> Hi,
> Sorry, I am using C# and SQL Server 2005 Express edition.
>
> What do you mean by indexes. I am not searching the database, as I am only
> adding a row sequentially. The only search that I am doing is in my jagged
> array and if the search fails to find the element in the array, then it is
> added to the array and then to the table. So you see, I am just using the
> table as a permanent repository, the search is conducted in the database.
> The problem is that I have millions of rows to fill and as the table gets
> larger, it slows down drastically.
> Any suggestions.
> Thanks
> Roy
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:xJadnQanRPrN0ePeRVnyjA@.giganews.com...
>
If you really don't know what indexes are then you have a LOT to learn. I
suggest you purchase a book or take a course in that case. Newsgroups are
not the place for a tutorial.
How do you explain: "I am not searching the database, as I am only adding a
row sequentially" followed by: "the search is conducted in the database"? So
are you searching or not? Common sense says that if you are generating
millions of rows then you will want to search them at some point. For that
indexes will be essential. However, generating large quantities of data on a
desktop spec machine (if that is in fact what you are doing with SQL
Express) is likely to result in a lot of RAM paging to disk. SQL Server
works best with lots of RAM to itself.
David Portas
SQL Server MVP
--|||"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:phsff.23046$AZ3.243820@.wagner.videotron.net...
> Sorry there is an error, as this:
> So you see, I am just using the table as a permanent repository, the
> search is conducted in the database.
> should be:
> So you see, I am just using the table as a permanent repository, the
> search is conducted in the array.
> Roy
> "Roy Gourgi" <royng@.videotron.ca> wrote in message
> news:ufsff.23045$AZ3.243450@.wagner.videotron.net...
>
You mean you persist the entire set of data in the array AND in the
database? That's going to be extremely inefficient. On a single box both
will compete for resources. Search in the DATABASE - that's what it's for.
If you just want a bit bucket then write to a file not to SQL Server.
David Portas
SQL Server MVP
--|||Hi,
If you saw my next post I said that I made an error and that it should have
been the search is conducted in the array and not database.
I will take your advice and try adding some more memory, as I think that may
be one of the problems.
Thanks
Roy

> If you really don't know what indexes are then you have a LOT to learn. I
> suggest you purchase a book or take a course in that case. Newsgroups are
> not the place for a tutorial.
> How do you explain: "I am not searching the database, as I am only adding
> a row sequentially" followed by: "the search is conducted in the
> database"? So are you searching or not? Common sense says that if you are
> generating millions of rows then you will want to search them at some
> point. For that indexes will be essential. However, generating large
> quantities of data on a desktop spec machine (if that is in fact what you
> are doing with SQL Express) is likely to result in a lot of RAM paging to
> disk. SQL Server works best with lots of RAM to itself.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:EdidnYWlGfGpzuPeRVnyrg@.giganews.com...
> "Roy Gourgi" <royng@.videotron.ca> wrote in message
> news:ufsff.23045$AZ3.243450@.wagner.videotron.net...
> If you really don't know what indexes are then you have a LOT to learn. I
> suggest you purchase a book or take a course in that case. Newsgroups are
> not the place for a tutorial.
> How do you explain: "I am not searching the database, as I am only adding
> a row sequentially" followed by: "the search is conducted in the
> database"? So are you searching or not? Common sense says that if you are
> generating millions of rows then you will want to search them at some
> point. For that indexes will be essential. However, generating large
> quantities of data on a desktop spec machine (if that is in fact what you
> are doing with SQL Express) is likely to result in a lot of RAM paging to
> disk. SQL Server works best with lots of RAM to itself.
> --
> David Portas
> SQL Server MVP
> --
>|||Hi,
I only search the value in the array first. If the value is not found, then
I added to the array and then to the table. So you see I need the search the
array to determine whether I have to add it to the table or not.
I thought that it would be much slower if I searched the database rather
than the array, correct me if I am wrong. Furthermore, you say that if I
only want to save it then I should use a normal text file. Would that make
it faster than saving it to a database.
Thanks
Roy

> You mean you persist the entire set of data in the array AND in the
> database? That's going to be extremely inefficient. On a single box both
> will compete for resources. Search in the DATABASE - that's what it's for.
> If you just want a bit bucket then write to a file not to SQL Server.
> --
> David Portas
> SQL Server MVP
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:D-2dnUa4HoOdyePeRVnyuA@.giganews.com...
> "Roy Gourgi" <royng@.videotron.ca> wrote in message
> news:phsff.23046$AZ3.243820@.wagner.videotron.net...
> You mean you persist the entire set of data in the array AND in the
> database? That's going to be extremely inefficient. On a single box both
> will compete for resources. Search in the DATABASE - that's what it's for.
> If you just want a bit bucket then write to a file not to SQL Server.
> --
> David Portas
> SQL Server MVP
> --
>|||"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:gDsff.23050$AZ3.249690@.wagner.videotron.net...
> Hi,
> I only search the value in the array first. If the value is not found,
> then I added to the array and then to the table. So you see I need the
> search the array to determine whether I have to add it to the table or
> not.
> I thought that it would be much slower if I searched the database rather
> than the array, correct me if I am wrong. Furthermore, you say that if I
> only want to save it then I should use a normal text file. Would that make
> it faster than saving it to a database.
> Thanks
> Roy
>
>
>
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
> news:D-2dnUa4HoOdyePeRVnyuA@.giganews.com...
>

> I only search the value in the array first. If the value is not found,
> then I added to the array and then to the table. So you see I need the
> search the array to determine whether I have to add it to the table or
> not.
>
You can do that in one operation if you use the database:
INSERT INTO your_table (x, y, ...)
SELECT ?, ?, ...
WHERE NOT EXISTS
(SELECT *
FROM your_table
WHERE x = ?
AND y = ?) ;
If x and y are unique and indexed then this is very efficient.

> I thought that it would be much slower if I searched the database rather
> than the array, correct me if I am wrong. Furthermore, you say that if I
> only want to save it then I should use a normal text file. Would that make
> it faster than saving it to a database.
SQL Server is an extremely efficient way to search and process large
quantities of data. What is inefficient is to keep retrieving the data for
processing outside the database and then to persist large data sets outside
the database as well. Why can't you implement whatever your array is doing
in the database itself? Of course I can't be certain that it will be more
efficient that way but I am pretty certain that there must be a more
efficient method than what you are describing.
David Portas
SQL Server MVP
--