PMP log Purge

[nathan_78]

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

[Jon Ward]

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

[nathan_78]

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.

[Jon Ward]

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.

[nathan_78]

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