Browse by Tags

SQL Server Analysis Services MDX Query performance monitoring - highlights

Published 29 January 8 3:27 AM | SSQA.net

When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...

Filed under: sql server, performance, mdx, query, best practices, tsql, monitoring, Analysis Services, baseline, benchmarking

Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks

Published 5 September 7 4:34 AM | SSQA.net

Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries...

Filed under: sql server, performance, mdx, tuning, ssas, query, best practices, tsql

Triggers within CLR - advantage over TSQL

Published 4 September 7 4:10 AM | SSQA.net

You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested...

Filed under: sql server, performance, query, clr, trigger, table, tsql, recursive, cte

TSQL to detect long running queries against the database

Published 29 August 7 6:37 AM | SSQA.net

When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id...

Filed under: sql server, performance, databases, query, tsql, running, long

Usage and good practices with UPDATE STATISTICS feature in SQL 2005

Published 23 July 7 5:39 AM | SSQA.net

UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...

Filed under: performance, security, dmv, query, optimization, tsql, statistics, update statistics