[kubesa]

I decided after having a lot of CSV files (1200 for last three months) to switch finally to database model for network audits, I choose MS SQL 8.0 as I think this doesn't require any additional installation on client side (all XPs), pls. correct me if I'm wrong.
However I was quite surprised how the conversion slow was and how big and slow database itself is, I'm sure there is something wrong. Conversion 181MB of CSV files (around 30PCs) was very long (1 hour maybe?). I thought it's normal. ...I expected rapid speedup with the Audit manager, but actually it's not like I expected, it's more or less the same as having CSV files on local disc.
After conversion Everest DB (MDF file) has 285MB (according Enterprise manager 8% of free space) ....

Now for example running query like that one below takes 3 minutes, maybe more. I'm not an expert, could someone from you share his experience, is it working as expected? SQL DB itself should be configured properly, as there is another system running on it and it's pretty fast (multiuser IS). I can't delete old reports from DB, as they are needed (audit requirement).

SELECT "Report"."RDateTime", "Report"."RHost", MAX( "Item"."IValue" ), "Item"."IDevice" 
FROM "everest"."everest"."Item" AS "Item", "everest"."everest"."Report" AS "Report" 
WHERE "Item"."ReportID" = "Report"."ID" 
GROUP BY "Report"."RDateTime", "Report"."RHost", "Item"."IDevice" 
HAVING ( ( "Item"."IDevice" LIKE '%dbx%' ) ) 
ORDER BY "Report"."RHost" ASC, MAX( "Item"."IValue" ) ASC

Explanation of the SQL query - I need from FILE SCANNER list of biggest DBX files per user, that are gathered by Everest.

This post has been edited by kubesa: 31 October 2009 - 10:47 PM

[kubesa]

Is there anyone who can help ?