importing performance data from perfmon into sql server
-
How do you import perfmon data into a sql server database?
I want to learn how to do a performance baseline for a number of applications on different servers and this is the best way i can think of for doing it, along with using some DMV/DMF's
Is the standard way to export perf log files as Xml and then importing the xml into sql server? is there a better/easier way?
-
You could start by using relog.exe
http://blogs.msdn.com/granth/archive/2008/09/23/relogging-perfmon-binary-log-files-to-sql.aspx
* Noel -
for some reason i've never got it to work via ODBC into a remote database
-
Same .. I ususally save it to CSV then import to SQL Server if I have to do analysis.
The profiler up to Windows 2003 is really a paint to work with :(. I wish they made a new version avalaible like they have in Windows 2008; that tool is really slick to work with :).
[font="Arial"]---Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font] -
Not quite what you're asking, but Brent Ozar has blogged about how to analyze the perfmon data in Excel.
http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply