SQL 2005 Standard 64-bit on Windows 64-bit Performance Counters is

Are you sure you have X64 bit version of SQL Server and not the 32 bit
loaded? See if this helps:

http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx


--
Andrew J. Kelly SQL MVP

"Alejandro" wrote in message
news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
>I am using System Monitor to check the SQL Server performance counters, I
>am
> able to see some of them ( Server-related) however the Object:
> SQLServeratabases is not showing any counter to select showing only the
> message My server is Windows 2003 R3 64-bit and SQL Server
> Standard 64-bit, I have another server with the same configuration and
> System
> Monitor works well. Any help ?
>
> Regards,
>
> Alejandro Maldonado

I have the 64-bit this is the info from:
PRINT @@VERSION
Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
Mar 23 2007 18:41:50
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

as well I found this on the application log of the machine where SQL is:

The Open Procedure for service "MSSQLSERVER" in DLL
"C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this service
will not be available. The Status code returned is the first DWORD in the
attached data.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Hex Data:

0000: f3 03 00 00 00 00 00 00

And on top of that I did the following sentence on SQL:

select * from sys.dm_os_performance_counters

It didn't return any records. I hope you might help me with this additional
information.

--
Alejandro Maldonado


"Andrew J. Kelly" wrote:

> Are you sure you have X64 bit version of SQL Server and not the 32 bit
> loaded? See if this helps:
>
> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
>
>
> --
> Andrew J. Kelly SQL MVP
>
> "Alejandro" wrote in message
> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
> >I am using System Monitor to check the SQL Server performance counters, I
> >am
> > able to see some of them ( Server-related) however the Object:
> > SQLServeratabases is not showing any counter to select showing only the
> > message My server is Windows 2003 R3 64-bit and SQL Server
> > Standard 64-bit, I have another server with the same configuration and
> > System
> > Monitor works well. Any help ?
> >
> > Regards,
> >
> > Alejandro Maldonado
>
>
>

You are running the 32 bit version of the DLL as shown here:
"C:\WINDOWS\system32\sqlctr90.dll"

Make sure you run perfmon from the 64 bit folder not the 32 bit one.

--
Andrew J. Kelly SQL MVP

"Alejandro" wrote in message
news:2D1CE0B7-9DF2-4202-AF82-7385209596D0@microsoft.com...
>I have the 64-bit this is the info from:
> PRINT @@VERSION
> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
> Mar 23 2007 18:41:50
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>
> as well I found this on the application log of the machine where SQL is:
>
> The Open Procedure for service "MSSQLSERVER" in DLL
> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
> service
> will not be available. The Status code returned is the first DWORD in the
> attached data.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> Hex Data:
>
> 0000: f3 03 00 00 00 00 00 00
>
> And on top of that I did the following sentence on SQL:
>
> select * from sys.dm_os_performance_counters
>
> It didn't return any records. I hope you might help me with this
> additional
> information.
>
> --
> Alejandro Maldonado
>
>
> "Andrew J. Kelly" wrote:
>
>> Are you sure you have X64 bit version of SQL Server and not the 32 bit
>> loaded? See if this helps:
>>
>> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
>>
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Alejandro" wrote in message
>> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
>> >I am using System Monitor to check the SQL Server performance counters,
>> >I
>> >am
>> > able to see some of them ( Server-related) however the Object:
>> > SQLServeratabases is not showing any counter to select showing only
>> > the
>> > message My server is Windows 2003 R3 64-bit and SQL
>> > Server
>> > Standard 64-bit, I have another server with the same configuration and
>> > System
>> > Monitor works well. Any help ?
>> >
>> > Regards,
>> >
>> > Alejandro Maldonado
>>
>>
>>

Andrew,

Actually, on X64 Windows, the 64-Bit executables are in System32 and the
32-bit (X86) executables are in SysWOW64, so Alejandro is probably using the
proper DLL. (Yes, that is all quite non-intuitive.)

