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