Performance Monitoring

Practical Solution to SQL Server Performance Monitoring
http://www.sql-server-performance.com/ss_performance_monitoring.asp
Serhiy Snisarenko's article includes code and hands-on instruction on how to automate such tedious tasks as reusing the preset monitor parameters and analyzing the results.


Shane Tasker
--
Contributing Editor, SQL-Server-Performance.Com
Independent Consultant

I am new to SQL Server - I'm mostly into Oracle. I was looking for the
clear
and easyperformance monitor implementation, checked out several
articles,
and this is the first one giving me ready scripts that would quickly
get the
data I need and also analyze them for me. I wish the scripts could
support
more counters though: for my problems I had to make two sets of them to
fit
into 1K string. Still - it was a big help. Thank you!

Alex Arin
Oracle Certified DBA

Alex Arin

Let me know threshold value for each counter

M A Srinivas