How to generate a graphic from perfmon of Windows 2008

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.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AlanConsultantCommented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

AlanConsultantCommented:
Good find AlokJain0412!

Alan.
0
marrowyungSenior Technical architecture (Data)Author Commented:
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
AlanConsultantCommented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
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
AlokJain0412Commented:

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
AlanConsultantCommented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
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
AlanConsultantCommented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
Alan3285,

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

DBA100.
0
AlanConsultantCommented:
Good luck!

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

Thanks,

Alan.
0
marrowyungSenior Technical architecture (Data)Author Commented:
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
AlanConsultantCommented:
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
marrowyungSenior Technical architecture (Data)Author Commented:
I testing SQLmanagerplus from ManageEngine
0
AlanConsultantCommented:
Okay.

Good luck!

Alan.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.