Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to generate a graphic from perfmon of Windows 2008

Posted on 2011-10-30
17
Medium Priority
?
640 Views
Last Modified: 2012-05-12
Dear all expertist,

Right now we have use perfmon to record all performance figure of our SQL Server 2008, we generate the output to a CSV file, any tools you can use to generate a graphic view to analysis the performance issue if any.

any tools (free preferrabely) other than excel can do it or you can provide information on how to do it on excel, there are too much column from the CSV for excel to port the graphic I think.

DBA100.
0
Comment
Question by:marrowyung
  • 8
  • 7
  • 2
17 Comments
 
LVL 21

Expert Comment

by:Alan
ID: 37054937
Hi,

I'd use Excel.

Excel up to 2003 can import up to 256 columns of data, 65536 rows.

Excel from 2007 can import up to 16,384 columns, and more than a million rows, so it should be fine I would imagine?

What error are you getting on trying to import to excel?

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37055014
Alan3285,

I don't mean there are errors, how to generate that report using excel in a meaningful graphic evne there are a lot of column?

DBA100.
0
 
LVL 5

Accepted Solution

by:
AlokJain0412 earned 2000 total points
ID: 37055048
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 21

Expert Comment

by:Alan
ID: 37055068
Good find AlokJain0412!

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37055960
someone say from perfmon, we can open that CSV, is that right ?I can find import directly from perfmon, anyone know where it is ?
0
 
LVL 21

Expert Comment

by:Alan
ID: 37059074
Not entirely sure what you mean.

I am sitting in front of an XP machine right now :-( so its likely similar but different on your machine, but if I open the 'Performance Logs & Alerts', snapin, then select 'Counter Logs' and open that, I can then configure it to log to whatever format I choose and wherever I choose.

For example, you can add different counters and frequencies etc (general tab), change the log file type to CSV, and where they get saved (log files tab), and the schedule (schedule tab).

So to make it automatically do CSVs set that in there, then open the logs in excel whenever you want to analyse them.  Once setup, you shouldn't need to go into PerMon again unless you want to change the settings.

HTH,

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37060878
Alan3285,

What I mean is  can I make a graphic view of the log directly from perfmon once the performance monitoring is done.

Is it possible, basically it is one MS consultant told me it woroks from Windows 2008 R2 server.

I don't know how might be he is right .

DBA100.
0
 
LVL 5

Assisted Solution

by:AlokJain0412
AlokJain0412 earned 2000 total points
ID: 37060937

I think need to download nexus  tool from codeplex  
it has all features which u required ,

http://sqlnexus.codeplex.com/



Pssdiag and Sqldiag Manager
http://diagmanager.codeplex.com/


So u please go through and use it if u find it useful
0
 
LVL 21

Expert Comment

by:Alan
ID: 37061038
Hi,

I don't know of a way of doing that natively out of the box in Win Server 2008, but I'm sure there are many third-party applications that will do similar things such as the codeplex one that is mentioned above.

Personally, I won't install those kinds of applications on my servers, but its up to you of course.

I always just use Excel to pull in the data sets, and run from there.  Its easier and safer than fiddling around in the guts of the server, and the worst thing that can happen is that I corrupt a log file (assuming I don't work on copies).

HTH,

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37061057
Alan3285:

What the MS consultant say is this is the default function of perfmon of Windows 2008, build in tools.

What is the tools from codeplex can help on this, please show me a URL.

DBA100.
0
 
LVL 21

Expert Comment

by:Alan
ID: 37061637
Hi marrowyung,

I haven't used codeplex - it was mentioned by AlokJain0412 above.

If your consultant can tell you how to do what you need using the built in tools in Win Server 2008, then please do post back here so that others who follow can use it too.

Thanks,

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37061684
Alan3285,

Good, I will have meeting with them tomorrow, but meanwhile I will try you all suggestion, thanks..

DBA100.
0
 
LVL 21

Expert Comment

by:Alan
ID: 37061751
Good luck!

Please do post how to do it back here if you get a result with the consultant.

Thanks,

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37940043
Alan3285,

----------------------------
Personally, I won't install those kinds of applications on my servers, but its up to you of course.

I always just use Excel to pull in the data sets, and run from there.  Its easier and safer than fiddling around in the guts of the server, and the worst thing that can happen is that I corrupt a log file (assuming I don't work on copies).

------------------------------

Is that mean there is a bit concern on monitoring tools for SQL server, right? what if a tools only need a port to monitor the SQL server? and pull information from SQL server every 2 minutes?

you mean use perfmon to get data to excel in CSV format, and then create graphic based on this ?

Dont' trust the MS consultant there, they just use the same perfmon graphic and select a time range and show us the same thing...
0
 
LVL 21

Expert Comment

by:Alan
ID: 37940536
Hi DBA100,

My comment was general in nature, rather than specific to any particular service or application.

In general, I always prefer to take raw logs from the service / application etc, and then import them into, say, Excel, and do my analysis and graphs etc in there.

That way, I avoid installing some third party applications or addons that might slow things down, cause problems or conflicts, cost money, and require maintenance / updates.

Just my way of course.

Alan.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 37940869
I testing SQLmanagerplus from ManageEngine
0
 
LVL 21

Expert Comment

by:Alan
ID: 37944382
Okay.

Good luck!

Alan.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A safe way to clean winsxs folder from your windows server 2008 R2 editions
I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question