Can I write perfmon counters to a database

Question

Can I write perfmon counters to a database

Wayne-153714

Hall of Fame

Points: 3536
More actions
June 28, 2005 at 6:35 am

#110563

Is it possible to write perfmon counters to a database, or to access the value of a counter from SQL, and thus write it to the database?
When in doubt - test, test, test!
Wayne

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

If you are using Windows XP or Windows Server 2003 you can create a counter log that logs to any data source. Otherwise you can log perfmon counters to a log file and then import it to a database.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 2

select * from master..sysperfinfo

will give you access to the SQLServer related counters

Bye
Gabor

Gimli Say Hey Kid Points: 687 More actions · Answer 3

Mayby you can use the Microsoft Health and History tool, especially the performance collector add in.

An article here at sqlservercentral describes the tool: http://www.sqlservercentral.com/columnists/kKellenberger/sqlh2thefreehealthhistoryandperformancemonitoringt.asp

Kindest Regards,

Gimli

If you are a spineless creature, they can't break you