MSSQLTips

This post is related to this tip: Automating Performance Monitor Statistics Collection for SQL Server and Windows

http://www.mssqltips.com/tip.asp?tip=1776

I suggest looking into SQLH2 as well to capture perfmon data as well as SQL counter data

easier to config, as well as centralize from 1 location

 

Combine it with SSRS, you have a powerful history of performance of all the servers to compare

Hey,

 

So I've been using this technique for years across my database environment (but write directly into a SQL DB and use our monitoring page to aggregate and average out readings over a minute for live perfmon stats), but since I upgraded (in-place) all my clusters to SQL 2008 from SQL 2005 (still on WIndows 2003) I can no longer connect to any of the cluster names via perfmon from my remote perfmon box.  I just instantly get the error "Unable to Connect to Machine".  I can connect to the host names but that's not gonna work as I need the virtual names.

 All SQL 2008 instances on single boxes work fine, even ones with Windows Server 2008.

 Any ideas?

I actually have a slighly different question.  I can get these counters started, but I cannot figure out how to automate the process of dropping them all into the sql server database.  I am using 2005. 

 Anyone got a walk through or can give me pointers on how to do it?

 Thanks,

Fraggle

 After you collected the trace file, the next step is use relog to import them into database.

Refer to this article: 

http://www.mssqltips.com/tip.asp?tip=1722