Browse by Tags

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

TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)

Published 4 September 7 9:32 AM | SSQA.net

PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...

Filed under: sql server, stats, performance, blocking, tuning, query, stored procedure, statistics, parallelism, contribution

Performance Tuning - will I loss the indexing when using derived table?

Published 21 August 7 3:19 AM | SSQA.net

This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables...

Filed under: sql server, performance, tuning, query, stored procedure, joins, indexed views

Make use of tools and utilities that are available in SQL Server - performance & tuning

Published 8 July 7 7:19 AM | SSQA.net

There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information...

Filed under: performance, tuning, query, error, kba, script, troubleshoot, sqldiag, sqldumper