02-12-04 02:38 PM
Quickest way to rebuild msde is to uninstall/reinstall Application Center.
Is that a option?
Thank You
George Cheng
Microsoft Application Center & Index Server Support
Note: This article has no warranties implicit or explicit.
All the content is given on the "as is" basis and the user
takes full responsibility for its use and assumption.
Microsoft Corporation Copyright 2004
All Rights Reserved
--------------------
| Content-Class: urn:content-classes:message
| From: <anonymous@discussions.microsoft.com>
| Sender: <anonymous@discussions.microsoft.com>
| References: <f50a01c3f15a$a9304750$a501280a@phx.gbl>
<5bYuurX8DHA.2348@cpmsftngxa07.phx.gbl>
| Subject: RE: Performance Monitor Counters all zero
| Date: Thu, 12 Feb 2004 14:48:32 -0800
| Lines: 99
| Message-ID: <fb0b01c3f1ba$57488f50$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcPxuldI8MMFExDlRJ62dkMvlur69Q==
| Newsgroups: microsoft.public.applicationcenter.admin
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.applicationcenter.admin:4888
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.applicationcenter.admin
|
| George,
| SQLAgents$MSAC is running. I have no SQL event log
| errors since 6am this morning when I was working with
| Perfmon counters. Here is one of those log events:
| __CLASS: MicrosoftAC_Monitoring_Logging_QueryFail
ed_Event
| __SERVER: RLX-0-0-9
| ServerGUID: {2102F2E1-577A-4A1C-AF88-4705D8F8D230}
| ConnString: Provider=SQLOLEDB;Integrated
| Security=SSPI;Data Source=10.0.0.11\MSAC;Initial
| Catalog=ACLog
| EventId: 8015
| GUID: {F1DBF378-9FCE-4395-84C9-6C9176051B26}
| OLEDBError: Source: Microsoft OLE DB Provider for SQL
| Server Description: [DBNETLIB][ConnectionOpen (Connect
| ()).]SQL Server does not exist or access denied.
| SQLSTATE: 08001 hr: 0x80004005
|
| Query: SELECT TOP 273 * FROM PerfHistoryView WHERE
| (Name='TCP Connections Established (Server Avg Cluster
| Sum)' OR Name='Memory Available Bytes (Server Avg Cluster
| Avg)' OR Name='Processor Utilization (Server Avg Cluster
| Avg)' ) AND (TimeMeasured <= {ts '2004-02-12
| 11:03:10.000'}) ORDER BY TimeMeasured DESC
| Status: 0xc0140060
| StatusMessage: Failed to authenticate, or connect to, SQL
| Server.
| TimeGenerated: 2/12/2004 11:03:10 AM
| Type: 1
| DisplayName: Monitoring Logging QueryFailed
|
| >-----Original Message-----
| >Are both the SQL services started and running? Any SQL
| errors in the event
| >viewer. Do the sql logs show anything?
| >
| >Thank You
| >
| >George Cheng
| >
| >Microsoft Application Center & Index Server Support
| >
| >Note: This article has no warranties implicit or
| explicit.
| >All the content is given on the "as is" basis and the
| user
| >takes full responsibility for its use and assumption.
| >Microsoft Corporation Copyright 2004
| >All Rights Reserved
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: <anonymous@discussions.microsoft.com>
| >| Sender: <anonymous@discussions.microsoft.com>
| >| Subject: Performance Monitor Counters all zero
| >| Date: Thu, 12 Feb 2004 03:23:38 -0800
| >| Lines: 17
| >| Message-ID: <f50a01c3f15a$a9304750$a501280a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE
| V5.50.4910.0300
| >| Thread-Index: AcPxWqkwNM30kWlHTGKGOFExqExQpA==
| >| Newsgroups: microsoft.public.applicationcenter.admin
| >| Path: cpmsftngxa07.phx.gbl
| >| Xref: cpmsftngxa07.phx.gbl
| microsoft.public.applicationcenter.admin:4881
| >| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.applicationcenter.admin
| >|
| >| Recently my performance monitors stopped working on
| App
| >| Center 2000 SP2 cluster controller app center perfmon
| >| counters. Earlier in the week we rebooted a cluster
| >| member and when it was brought back on line the
| perfmon
| >| counters for that server and the cluster controller
| >| always showed 0 but the other cluster members showed
| >| counters. Now all the counters show 0. I also had
| >| created another cluster contoller staging cluster a
| few
| >| days before on another server that is working fine
| with
| >| it's member. While working on this I received Event
| ID's
| >| 1001 & 1008. I deleted the counters and recreated and
| >| these errors went away but I still have 0 counters. I
| >| also rebooted all members and cluster controller to no
| >| avail. I also tried unlodctr and lotctr with no
| positive
| >| effect.
| >|
| >| Any suggestions?
| >|
| >
| >.
| >
|
[ Post a follow-up to this message ]
|