Performance Counters not displayed

SQL Server 2000 EE SP3a.
Through PerfMon the sql server specific perfomance
counters are not displayed. I have revisited the
installation CD and per the installation SQL Server
Components/Performance Counters SubComponent are installed.
Any Ideas on how I can see these counters. This is a
production machine so all maintenance is late night.
TIA,hi,
take a look at this
article
http://support.microsoft.com/?id=152513
>--Original Message--
>SQL Server 2000 EE SP3a.
>Through PerfMon the sql server specific perfomance
>counters are not displayed. I have revisited the
>installation CD and per the installation SQL Server
>Components/Performance Counters SubComponent are
installed.
>Any Ideas on how I can see these counters. This is a
>production machine so all maintenance is late night.
>TIA,
>.
>|||I have looked at this article. Again the only counters
that do not show up are the SQL Server specific counters.
Joe
>--Original Message--
>hi,
>take a look at this
>article
>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>.
>|||Did you restart the server before looking at the perfmon,
To get u'r counters back just restart the entire system
and look at it
>--Original Message--
>I have looked at this article. Again the only counters
>that do not show up are the SQL Server specific counters.
>Joe
>>--Original Message--
>>hi,
>>take a look at this
>>article
>>http://support.microsoft.com/?id=152513
>>--Original Message--
>>SQL Server 2000 EE SP3a.
>>Through PerfMon the sql server specific perfomance
>>counters are not displayed. I have revisited the
>>installation CD and per the installation SQL Server
>>Components/Performance Counters SubComponent are
>>installed.
>>Any Ideas on how I can see these counters. This is a
>>production machine so all maintenance is late night.
>>TIA,
>>.
>>.
>.
>

Performance comparison between Enterprise and Standard edition

Dear all,

I am considering for a new installation of Enterprise edition because of its OLAP semi-additive feature. Are there any other feature that is worth for Enterprise edition ?

I am using it as a small size datawarehouse (<200 GB). Then, no need for scalability and availability.

Are there any performance paper about ETL, OLAP creation, OLAP browsing, reporting between enterprise and standard edition ? Both of them should use the same machine sizing , i.e. 2 CPU.

Best regards,

Chaivat

the main difference between enterprise and standard is features, also standard edition will use a maximum of 4 processors.|||

Here is a handy chart of feature comparison:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Enterprise offers several things above Standard, such as partioning, indexed views, CPU support, and more. The link makes it pretty easy to compare the two SKU's.

Thanks,
Sam Lester (MSFT)

sql

Performance comparison between Enterprise and Standard edition

Dear all,

I am considering for a new installation of Enterprise edition because of its OLAP semi-additive feature. Are there any other feature that is worth for Enterprise edition ?

I am using it as a small size datawarehouse (<200 GB). Then, no need for scalability and availability.

Are there any performance paper about ETL, OLAP creation, OLAP browsing, reporting between enterprise and standard edition ? Both of them should use the same machine sizing , i.e. 2 CPU.

Best regards,

Chaivat

the main difference between enterprise and standard is features, also standard edition will use a maximum of 4 processors.|||

Here is a handy chart of feature comparison:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Enterprise offers several things above Standard, such as partioning, indexed views, CPU support, and more. The link makes it pretty easy to compare the two SKU's.

Thanks,
Sam Lester (MSFT)

Performance comparison between Enterprise and Standard edition

Dear all,

I am considering for a new installation of Enterprise edition because of its OLAP semi-additive feature. Are there any other feature that is worth for Enterprise edition ?

I am using it as a small size datawarehouse (<200 GB). Then, no need for scalability and availability.

Are there any performance paper about ETL, OLAP creation, OLAP browsing, reporting between enterprise and standard edition ? Both of them should use the same machine sizing , i.e. 2 CPU.

Best regards,

Chaivat

the main difference between enterprise and standard is features, also standard edition will use a maximum of 4 processors.|||

Here is a handy chart of feature comparison:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Enterprise offers several things above Standard, such as partioning, indexed views, CPU support, and more. The link makes it pretty easy to compare the two SKU's.

Thanks,
Sam Lester (MSFT)