How To Repair Performance Counters For SQL Server 2005 ?

Sep 11, 2007

My Performance Counters for SQL Server 2005 are corrupted. How do I repair them ?

Any help would be appreciated. Thanks.

Salyx

Specs
Windows 2003 Standard, AMD x64.
SQL Server 2005; x64; 9.00.3042.00; SP2 Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service
Pack 2)
This is a new install, so no "upgrade from SQL 2000".
This is a production server, so "reboot" is hopefully not part of the suggested repair.

Symptom
Open Performance Monitor. Open Add Counters. Open Dropdown "Performance Object". Instead of the SQL Server Performance Counter names, a list of 4-digit numbers appears. Other Performance Counters, eg, Processor, work as normal.

Attempted repair 1 - Recovery of system performance counters
Open Command Prompt
CD WindowsSystem32
lodctr /R
This failed to restore the full set of performance counters for an unknown reason.

Attempted repair 2 - Recovery from a backup file from a second host
I used the performance counter backup file from a second host which has an identical windows install. This properly restored the system performance counters, but failed to restore the SQL Server ones. This seems odd, because both system have - as much as I can tell - the same applications installed.

Open Command Prompt
CD WindowsSystem32
REM Load backup file from second host
lodctr /R:c:PerfStringBackup.INI

Attempted repair 3 - Recover SQL Server - specific counters
Open Command Prompt
CD WindowsSystem32
REM Load backup file from second host
lodctr /R:c:PerfStringBackup.INI
REM Clear and re-load MSSQLServer counters...
unlodctr MSSQLServer
lodctr "/R:C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlctr.ini"

Executing this pretty much wiped most performance counters. Only a small sub-set is now available.

More Info
SQL Server 2005 and later SP2 were installed under the administrator account.
MSSQLServer service runs under its own Windows Account (permission issues ??)
I get Event Log entries regarding x86 vs x64 Performance Counter Libraries. These, however, do not refer to ASP, not SQL Server.
I have 2 (virtually) identical hosts (same install sequence of apps). The Performance Counters on the second host work fine.
Exctrlst.exe lists MSSQLSERVER service, but I don't know how to diagnose the details.

View 3 Replies


ADVERTISEMENT

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

No SQL Server Performance Monitor Counters

Jul 2, 2004

On some of my database servers, there are SQL Server counters in Performance Monitor. On other servers these are not present. How can I turn these on?

I know with the disc counters you need to explicitly enable them:
diskperf -yv

Is there a parallel for SQL Server? I don't remember doing anything to get them working on the servers that have them. All online articles seem to assume that they just exist.

TIA!

View 11 Replies View Related

SQL Server Performance Monitor Counters

Jan 12, 2004

I've always assumed SQL Server performance monitor counters get automatically installed when SQL Server is installed. I recently installed SQL Server on a remote server and noticed the SQL Server performance monitor counters do not appear in Perfmon. Aren't these counters automatically installed during setup?

Dave

View 3 Replies View Related

SQL Server Admin 2014 :: Performance Counters Keep Disappearing

Feb 6, 2015

I have an Alwayson group with 2 Nodes. The SQL Performance counters are always showing on the secondary, but the primary is inconsistent.

I loaded the counters on the primary (unlodctr and lodctr ), restarted the SQL service, and confirmed that the counters were there. 2 days later the counters were gone again. I loaded them again. A week later we had maintenance, failed over to the secondary, and when we failed back to the primary - the counters were gone again….

View 0 Replies View Related

SQL Performance Counters

Apr 23, 2001

I am running MSSQL v7.0 with Service Pack 2. I just realized that I have no sql server performance counters on this machine. Does anyone know how to install these performance counters without reinstalling the SQL Server software?

View 1 Replies View Related

Performance Counters

Apr 18, 2006

In the Performance object drop down list of Perfmon.

I don't see the below counter

SQLServer:AccessMethods
SQLServer:BufferManager
SQLServer:Databases
SQLServer:GeneralStatistics
SQLServer:Latches
SQLServer:Locks
SQLServer:MemeoryManager
SQLServer:SQLStatistics.

How to enable these?

Thx
Venu

View 1 Replies View Related

No SQL Performance Monitor Counters

Jan 24, 2000

Any suggestions on getting them back? Reinstalling SQL didn't do anything. And yes, I am server administrator.


Thanks!

View 2 Replies View Related

Missing Performance Counters

Aug 14, 2002

Hi all,
I have sql 2000 enterprise. From performance monitor, the sql counters are missing. During installation I've made sure that the sqlcounters are installed. The sqlctr80.dll is installed. But still the counters are not showing.

