Hi,
performance issues can be caused by many factors. What about average load on servers? Does it seem to be issue on application server or on database server?
Do you have any table with lot of data (Traps, SysLogs etc.)?
Do you have lot of groups (let's over 100)?
From slow web page it could seem like slow database or Information Service (it can be slow itself or again because slow database) but it is hard to say without any additional data.
We have no idea at this point - this is why I thought of posting here to see where it would be suggested to start looking.
Table with lots of data - define "lots"? Largest table is InterfaceTraffic_Detail sitting at 1.8GB in size if that's a reference point?
No groups so that's easy to answer. Is there a routine maintenance activity on the SQL backend that we should be performing - as we were lead to believe there isn't much you need to do with 2008 on a regular basis.... comment?
Thanks.
What about processes on application server? Is there any SolarWinds process which has high CPU or memory utilization?
In general I don't think you should have performance issue with mentioned amount of elements. Probably best way how to help would be directly via online meeting.
Thanks - I ran some DB maintenance early this morning and that seems to have helped quite a bit. Compressed the DB etc
Will open ticket if this issue shows up again - appreciate the input.
Sorry - didn't answer your questions though. CPU averages 5% and memory consumption is around 3GB normally.
