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 […]
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.
Number of active update transactions for the database.
Read/write throughput for backup/restore of a database.
Continue reading […] ‘Database name’ as a delimiting factor for SQL Server perfmon counters […]