Has anybody come across this, not sure what to do next

View 2 Replies View Related

Performance Counters On 64 Bit SSIS

Oct 11, 2006

On 32 bit SSIS installations, both of the following performance counter objects are visible in perfmon.

SQLServer:SSIS Service

SQLServer:SSIS Pipeline

On 64 bit SSIS installations, only the following is available.

SQLServer:SSIS Service

The SQlServer:SSIS Pipeline counters are nowhere to be found.

Should I re-install? Is this a known issue with 64 bit SSIS?

P.S. Remote or local access administrative access with perfmon makes no difference, the "SQLServer:SSIS Pipeline" performance counters don't appear in the listbox when connecting to Windows 2003 x64 server.

View 4 Replies View Related

Can't See 64-bit FTS Performance Counters From 32-bit Application

Aug 24, 2007

I have a 32-bit application which sometimes runs against 64-bit servers. When it does, I can't read the performance counters published by the FTS service because they're 64-bit only. I get event #1022 from PerfLib in the event log:


Windows cannot open the 64-bit extensible counter DLL msftesqlFD in a 32-bit environment. Contact the file vendor to obtain a 32-bit version. Alternatively if you are running a 64-bit native environment, you can open the 64-bit extensible counter DLL by using the 64-bit version of Performance Monitor. To use this tool, open the Windows folder, open the System32 folder, and then start Perfmon.exe.

Does Microsoft make available 32-bit counter libraries for 32-bit clients of the 64-bit FTS? How do I obtain those bits?

.B ekiM

View 1 Replies View Related

SSIS Performance Counters

Dec 28, 2007

We have SSIS installed and everything is working great. We are now to the point of wanting to tune one of our longer running packages and the Performance counters are not working. At all. They show up ok but the counter is always at 0. Is there anything special I have to do to get this to work.

One comment I fould was that the Performance Logs and Alerts service needs to be running to see these counters. I tried to start it and it immediately quit. I set it to automatic startup up and run a package. The counter still read 0.

Is there anything else out there I can try to get these counters to return somthing. Thanks.

Aaron

View 9 Replies View Related

Repair An SQL Server 2005 Installation.

May 11, 2007

Hi,



Some part of my system registry seens corrupted, and I can not run the report services configuration tool, it gave me the following error:



0x80010002: RCP_E_CALL_CANCELED



1) Does a repair of the installation will register back the COM Servers?

2) After a repair does the report services encription key will be affected.



My main problem is to perform a backup of the report services encription key on a server that is not very stable.



3) Is there another way to backup the encription key without using the report services configuration tool?



Thanks

JF

View 1 Replies View Related

Missing Performance Monitor Counters

Jul 9, 1999

The SQL server perfmon counters are missing from one of my MSSQL 7.0 servers - they do appear in others just fine.

Can anyone tell me what is wrong and/or how I can add the counters? I have seen archieve notes on this topic but can't access them for some reason (page appears blank when I click on link)

I am using perfmon to remotely monitor the problem server. My login has sysadmin permissions and is an NT admin. on both the server and the monitoring client. The login account for MSSQL server and SQL Agent services are both sysadmins.

Many thanks

View 1 Replies View Related

Missing Counters In Performance Monitor

Aug 20, 2003

Im missing all SQL Server counters in the Performance Monitor

and have looked at article: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q196/6/57.ASP&NoWebContent=1

but this article refers to SQL 7...I have 2K with SP3 and MS03-031

How can I get my counters ? thanks

View 13 Replies View Related

Missong SQL Counters On The NT Performance Monitor

Mar 11, 1999

Does any one know, how I can add SQLServer performance monitoring counters back on my NT server. For some reason I am missing these counters. I really do not want to reinstall either the NT OS or SQL OS if there is anyway to aviod this.
Thanks

View 1 Replies View Related

Real Impact Of MS Performance Counters

Apr 18, 2008

I have been collecting information about 20 performance counters (memory, IO, cpu, SQL) that refresh every 15 seconds, would that have any performance hit in the server? what are best practices when collecting information via performance counters?

Thanks

View 2 Replies View Related

SQL Performance Monitor Counters For Licensing Info

Dec 18, 2000

SQL 6.5 had counters for monitoring SQL licenses. Where did Microsoft hide them in SQL 7.0? Or did they just disappear? If they are gone, is anyone doing anything to monitor the licenses with something like perfmon? User Connections doesn't help because the application takes several and not always the same number of user connections for one license.

View 2 Replies View Related

6.5 Performance Counters/offloading Logs Before 1105s

May 25, 1999

