'Database name' as a delimiting factor for SQL Server perfmon counters

As a further reading after the performance tuning in shared secure environment, I am posting a list of SQL Server┬áperfmon counters which take ‘database name’ as a delimiting parameter.

\SQLServer:Databases(database_name)\Active Transactions

Number of active update transactions for the database.

\SQLServer:Databases(database_name)\Backup/Restore Throughput/sec

Read/write throughput for backup/restore of a database.

\SQLServer:Databases(database_name)\Bulk Copy

Continue reading […] ‘Database name’ as a delimiting factor for SQL Server perfmon counters […]

 

The wheel of performance information gathering

SQL Server is such a grand product that it has its own set of performance information providers. The product ships with these tools (well, some of them are built in the Windows platform, but SQL Server brings extras to them, for example Perfmon).

Here is the Wheel of Performance tuning tools:

The Wheel of Performance tuning

Continue reading […] The wheel of performance information gathering […]