Acceptable Performance Counter ranges

I am having some performance issues with end users and the SQL Server. I'm not a SQL Server admin, but I want to learn how to use performance counters to monitor the SQL Server. I've been scouring the net trying to find performance counter information.
I have found alot of places that define each performance counter, but I have run across relatively few sites that contain acceptable values for the various different performance counters. For example, I've been to extremeexperts.com and found their arti
cle "Understanding SQL Performance Counters." And for example it explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1 or 2 indicates that we are having table/index page scans. We need to analyze how this can be avoided." I'm loo
king for information like the above where it said "Value greater than 1 or 2 ..." Does anyone know where I can get a full list of acceptable performance counter ranges?
Not sure if these have what your looking for but they are worth looking
over.
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Jason" <Jason@.discussions.microsoft.com> wrote in message
news:7450EA3C-549E-4EAB-9E46-D9CA956DF35A@.microsoft.com...
> I am having some performance issues with end users and the SQL Server.
I'm not a SQL Server admin, but I want to learn how to use performance
counters to monitor the SQL Server. I've been scouring the net trying to
find performance counter information. I have found alot of places that
define each performance counter, but I have run across relatively few sites
that contain acceptable values for the various different performance
counters. For example, I've been to extremeexperts.com and found their
article "Understanding SQL Performance Counters." And for example it
explains : "SQLSERVER:Access Methods - Full Scans/sec - Value greater than 1
or 2 indicates that we are having table/index page scans. We need to
analyze how this can be avoided." I'm looking for information like the
above where it said "Value greater than 1 or 2 ..." Does anyone know where
I can get a full list of acceptable performance counter ranges?