Collecting SQL Server Statistics_PHP Tutorial

Q: I need to periodically collect statistics such as transactions per second (tps) on the machine running SQL Server. To do this, I made extensive use of Performance Monitor, but I couldn't get the SQL Server performance metrics the DBA needed. Is there a practical tool that can easily collect such statistics?
A: One of the Performance Monitor counters for SQL Server can collect tps. Therefore, using Performance Monitor is the most convenient way to capture this indicator. You can install Performance Monitor as a service through the Microsoft Windows® NT Server 4.0 Resource Kit or the Microsoft Windows 2000 Server Resource Kit. Additionally, I recommend reading the Microsoft SQL Server 7.0 Performance Tuning Technical Reference by Steve Adrien DeLuca et al. to learn about testing useful SQL Server performance data.
——Microsoft Project Manager, Richard Waymire