Continuation to the BlogPost on issuing or configuring SQL Servers to use certificates, I have found useful reference on Technet blogs - Mr. Cert’s side of the story ....(read more)

Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance bottlenecks in the execution of a poorly performing MDX query. To identify the source(s) ...

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within SQL Server 2005 improves accuracy by using the high-resolution counters that are capable to ...

You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement that is running since good olden days of SQL Server. Within SQL 2005 version you can take help of TSQL: SELECT session_id, text FROM sys.dm_exec_requests s1 CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2 Similarly you can look at ...

Goal This document describes how to build Create Cache commands.  Create Cache for Analysis Services (AS) was introduced in SP2 of SQL Server 2005. It can be used to make one or more queries run faster by populating the OLAP storage engine cache first.   Some customers have found certain queries benefit other later queries.  For ...