Hello, another problem, my server is extremely slow, the CPU usage is acceptable, but the memory is always consumed entirety, SQL eat about 1.4 Gb of RAM, any idea?
Database Details ------------------------------------------------------------------------------- Web Server SSP-SWNPM-O Operating System Windows 2003 Enterprise Edition OS Version 5.2.3790 Service Pack 2.0 Database Server (local) Catalog NetPerfMon Database Engine Microsoft SQL Server SQL Version Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) Security Model User Name \ Password User Name solar Connection Timeout 20 seconds Network Elements 1603 Elements Nodes 374 Nodes Interfaces 1190 Interfaces Volumes 39 Volumes Alerts 0 Alerts Events 28323 Events Pollers 2565 Pollers Polling Engines 1 Polling Engines Oldest Event 05-Ago-07 00:00 Oldest Daily Traffic Stat 01-Oct-07 00:00 Oldest Hourly Traffic Stat 16-Oct-07 00:00 Oldest Detailed Traffic Stat 08-Nov-07 15:04 Last Database Archive 13-Dic-07 02:15 Next Scheduled Database Archive 14-Dic-07 02:15 Database Archive Time 02:15 Retain Detail Stats 30 Days Retain Hourly Stats 60 Days Retain Daily Stats 1095 Days Retain Events 977 Days
What Orion version are you running? Is this slowness tied to an event such as upgrading Orion, adding a large number of new elements, or has it always been this slow?
Is SQL installed on the same server as Orion? Also, you might want to read this thread regarding Orion 8.5 performance.