In order to check and make sure of the version, browse Windows Explorer to
the proper folder and right-click on the DLL, then choose Properties. In
the Version tab, the Comments value should say either X86 or X64.

RLF

"Andrew J. Kelly" wrote in message
news:etIsGSb3HHA.5880@TK2MSFTNGP03.phx.gbl...
> You are running the 32 bit version of the DLL as shown here:
> "C:\WINDOWS\system32\sqlctr90.dll"
>
> Make sure you run perfmon from the 64 bit folder not the 32 bit one.
>
> --
> Andrew J. Kelly SQL MVP
>
> "Alejandro" wrote in message
> news:2D1CE0B7-9DF2-4202-AF82-7385209596D0@microsoft.com...
>>I have the 64-bit this is the info from:
>> PRINT @@VERSION
>> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
>> Mar 23 2007 18:41:50
>> Copyright (c) 1988-2005 Microsoft Corporation
>> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>>
>> as well I found this on the application log of the machine where SQL is:
>>
>> The Open Procedure for service "MSSQLSERVER" in DLL
>> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
>> service
>> will not be available. The Status code returned is the first DWORD in the
>> attached data.
>>
>> For more information, see Help and Support Center at
>> http://go.microsoft.com/fwlink/events.asp.
>>
>> Hex Data:
>>
>> 0000: f3 03 00 00 00 00 00 00
>>
>> And on top of that I did the following sentence on SQL:
>>
>> select * from sys.dm_os_performance_counters
>>
>> It didn't return any records. I hope you might help me with this
>> additional
>> information.
>>
>> --
>> Alejandro Maldonado
>>
>>
>> "Andrew J. Kelly" wrote:
>>
>>> Are you sure you have X64 bit version of SQL Server and not the 32 bit
>>> loaded? See if this helps:
>>>
>>> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
>>>
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>>
>>> "Alejandro" wrote in message
>>> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
>>> >I am using System Monitor to check the SQL Server performance counters,
>>> >I
>>> >am
>>> > able to see some of them ( Server-related) however the Object:
>>> > SQLServeratabases is not showing any counter to select showing only
>>> > the
>>> > message My server is Windows 2003 R3 64-bit and SQL
>>> > Server
>>> > Standard 64-bit, I have another server with the same configuration and
>>> > System
>>> > Monitor works well. Any help ?
>>> >
>>> > Regards,
>>> >
>>> > Alejandro Maldonado
>>>
>>>
>>>
>
>

Russell is correct.
I found the following
File Version
C:\WINDOWS\system32\sqlctr90.dll NT AMD64
C:\WINDOWS\SysWOW64\sqlctr90.dll NT INTEL X86

That means in my event log the error belongs to the 64-bit dll. however I
couldn't get any workaround regarding the error found on my app log.

The Open Procedure for service "MSSQLSERVER" in DLL
"C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
service will not be available. The Status code returned is the first DWORD
in the
attached data.

I hope you guys might help me.
--
Alejandro Maldonado


"Russell Fields" wrote:

