Browse by Tags

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

Published 4 March 8 2:4 AM | SSQA.net

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...

Filed under: sql server, performance, ssms, query, users, execution plan, monitoring, new features, .xml, plan cache, document, .sqlplan

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