Concurrent query optimization

I have a server with Windows 2000, SQL Server 2000, 2 1GHz
processors and 1.5GHz of memory. The users were
complaining of slowness today from tehir web application.
The only message that I found in any of the logs was the
following:
This SQL Server has been optimized for 8 concurrent
queries. This limit has been exceeded by 2 queries and
performance may be adversely affected.
I don't know if this is giving me any info cuz I don't
know what the message means. Is there anywhere (or
anyone) that can explain this to me?This probably means that you are not using Standard Edition or
Enterprise Edition of SQL-Server, but the MSDE or some other version
that cannot be licensed for real production loads.
The statement
SELECT @.@.version
should tell you which edition is installed.
Gert-Jan
Tom Griffin wrote:
> I have a server with Windows 2000, SQL Server 2000, 2 1GHz
> processors and 1.5GHz of memory. The users were
> complaining of slowness today from tehir web application.
> The only message that I found in any of the logs was the
> following:
> This SQL Server has been optimized for 8 concurrent
> queries. This limit has been exceeded by 2 queries and
> performance may be adversely affected.
> I don't know if this is giving me any info cuz I don't
> know what the message means. Is there anywhere (or
> anyone) that can explain this to me?|||Thanks for your reply. You are correct; this server was
installed with SQL Server 2000 Personal Edition. We have
the licensing for the Standard Edition, but apparently it
was not installed properly. Is there a "simple" method to
upgrade to the Standard Edition?
Tom
>--Original Message--
>This probably means that you are not using Standard
Edition or
>Enterprise Edition of SQL-Server, but the MSDE or some
other version
>that cannot be licensed for real production loads.
>The statement
> SELECT @.@.version
>should tell you which edition is installed.
>Gert-Jan
>
>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
application.
>> The only message that I found in any of the logs was the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>.
>|||See
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/instsql/in_overview_2xtf.asp
>--Original Message--
>Thanks for your reply. You are correct; this server was
>installed with SQL Server 2000 Personal Edition. We have
>the licensing for the Standard Edition, but apparently it
>was not installed properly. Is there a "simple" method
to
>upgrade to the Standard Edition?
>Tom
>>--Original Message--
>>This probably means that you are not using Standard
>Edition or
>>Enterprise Edition of SQL-Server, but the MSDE or some
>other version
>>that cannot be licensed for real production loads.
>>The statement
>> SELECT @.@.version
>>should tell you which edition is installed.
>>Gert-Jan
>>
>>Tom Griffin wrote:
>> I have a server with Windows 2000, SQL Server 2000, 2
>1GHz
>> processors and 1.5GHz of memory. The users were
>> complaining of slowness today from tehir web
>application.
>> The only message that I found in any of the logs was
the
>> following:
>> This SQL Server has been optimized for 8 concurrent
>> queries. This limit has been exceeded by 2 queries and
>> performance may be adversely affected.
>> I don't know if this is giving me any info cuz I don't
>> know what the message means. Is there anywhere (or
>> anyone) that can explain this to me?
>>.
>.
>