> Andrew,
>
> Actually, on X64 Windows, the 64-Bit executables are in System32 and the
> 32-bit (X86) executables are in SysWOW64, so Alejandro is probably using the
> proper DLL. (Yes, that is all quite non-intuitive.)
>
> In order to check and make sure of the version, browse Windows Explorer to
> the proper folder and right-click on the DLL, then choose Properties. In
> the Version tab, the Comments value should say either X86 or X64.
>
> RLF
>
> "Andrew J. Kelly" wrote in message
> news:etIsGSb3HHA.5880@TK2MSFTNGP03.phx.gbl...
> > You are running the 32 bit version of the DLL as shown here:
> > "C:\WINDOWS\system32\sqlctr90.dll"
> >
> > Make sure you run perfmon from the 64 bit folder not the 32 bit one.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Alejandro" wrote in message
> > news:2D1CE0B7-9DF2-4202-AF82-7385209596D0@microsoft.com...
> >>I have the 64-bit this is the info from:
> >> PRINT @@VERSION
> >> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
> >> Mar 23 2007 18:41:50
> >> Copyright (c) 1988-2005 Microsoft Corporation
> >> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
> >>
> >> as well I found this on the application log of the machine where SQL is:
> >>
> >> The Open Procedure for service "MSSQLSERVER" in DLL
> >> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
> >> service
> >> will not be available. The Status code returned is the first DWORD in the
> >> attached data.
> >>
> >> For more information, see Help and Support Center at
> >> http://go.microsoft.com/fwlink/events.asp.
> >>
> >> Hex Data:
> >>
> >> 0000: f3 03 00 00 00 00 00 00
> >>
> >> And on top of that I did the following sentence on SQL:
> >>
> >> select * from sys.dm_os_performance_counters
> >>
> >> It didn't return any records. I hope you might help me with this
> >> additional
> >> information.
> >>
> >> --
> >> Alejandro Maldonado
> >>
> >>
> >> "Andrew J. Kelly" wrote:
> >>
> >>> Are you sure you have X64 bit version of SQL Server and not the 32 bit
> >>> loaded? See if this helps:
> >>>
> >>> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
> >>>
> >>>
> >>> --
> >>> Andrew J. Kelly SQL MVP
> >>>
> >>> "Alejandro" wrote in message
> >>> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
> >>> >I am using System Monitor to check the SQL Server performance counters,
> >>> >I
> >>> >am
> >>> > able to see some of them ( Server-related) however the Object:
> >>> > SQLServeratabases is not showing any counter to select showing only
> >>> > the
> >>> > message My server is Windows 2003 R3 64-bit and SQL
> >>> > Server
> >>> > Standard 64-bit, I have another server with the same configuration and
> >>> > System
> >>> > Monitor works well. Any help ?
> >>> >
> >>> > Regards,
> >>> >
> >>> > Alejandro Maldonado
> >>>
> >>>
> >>>
> >
> >
>
>
>

Sorry but I don't know what the error is. Is it possible the account you are
trying to run this under does not have the proper permissions?

--
Andrew J. Kelly SQL MVP

