Performance Data Imported Into SQL Database
I am looking for a how-to or best practices guide on importing performance data into a database. I have been chasing a very difficult to find performance problem with one of my applications and have generated almost 30GB in data files. I would like to take all the performance data and import it into a SQL database and then be able to query and create reports based off of the information. If anyone has ideas or links that would be very helpful. Thanks in advance.Environment:Windows Server 2003 SP2 - ServerWindows XP SP3 - Clients
December 24th, 2009 7:53pm

What format is the data currently in?Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows]
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2009 8:02pm

All data has been collected as, or parsed into .csv format.
December 24th, 2009 8:23pm

Then it should be very easy to use the import wizard of SQL Server 2005/2008 to bring it into a new table. Very similar to the steps in this article.http://support.microsoft.com/kb/275685Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows]
Free Windows Admin Tool Kit Click here and download it now
December 24th, 2009 8:39pm

Yep, that does the trick. Thanks.
December 24th, 2009 10:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics