Understanding and analyzing your SSRS report execution statistics is critical if you are serious about optimizing your SSRS reports, over the years working with SSRS I have found and developed a few procedures that are helpful in analyzing problematic report (in terms of execution time).

This post will go through some of the procedures you could use to look at your SSRS reports execution times.

Read more →

Analyzing the performance of your SSRS reports in terms of execution and rendering time is crucial when trying to optimize your SSRS reports. Although SQL Server’s Reporting Service could be a bit of a black box sometimes, usually there are some back-end ways to accomplish most tasks.

This post will go through the SQL Server Reporting Service (SSRS) Execution Types (stages), as well as some top line recommendations on how to optimize the time taken to execute each stage.

To get your SSRS reports execution statistics, you can check out my SSRS Report Execution Statistics and Analysis post.

Read more →

Sometimes you might need to re-organize your SQL server files around the server in order to improve I/O efficiency or simply because the current structure cannot coupe with the transaction log file or data file growth rate, and you need to expand onto other drives.

This post goes through how one might go about changing the SQL Server 2008 transaction log or data file location, commit this file move, and also diagnose and resolve any errors that could arise from performing such a move.

Read more →

You have probably reached this page after receiving the following error message: Server ‘SERVERNAME’ is not configured for RPC. [SQLSTATE 42000] (Error 7411). This article will explain why you are receiving this error, and what can you do resolve it.

Read more →

your SQL Server Collation choice for your database (or server) will control how characters will be sorted and compared within the database or SQL Server in general.

DBAs must choose a collation carefully that matches the type of characters encountered in a particular database. It is important to take into account as well how this database will interact with other database in the same instances, or through a linked SQL Server instances.

Read more →

Until recently I had no idea SSIS allowed opening multiple connections to (flat) files, but due to the performance and parallelism implication of such a connection, I thought its definitely worth blogging about.

Read more →

Managing space on your SQL Server Transaction Log can sometimes be daunting, usually if you have a good backup strategy, and a well moderated database (in terms of monitoring and flagging long running transactions), then you will rarely run into unexpected large growth of your transaction log file. But in the real world this is rarely the case, and there will be occasions when you leave a very long transaction running over night (or days), or there is a schedule clash between two queries, or between a query and the backup schedule, which caused a failure in your log truncation strategy.

The daunting part is making sure that you recover from the situation with minimum data loss and disruption to the database’s recovery strategy. In this post I will go through the most common scenarios of transaction log growth, and how to resolve them.
Read more →

I write this post after a hellish experience that lasted a couple of hours trying to sort out the SSL certificate for SSRS.
Read more →

SQL Server’s Graphical Execution Plan contains a wealth of information that could be used to diagnose performance and maintenance (such as out of date statistics) issues.

Read more →

As you probably already know, SQL Server has many DMVs (Dynamic Management Views) and System Objects that helps DBAs, these include performance counters, index statistics, resource locking information, user object IDs and many more.

Read more →