Some tools of the trade and why a DBA should know more

It is important to understand, that the DBA’s work is barely limited only to the mere database performance. Here is what I mean by this:

there is much more to the “well-being” of a system than just the good performance of the database. Very often I get to perform database performance analysis

Continue reading […] Some tools of the trade and why a DBA should know more […]

 

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