Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Profiler and Perf. Monitor

Author  Topic 

bryan99y
Starting Member

42 Posts

Posted - 2002-04-11 : 16:26:09
I am running stress tests for one our Applications. The Database Server is SQL Server 2000 Stardard.
I can setup SQL Profiler and dump the results into a Table fine. What I am having trouble with is Performance Monitor data. I can dump it to a file but is is VERY missed up. Everything is continious, no tabs separating data columns, etc.

any ideas ?

I want to be able to dump the Performance Monitor results to a file, then import the file into SQL Server.


izaltsman
A custom title

1139 Posts

Posted - 2002-04-11 : 18:17:45
quote:

I can dump it to a file but is is VERY missed up. Everything is continious, no tabs separating data columns, etc.



How are you saving your Perfmon data to a file? I set up a performance counter log just the other day, and imported it into Excel with no problems... I specified "Text - CSV" for my file format.


---------------
Strong SQL Developer wanted in the Boston area. Please e-mail if interested.

Edited by - izaltsman on 04/11/2002 18:18:45
Go to Top of Page
   

- Advertisement -