can't see SQL server objects and counters on performance monitor

I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
on performance monitor.
does anybody have the same situation?
ThanksHi
Do you mean that if you click on Performance object's combobox you don't see
SQL Server counters?
"chacha" <lichangang@.hotmail.com> wrote in message
news:FF74189B-EDFD-4C8A-96AF-260F11BD49CE@.microsoft.com...
>I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thanks|||This can happen sometimes. The main reason that it causes it is that
by the time that you run perfmon with SQL Server's counters, you stop
the server's service. Few years ago I found the procedure bellow to
get the counters back (Sorry that I don't give credit, but I don't
remember where I got it from). I always start from step 4. I never
needed to run the first 3 steps.
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
If it exists, please delete it
3. Under the register key:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
Make sure the following keys with the value DO EXIST. If not, please
create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL
Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature"=hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
Adi
chacha wrote:
> I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thankssql