Browse by Tags

• Analysis Services
• certificate
• cpu
• create cache
• Development & Programming
• dmv
• forced
• i/o
• object_name
• performance
• Performance and Scalability
• query performance
• registry
• security
• SQL Analysis Service
• SQL Server
• tables
• tsql

• How to configure SQL servers to use certificates?

  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 ) Read More... Posted Monday, September 03, 2007 9:50 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, cache, certificate, registry

• SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

  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 Read More... Posted Wednesday, August 29, 2007 9:06 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: SQL Analysis Service, Development & Programming, Performance and Scalability, cache

• List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

  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 Read More... Posted Monday, August 06, 2007 5:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, cache, cpu, dmv, i/o

• Retrieve SessionID and batch information

  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 Read More... Posted Tuesday, July 24, 2007 7:37 PM from SSQA.net | (Comments Off) Filed under: performance, cache, tables, tsql, forced, object_name

• How to warm up the Analysis Services data cache using Create Cache statement?

  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. Read More... Posted Thursday, April 26, 2007 11:55 AM from Microsoft SQL Server Development Customer Advisory Team | (Comments Off) Filed under: Analysis Services, query performance, cache, create cache