topic Re: PMP log Purge in Server Management - Systems Insight Manager

PMP log Purge

nathan_78 — Tue, 14 Dec 2004 12:05:35 GMT

Has anyone experienced a NO Records found message when trying to a LOG purge or run a PMP report in the SIM console?? I am collecting data cause the DB in, SQL enterprise Admin, shows it growing in size. It is collecting up to a gig of data per week. But yet in PMP console gives me that "No Records" message.

Anyone have a clue? I am trying to avoid a reinstall of PMP per HP.

Thanks

Re: PMP log Purge

Jon Ward — Sat, 18 Dec 2004 17:23:43 GMT

Is it the PMP database that is growing that much or is it the SIM database? That is an awful lot of data growth!

Re: PMP log Purge

nathan_78 — Mon, 20 Dec 2004 10:03:00 GMT

It was the PMP database we sample 300+ servers every 5 min i believe. Per HP this should not be an issue. I still uestion that due to the volume we are sampleing.

I did follow through with a reinstall of PMP. I was then able to bring up the purge log with the new database. Just for a test I place the old DB back in and it seemed to have failed. Something is wrong with the old Database.

My concern is how did that Data get corrupt or is it the size? Hp does not have an answer for that at the moment and I am still working with them on this.

Re: PMP log Purge

Jon Ward — Mon, 20 Dec 2004 16:42:02 GMT

Primary concerns:

- Overall server health. To ensure the server that SQL server is running on is healthy, use the hp Management Agents or another diagnostics tool.

- Run chkdsk and defrag to ensure Microsoft partition/volume health.

- Run DBCC CHECKDB to ensure the table is not corrupted (the details of this operation is considered an advanced SQL topic and is beyond my everyday knowlege)

- Check SQL logs, application logs, and system logs.

Re: PMP log Purge

nathan_78 — Mon, 20 Dec 2004 17:09:42 GMT

Thank you John I will try the formentioned things and try to get back here for a response.