"Alejandro" wrote in message
news:7500709F-6C2C-4E04-8EEB-20D8C7CC8ADE@microsoft.com...
> Russell is correct.
> I found the following
> File Version
> C:\WINDOWS\system32\sqlctr90.dll NT AMD64
> C:\WINDOWS\SysWOW64\sqlctr90.dll NT INTEL X86
>
> That means in my event log the error belongs to the 64-bit dll. however I
> couldn't get any workaround regarding the error found on my app log.
>
> The Open Procedure for service "MSSQLSERVER" in DLL
> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
> service will not be available. The Status code returned is the first DWORD
> in the
> attached data.
>
> I hope you guys might help me.
> --
> Alejandro Maldonado
>
>
> "Russell Fields" wrote:
>
>> Andrew,
>>
>> Actually, on X64 Windows, the 64-Bit executables are in System32 and the
>> 32-bit (X86) executables are in SysWOW64, so Alejandro is probably using
>> the
>> proper DLL. (Yes, that is all quite non-intuitive.)
>>
>> In order to check and make sure of the version, browse Windows Explorer
>> to
>> the proper folder and right-click on the DLL, then choose Properties. In
>> the Version tab, the Comments value should say either X86 or X64.
>>
>> RLF
>>
>> "Andrew J. Kelly" wrote in message
>> news:etIsGSb3HHA.5880@TK2MSFTNGP03.phx.gbl...
>> > You are running the 32 bit version of the DLL as shown here:
>> > "C:\WINDOWS\system32\sqlctr90.dll"
>> >
>> > Make sure you run perfmon from the 64 bit folder not the 32 bit one.
>> >
>> > --
>> > Andrew J. Kelly SQL MVP
>> >
>> > "Alejandro" wrote in message
>> > news:2D1CE0B7-9DF2-4202-AF82-7385209596D0@microsoft.com...
>> >>I have the 64-bit this is the info from:
>> >> PRINT @@VERSION
>> >> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
>> >> Mar 23 2007 18:41:50
>> >> Copyright (c) 1988-2005 Microsoft Corporation
>> >> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack
>> >> 2)
>> >>
>> >> as well I found this on the application log of the machine where SQL
>> >> is:
>> >>
>> >> The Open Procedure for service "MSSQLSERVER" in DLL
>> >> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
>> >> service
>> >> will not be available. The Status code returned is the first DWORD in
>> >> the
>> >> attached data.
>> >>
>> >> For more information, see Help and Support Center at
>> >> http://go.microsoft.com/fwlink/events.asp.
>> >>
>> >> Hex Data:
>> >>
>> >> 0000: f3 03 00 00 00 00 00 00
>> >>
>> >> And on top of that I did the following sentence on SQL:
>> >>
>> >> select * from sys.dm_os_performance_counters
>> >>
>> >> It didn't return any records. I hope you might help me with this
>> >> additional
>> >> information.
>> >>
>> >> --
>> >> Alejandro Maldonado
>> >>
>> >>
>> >> "Andrew J. Kelly" wrote:
>> >>
>> >>> Are you sure you have X64 bit version of SQL Server and not the 32
>> >>> bit
>> >>> loaded? See if this helps:
>> >>>
>> >>> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
>> >>>
>> >>>
>> >>> --
>> >>> Andrew J. Kelly SQL MVP
>> >>>
>> >>> "Alejandro" wrote in message
>> >>> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
>> >>> >I am using System Monitor to check the SQL Server performance
>> >>> >counters,
>> >>> >I
>> >>> >am
>> >>> > able to see some of them ( Server-related) however the Object:
>> >>> > SQLServeratabases is not showing any counter to select showing
>> >>> > only
>> >>> > the
>> >>> > message My server is Windows 2003 R3 64-bit and SQL
>> >>> > Server
>> >>> > Standard 64-bit, I have another server with the same configuration
>> >>> > and
>> >>> > System
>> >>> > Monitor works well. Any help ?
>> >>> >
>> >>> > Regards,
>> >>> >
>> >>> > Alejandro Maldonado
>> >>>
>> >>>
>> >>>
>> >
>> >
>>
>>
>>

Hello Andrew
This is very extrange. Because I have two identical servers with the same
configuration one is our Prod and the other DR, I used lodctr utility to save
the counters from DR ( which is working good) and restored the file on PRD I
did it this morning and because I didn't see any change to solve my problem I
though that was another thing that didn't work, however this afternoon I
check again and the counters are back! ) well I solved my problem however I
don't know how.
Regards,
--
Alejandro Maldonado


"Andrew J. Kelly" wrote:

