Monday, March 26, 2012

named instance installed no access to perf. counters ?

Hi,
on a server I have installed SQL 2005 Enterprise Edition x64
Its a named instance and there is no default instance deployed.
if I try to access some performance counters, I can't add them. the ADD
button is disabled.
some counters works fines, but others like "Active Transactions" can't be
added while the active temp tables counter can be added.
I think only counters where an instance (ie a database in the SQL Server
instance) option must be selected doesn't works.
I have installed the SP2 and this don't solve the issue.
any idea?
Thanks.
Jerome.Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
Check the @.version and see. If you have, you will need to uninstall and
reinstall SQL Server 2005.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Jeje" <willgart@.hotmail.com> wrote in message
news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
> Hi,
> on a server I have installed SQL 2005 Enterprise Edition x64
> Its a named instance and there is no default instance deployed.
> if I try to access some performance counters, I can't add them. the ADD
> button is disabled.
> some counters works fines, but others like "Active Transactions" can't be
> added while the active temp tables counter can be added.
> I think only counters where an instance (ie a database in the SQL Server
> instance) option must be selected doesn't works.
> I have installed the SP2 and this don't solve the issue.
> any idea?
> Thanks.
> Jerome.
>|||mmm... all the components appears to be x64 version:
Microsoft SQL Server 2005 - 9.00.3159.00 (X64)
Mar 23 2007 20:11:35
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
any other idea?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>|||I have installed a new instance on the server and its the same result the
performance counters don't allow me to select a database when its required.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uyEgYH1iHHA.1260@.TK2MSFTNGP03.phx.gbl...
> Most likely you have installed a 32-bit SQL Server on top of a 64-bit OS.
> Check the @.version and see. If you have, you will need to uninstall and
> reinstall SQL Server 2005.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:B040B2A7-2BD6-4270-8A95-4B59DA7EB2BD@.microsoft.com...
>

No comments:

Post a Comment