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

SQL Server 2005 Best Practices Analyzer January 2008 update

Published 25 January 8 4:8 AM | SSQA.net

Here is another new year gift from Microsoft for the SQL Server users, specifically for 2005 version - release of SQL Server 2005 Best Practices Analyzer (January 2008). BPA's job is to gather data from Windows and SQL Server configuration settings...

Filed under: sql server, microsoft, download, best practices, 2008, ctp, analyzer, 2005, Analysis Services, extent, rtm