'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 […]

 

SQL Server Perfmon (Performance Monitor) Best Practices

In a recent post I wrote that there are many ways to solve a problem.

In this post I will talk about the Perfmon and specifically about performance counters collection. Brent Ozar wrote a great article a while back on the Perfmon Best practices and in his article he suggests the use of perfmon logs and

Continue reading […] SQL Server Perfmon (Performance Monitor) Best Practices […]