Collect SQL server statistics. Q: I need to periodically collect statistics such as transactions per second (tps) on the machine running SQLServer. To this end, I have used PerformanceMonitor (Performance Monitor) extensively. Q: I need to periodically collect statistics such as transactions per second (tps) on the machine running SQL Server. To this end, I have used a lot of Performance Monitor, but cannot obtain the SQL Server Performance indicators required by DBAs. Is there a practical tool that can easily collect such statistical information?
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 use Microsoft Windows®NT Server 4.0 Resource Kit or Microsoft Windows 2000 Server Resource Kit install Performance Monitor as a service. In addition, I recommend that you read Microsoft SQL Server 7.0 Performance Tuning Technical Reference by Steve Adrien DeLuca and others to learn about testing useful SQL Server Performance data.
-- Microsoft project manager, Richard Waymire
The transaction Server periodically collects statistics such as the number of transactions processed per second (tps. To this end, I have used a lot of Performance Monitor )...
