InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 06:29:48 GMT20http://www.sqlservercentral.com/Forums/Topic948011-146-1.aspxI use these (from brentozar.com) and then add others if and when the need arises. •Memory – Available MBytes •Paging File – % Usage •Physical Disk – Avg. Disk sec/Read •Physical Disk – Avg. Disk sec/Write •Physical Disk – Disk Reads/sec •Physical Disk – Disk Writes/sec •Processor – % Processor Time •SQLServer: Buffer Manager – Page life expectancy •SQLServer: General Statistics – User Connections •SQLServer: Memory Manager – Memory Grants Pending •SQLServer: SQL Statistics – Batch Requests/sec •SQLServer: SQL Statistics – Compilations/sec •SQLServer: SQL Statistics – Recompilations/sec •System – Processor Queue LengthWed, 27 Feb 2013 01:26:18 GMTdavid.alcockhttp://www.sqlservercentral.com/Forums/Topic948011-146-1.aspxHi,I am also looking for the same, did you get the list of monitoring parameters you are going to be monitored and the thresholds- if you have any can you please share? Thanks.Tue, 26 Feb 2013 12:06:25 GMTmuthyala_51http://www.sqlservercentral.com/Forums/Topic948011-146-1.aspxWe are using BMC Patrol. What Windows PerfMon Counters should be Monitor SQL2005 by it to ensure SQL is running ok? ...thanksTue, 06 Jul 2010 10:13:23 GMTrew-370421