November 11, 2002 at 12:51 pm
Do anyone knows how to collect metrics on SQL Server (6.6, 7.0 or 2000 version)?
Is there any tool on the server to do this?
By metics, I mean performance,disk space, I/O and ect.
November 11, 2002 at 1:02 pm
SQL Server has it own Performance moniter to collect the metrics
November 11, 2002 at 4:05 pm
When you install SQL to an NT server it will add serveral counters to Performance Monitor that you can select and use. Check out http://www.sql-server-performance.com there are several helpfull item in the performance monitoring section.
November 12, 2002 at 8:52 am
<Shameless plug>
I cover how to do these in my e-Book as well. It's available at a discount for SQL Server Central users through NetImpress.
</Shameless plug>
Also, the SQL Server specific counters are available through the sysperfinfo system table in SQL Server 7.0 and 2000. This table won't include the OS performance counters. It is only inclusive of the objects SQL Server adds to Performance Monitor.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply