Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

BaseLine Expand / Collapse
Author
Message
Posted Thursday, January 2, 2014 7:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:26 PM
Points: 553, Visits: 670
Hi,
I am new to the SQL Server. I am trying to take baseline. I saw some videos and took some counters but I didn't see saving option to CSV or Excel. Please let me know how can I save that data collector set into CSV file in windows8 client version to compare with the profiler. Please help me any one knows.
Thanks.
Post #1527112
Posted Thursday, January 2, 2014 8:40 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 315, Visits: 426
I just choose the grid for the output then click in the upper left corner and copy the results and paste them into Excel. But not if there are millions of rows....
Post #1527157
Posted Thursday, January 2, 2014 9:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
I'm assuming we're talking Performance Monitor. The best way to collect the data is not to use the GUI that lets you look through the data. Instead, in the GUI, just below where it says Monitoring Tools on the left, you'll see "Data Collector Sets." This is what you want. Expand the folder and you'll see "User Defined." Right click on that, select New, Data Collector Set. Then, you can create from a template or create a custom collection. You can define this as going out to CSV files.

I have this documented with examples in my book on query performance tuning (linked below in my signature).


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1527189
Posted Thursday, January 2, 2014 9:40 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 315, Visits: 426
Oops, sorry, didn't read closely enough...
Post #1527192
Posted Friday, January 3, 2014 7:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:26 PM
Points: 553, Visits: 670
Hi,
Thanks for the replies.
I am able to create a user defined data collector from a template or create a custom collection but I am not able define this as going out to CSV files. I didn't see any option to send to the CSV file. If you have scree shot please share with me that will help me lot.
Thanks.
Post #1527530
Posted Friday, January 3, 2014 7:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
ramana3327 (1/3/2014)
Hi,
Thanks for the replies.
I am able to create a user defined data collector from a template or create a custom collection but I am not able define this as going out to CSV files. I didn't see any option to send to the CSV file. If you have scree shot please share with me that will help me lot.
Thanks.


The third screen in asks where you want to save the data on your disk. That's it. It says, right at the top "Where would you like the data to be saved?"


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1527534
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse