Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

RME SLOW

I have been running my syslog severity level summary report per device type for almost two years with no problems. lately the report takes about about five minutes to appear instead of 20 seconds.

Every other funcntion on the RME menu seems normal.

I had the server team check the server and they say it works just fine.

FYI I run another ap on this same server with no issues.

LMS 2.6 RME 4.0.6

Any help appreciated.

6 REPLIES
Cisco Employee

Re: RME SLOW

It could be that you have a lot more syslog messages now, and the SQL queries are taking longer to run. What are your syslog purging settings? How many messages are you receiving per second?

New Member

Re: RME SLOW

i keep for 7 days and purge everyday

I know that we receive a lot per second because the ASA's send a lot.

Cisco Employee

Re: RME SLOW

There is something you could try. If the syslog dataspace has become overly fragmented, this could lead to a performance problem. TAC Can provide you with a DBSpaceReclaimer.class tool which will drop and recreate these dataspaces. All current syslogs will be lost (but you could save them out to a flat file first), but you'll have a clean slate for running reports moving forward.

Of course, if, during the following week, performance gradually gets worse, then the amount of syslogs is certainly causing the problem. In that case, your workarounds are:

* Get more CPU power (i.e. more CPUs, cores, etc.)

* Configure a shorter purge cycle

* Schedule the reports so you're not sitting on the computer waiting for them to complete.

New Member

Re: RME SLOW

My LMS 2.6 is not under smartnet contract so how do I get the DBSpace tool?

Cisco Employee

Re: RME SLOW

If you cannot open a TAC service request, you cannot get this tool. It cannot be posted to the forum.

New Member

Re: RME SLOW

Ok thanks for the help

May just reduce the number of syslog msg that we are keeping.

167
Views
0
Helpful
6
Replies
CreatePlease login to create content