> Sorry but I don't know what the error is. Is it possible the account you are
> trying to run this under does not have the proper permissions?
>
> --
> Andrew J. Kelly SQL MVP
>
> "Alejandro" wrote in message
> news:7500709F-6C2C-4E04-8EEB-20D8C7CC8ADE@microsoft.com...
> > Russell is correct.
> > I found the following
> > File Version
> > C:\WINDOWS\system32\sqlctr90.dll NT AMD64
> > C:\WINDOWS\SysWOW64\sqlctr90.dll NT INTEL X86
> >
> > That means in my event log the error belongs to the 64-bit dll. however I
> > couldn't get any workaround regarding the error found on my app log.
> >
> > The Open Procedure for service "MSSQLSERVER" in DLL
> > "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
> > service will not be available. The Status code returned is the first DWORD
> > in the
> > attached data.
> >
> > I hope you guys might help me.
> > --
> > Alejandro Maldonado
> >
> >
> > "Russell Fields" wrote:
> >
> >> Andrew,
> >>
> >> Actually, on X64 Windows, the 64-Bit executables are in System32 and the
> >> 32-bit (X86) executables are in SysWOW64, so Alejandro is probably using
> >> the
> >> proper DLL. (Yes, that is all quite non-intuitive.)
> >>
> >> In order to check and make sure of the version, browse Windows Explorer
> >> to
> >> the proper folder and right-click on the DLL, then choose Properties. In
> >> the Version tab, the Comments value should say either X86 or X64.
> >>
> >> RLF
> >>
> >> "Andrew J. Kelly" wrote in message
> >> news:etIsGSb3HHA.5880@TK2MSFTNGP03.phx.gbl...
> >> > You are running the 32 bit version of the DLL as shown here:
> >> > "C:\WINDOWS\system32\sqlctr90.dll"
> >> >
> >> > Make sure you run perfmon from the 64 bit folder not the 32 bit one.
> >> >
> >> > --
> >> > Andrew J. Kelly SQL MVP
> >> >
> >> > "Alejandro" wrote in message
> >> > news:2D1CE0B7-9DF2-4202-AF82-7385209596D0@microsoft.com...
> >> >>I have the 64-bit this is the info from:
> >> >> PRINT @@VERSION
> >> >> Microsoft SQL Server 2005 - 9.00.3054.00 (X64)
> >> >> Mar 23 2007 18:41:50
> >> >> Copyright (c) 1988-2005 Microsoft Corporation
> >> >> Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack
> >> >> 2)
> >> >>
> >> >> as well I found this on the application log of the machine where SQL
> >> >> is:
> >> >>
> >> >> The Open Procedure for service "MSSQLSERVER" in DLL
> >> >> "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this
> >> >> service
> >> >> will not be available. The Status code returned is the first DWORD in
> >> >> the
> >> >> attached data.
> >> >>
> >> >> For more information, see Help and Support Center at
> >> >> http://go.microsoft.com/fwlink/events.asp.
> >> >>
> >> >> Hex Data:
> >> >>
> >> >> 0000: f3 03 00 00 00 00 00 00
> >> >>
> >> >> And on top of that I did the following sentence on SQL:
> >> >>
> >> >> select * from sys.dm_os_performance_counters
> >> >>
> >> >> It didn't return any records. I hope you might help me with this
> >> >> additional
> >> >> information.
> >> >>
> >> >> --
> >> >> Alejandro Maldonado
> >> >>
> >> >>
> >> >> "Andrew J. Kelly" wrote:
> >> >>
> >> >>> Are you sure you have X64 bit version of SQL Server and not the 32
> >> >>> bit
> >> >>> loaded? See if this helps:
> >> >>>
> >> >>> http://sqlblogcasts.com/blogs/tonyro...rfmon-msc.aspx
> >> >>>
> >> >>>
> >> >>> --
> >> >>> Andrew J. Kelly SQL MVP
> >> >>>
> >> >>> "Alejandro" wrote in message
> >> >>> news:695F7AED-D95D-4616-9DEE-E1BE2693EDEE@microsoft.com...
> >> >>> >I am using System Monitor to check the SQL Server performance
> >> >>> >counters,
> >> >>> >I
> >> >>> >am
> >> >>> > able to see some of them ( Server-related) however the Object:
> >> >>> > SQLServeratabases is not showing any counter to select showing
> >> >>> > only
> >> >>> > the
> >> >>> > message My server is Windows 2003 R3 64-bit and SQL
> >> >>> > Server
> >> >>> > Standard 64-bit, I have another server with the same configuration
> >> >>> > and
> >> >>> > System
> >> >>> > Monitor works well. Any help ?
> >> >>> >
> >> >>> > Regards,
> >> >>> >
> >> >>> > Alejandro Maldonado
> >> >>>
> >> >>>
> >> >>>
> >> >
> >> >
> >>
> >>
> >>
>
>
>