I want to automate the offloading of SQL Server 6.5 logs before they become full. I've set this up 'manually' by triggering a job to run when the LogSpaceUsed threshold of the SQLServerLOg counter exceeds a certain value, but what I want to do now is to automate the starting of this performance counter. Ideally what I'd like is to (1) Start the counter once SQL is up, having (2) first ensured a particular instance of the counter isn't already executing (3) have some means of detecting whether this counter ever stops running in which case we'd have to restart it. This is probably more of an NT question than anything but if anyone has experience of this please let me know....I have tried trying to get SQlServer to start the performance counter as it starts up. I used sp_makestartup to define a stored procedure which runs on startup, this uses xp_cmdshell to call a CMD file which calls the saved counter definition (a .pmw file, performance monitor workspace) I thought this should work but the counter wasn't loaded......this doesn't check whewther an existing version of the counter is already running anyway.

View 3 Replies View Related

Performance Monitor (SQL 7 Counters Don&#39;t Show Up In Counter List)

Dec 11, 2001

I have 2 SQL Server 7 databases installed on 2 Windows 2000 servers. One box shows all the SQL performance counters with in performance monitor, the other one doesn't. Is there a way to register those SQL counters in performance monitor?

View 1 Replies View Related

Data Files/ Trans Logs --- Performance Counters?

Nov 7, 2002

There are so many to choose from, which ones are the most important to monitor?

Also if you have your data files and trans logs set to grow automaticlly and would like to change this to a fixed number is there a way to determine how large you should set them at? Thanks in advance.
:confused:

View 1 Replies View Related

ODBC Connection Pooling Performance Counters All Return 0 ???

Jan 22, 2008

Does anyone know how to make the ODBC Connection Pooling performance counters work? I read http://support.microsoft.com/default.aspx?scid=kb;en-us;216950 to enable the performance counters, but they still all report 0s.

Thanks,
Mark

View 1 Replies View Related

Performance Counters On Service Broker Transmission Queue

Jan 26, 2007

Hello,

is there built-in support for monitoring the number of elements in the transmission queue via performance counters?

Thanks,

View 4 Replies View Related

MQPERF.dll Performance Counters Fail To Load (was New Member ... With New Problem)

May 2, 2006

Hello to all the members.

I have a SQl server on a Win2000 box. The server is located behind a screened subnet, and has no access to the outside world except for 1433 and 445 inbound from a webserver located in a DMZ, forward of the internal firewall. Rules are very tight, and the IIS box is patched and has been hardened further including running urlscan. (allowed verbs=get,head,post. all executable and script types disallowed, permissions very tight) I have written an appication that monitors bad http requests in real time to check that the URL scan is working, and it seems to be. The only way to get to the SQL box, would be running injection on page code (majority written by myself no raw sql) on the web server or launching an exploit over HTTP against known ADODB flaws on the web server. The SQL server is a domain member, the IIS server is a standalone. If theres a way to compromise the SQL box without first breaching both firewalls, or first compromising the IIS server, I dont know how to do it. Still, the sql box began acting up, refusing to accept a terminal services connection (the error stated that there was a failure to load Win32.sys) No sign that the machine had been compromised. I restored from a complete back up, which seemed to fix the terminal services problem, but now the sql performance counters fail to load. Specifically MQPERF.dll. Any ideas on what may have caused the server to have 'issues' (prevailing theory centers around evil spirits), and what can I do to get the performance counters to load. Tried replacing the library.

Thanks in advance,

VLG

View 4 Replies View Related

SQL 2012 :: Can Combine Performance Monitor Counters With Extended Events

Oct 14, 2014

In the past, I've combined server side traces with Perfmon successfully, which is pretty useful, I know that. I would like to do the same with Extended Events, so I can correlate and analyze the server side as well.

View 4 Replies View Related

SQL 2012 :: Every Time Machine Is Rebooted Performance Counters Are Missing?

Mar 24, 2015

SQL Server 2014 BI
Windows 2008 R2

Every time machine is rebooted performance counters are missing.

select * from sys.dm_os_performance_counters returns no records. I execute "lodctr" command and get it back every time.

I would like to know the route cause of this issue, why it gets removed every time the machine is rebooted.

View 1 Replies View Related

After Applying Security Patch MS03-031, I Lose My SQL 2K Performance Monitor Counters

Aug 20, 2003

This is related to an earlier post, but I found out that I was able to see SQL Server counters in Performance monitor before applying the patch, but the counters were not present afterwards....

do I need to edit the registry ?

View 3 Replies View Related

Error Message Run Repair Utility When Using Sqlceengine.repair

Sep 26, 2007



Hi there.

I have a corrupt .sdf database sat on a SD Card but i am unable to find a way to repair it.

So far I have tried a few different methods, most of which just tell me what i already know i.e. "the database is corrupt and needs repairing!!"

I am unable to open the file in SSMS object browser (see above message) which means i cant run repair / shrink utilites.
I am also unable to add the database to a vs2005 project (again see above message) meaning again i can't run any repair utilities.

I have also tried using the compact / Repair utility in Query analyser 3.0 on my Windows Mobile 5.0 PDA but once again i am greeted with an "error reading file - Run the Repair Utility" Message.

Lastly i've tried using the SQLCEengine.repair method and, depending on whether i do it on the PDA or on a desktop pc it throws the exceptions "Error occurred reading database file - run the repair utility"(PDA) or "invalid database type" (PC)

Can anyone shed any light as to whether there is another (easier???) way of doing this or if i just have to face it that this file is lost?

Thanks

ps. the code i used for the .repair is as below:



Dim conn As SqlCeEngine

Dim strdb As String



strdb = "SD CardPathnameDatabase.sdf"



conn = New SqlCeEngine(String.Format("Data Source={0}", strdb))


If conn.Verify = False Then

conn.Repair(Nothing, RepairOption.RecoverCorruptedRows)

MsgBox("Successfully Repaired")


End If

View 8 Replies View Related

SQL Tools :: Repair Database Without Being Attached (2005)

May 17, 2015

Is it possible to try repair a database without being attached, giving the path to the files?

I'm trying to attach a database that i recover from a disk, and i'm not able to attach, gives me an error, saying i should do a db check.

View 3 Replies View Related

SQL Server Counters Disappeared

Nov 10, 2005

On Tuesday the SQL Server Counters showed up in Performance Monitor. Yesterday they were gone. Is there any way they could have disappeared other than someone explicitly deleted them? How would I go about restoring them? Obviously, I'm concerned.

Thanks for the help.

View 4 Replies View Related

Repair Northwind Database In SQL Server Management Studio Express

May 7, 2007

Hi all,

Long time ago, I downloaded the Northwind and pubs databases from the Microsoft website (I do not remember the details of it) and installed these two databases together into the SQL Server Management Studio Express of my PC (Microsoft Windows XP Pro). I tried to learn an example of using "User Instance" (source code was from a book) on the Northwind database located in my SQL Server Management Studio Express. I just find out that my Northwind database has the title only and no tables at all. If I click on the "+" in front of the "Northwind", I got the following error message:

Microsoft SQL Server Management Studio Express



Failed to retrieve data for this request.(Microsoft SqlServer.Express.SmoEnum)



Additional information:

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from backup. (Microsoft SQL Server, Error: 5173)..



Please help and tell me how I can repair this Northwind database in my SQL Server Management Studio Express.



Scott Chang



P. S.



I deleted the name 'Northwind' in my SQL Server Management Studio Express, executed the "SQL2005DBScriptsInstnwind" program and I got the following error message: Msg 1802, Level 16, State 4, Line 1

CREATE DATABASE failed. Some file name listed could not be created. Checked related errors.

Msg 5170, Level 16, state 1, Line 1

Cannot create file 'c:Program FilesMicrosoft SQL ServerMSSQL.1DATAorthwindorthwind.ldf' because it already exist. Change the file path or the file name, and retry the operation.

Msg 15100, Level 16, State 1, Procedure sp_dboption, Line 64

The database 'Northwind' does not exist. Use sp_helpdb to show available database.

Msg 911, Level 16, State 1, Line 1

Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that name is entered correctly

View 5 Replies View Related

SQL Server 2005 Performance

Mar 10, 2008

Hello!I have a very simple structured table:id      |    datawhere "data" is a varchar(100) This table would contain a lot rows (~ 500.000.000) and I want to select all "id" where data=@data. Is it realistic that the SQL Server could serve this request on a normal webserver within 1 or 2 seconds? Thanks! 

View 1 Replies View Related

SQL Server 2005 Performance

Jun 5, 2006

I have recently upgraded from SQL Server 2000 to SQL Server 2005, and now all my queries run infinitely more slowly.

Here is the scenario - I run an extract of a MS SQL Server database at a client site, then recreate the database on our in-house server - but without indexes etc. Then I run various queries in order to created data files that will be used for importing into a global system. When I was running Server 2000, most of the queries ran in less than 10 seconds each, but under Server 2005 they take 3 minutes or more! Does anybody know of any parameters that I need to adjust to fix this problem?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved