Hello All,
I opened case #797909 with Solarwinds for help regarding the Web Access portal (KWA) timing out. The issue was that we maxed out the 4 GB database built into Kiwi. Solarwinds recommendation was to use the "log to database" feature in Kiwi combined with SQL reports to get the same information as the KWA. I was able to create a database in SQL and successfully send the syslog information to it from Kiwi. The trouble I am having now is getting SQL to manage the millions of rows that Kiwi is sending it to display meaningful reports (similar to the KWA). Has anybody successfully used SQL to create reports similar to the KWA?
I asked my DBA to look into this issue and this was her response.
"I am having an issue creating a report from SQL Server 2008 using KIWI Syslog. We created a SYSLogServer database in SQL Server 2008 R2 and connects Kiwi Syslog to the database successfully. Only one table is in the database Syslogd and that table is growing up really fast. We currently have 2.5 million records and running a simple select statement takes 2.36 minutes. I would like to create a report of the data and wanted to know if there is a way to make querying the table faster. Adding a clustered index doesn’t work and I am not sure if partitioning the table will either. What do you recommend in our situation?"
Thanks in advance for any help on this issue.
-Caleb
