Q: I need to periodically collect statistics such as the number of transactions per second (TPS) on a machine running SQL Server. To do this, I used a lot of performance Monitor (Performance Monitor), but I couldn't get the SQL Server performance metrics required by the DBA. Is there a utility that can easily collect this kind of statistical information?
A: TPS can be collected for one of the Performance Monitor counters of SQL Server, so using Performance Monitor is the easiest way to capture this metric. You can install performance Monitor as a service through Microsoft Windows®nt Server 4.0 Resource Kit or Microsoft Windows Server Resource Kit. In addition, I recommend that you read the Microsoft SQL Server 7.0 performance Tuning Technical Reference for people like Steve Adrien DeLuca to learn about testing useful SQL The contents of the server performance data.
--microsoft project manager, Richard Waymire
http://www.bkjia.com/PHPjc/631168.html www.bkjia.com true http://www.bkjia.com/PHPjc/631168.html techarticle Q: I need to periodically collect statistics such as the number of transactions per second (TPS) on a machine running SQL Server. To do this, I used a lot of performance Monitor (Performance Monitor) ...
