Administrating SQL Server Reporting Services - Planning, Documenting and Troubleshooting

I just had another article published at simple-talk.com: “Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting“.

The article is a deep dive into the configuration, security and performance of SSRS and is closely related to the SSRS Performance Dashboard which I recently developed.

 

Feel free to explore the article and to take a look at

Continue reading […] Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting […]

 

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