SqlServer-QA.net

Though it is more to do with SQL Storage  kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances since, for example, two of the four servers could go down. In the majority of cases, ...

As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I ...

The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT ...

TEMPDB - though the name sounds like temporary database, it most important for any user database! Coming to performance tuning exercise or analysis you would go through Task Manager initially to see how system's  memory &  processor are coping up. Though they give initial picture of usage it is always better to go through by SYSMON ...

Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to troubleshoot problems on the server—even when the server is unresponsive to other client ...

See the relevant KBA resources here: When you run an MDX query in SQL Server 2005 Analysis Services, the query takes longer to run than expected http://support.microsoft.com/?kbid=935995 An MDX query takes longer than you expect to finish in SQL Server 2005 Analysis Services http://support.microsoft.com/?kbid=935996

Within the Relational SQL Server engine monitoring the performance is easy with pre-equipped tools such as Profiler, Database tuning advisor and Performance Monitor (SYSMON). How about for BI - Analysis Services monitoring in this case. Again PERFMON (SYSMON) is helpful here and the SQL Server 2005 Analysis Services performance monitor counters ...