marrowyung
asked on
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.
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.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good find AlokJain0412!
Alan.
Alan.
ASKER
someone say from perfmon, we can open that CSV, is that right ?I can find import directly from perfmon, anyone know where it is ?
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.
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.
ASKER
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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.
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.
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.
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.
ASKER
Alan3285,
Good, I will have meeting with them tomorrow, but meanwhile I will try you all suggestion, thanks..
DBA100.
Good, I will have meeting with them tomorrow, but meanwhile I will try you all suggestion, thanks..
DBA100.
Good luck!
Please do post how to do it back here if you get a result with the consultant.
Thanks,
Alan.
Please do post how to do it back here if you get a result with the consultant.
Thanks,
Alan.
ASKER
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...
--------------------------
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...
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.
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.
ASKER
I testing SQLmanagerplus from ManageEngine
Okay.
Good luck!
Alan.
Good luck!
Alan.
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.