Over the last years I have blogged about a lot of topics related to the performance of SQL Server and SQL Reporting services. In this blog I will give an overview of the different articles I have published in the last 2 years.
SQL Server:
Monitoring
- Part 3: Analyze SQL Profile traces with a SSRS dashboard The report itself.
- Part 2: Analyze SQL Profile traces with a SSRS dashboard. How does it work.
- Part 1: Analyze SQL Profile traces with a SSRS dashboard.
- Combine SQL Profiler with Performance monitor logs.
- Use SQL Profiler replay traces to benchmark performance of your SQL Server database.
- More details about concurrency, locking and blocking in SQL Server.
- Bad performance and lockings occur ad random on my database.
- How to measure performance of your SQL Server.
- How to find table scans in your database.
- Index statistics and suggestions of a table in one query.
- Which fillfactor should I use to improve performance. of my index.
- When to use the INCLUDE option in the Create index statement
- My filtered index is not used: The impact of forced parameterization.
- What triggers the update of statistics in my SQL 2008 database, when are statistics out of date?
- Which indexes are not used in my database?
- How to find duplicate indexes
Other
- What is optimize for ad hoc workloads option in SQL 2008 and how to configure
- Backup compression in SQL Server 2008 (R2)
- Uses batches to delete large number of records in a table.
Reporting Services:
- More tips to improve performance of SSRS reports.
- Analyze performance of your reporting services reports using SSRS statistics.
- Tips to improve performance of SSRS reports
SQL Azure
- Troubleshooting and optimizing queries on SQL Azure
- Usefull DMV's for SQL Azure to analyze if you miss SQL Profiler
SQL Azure Reporting:
