Browse by Tags

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.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...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

How to Analyze the PERFMON (SYSMON) data?

Published 20 August 7 1:26 PM | SSQA.net

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...

Filed under: sql server, perfmon, performance, analysis, databases, tuning, sysmon, tsql

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

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...

Filed under: sql server, performance, memory, analysis, ssms, dmv, cpu, disks

DMVs to provide state of TEMPDB during a performance tuning analysis

Published 14 August 7 8:55 AM | SSQA.net

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...

Filed under: sql server, performance, analysis, index, rebuild, tempdb, hardware

Dedicated Administrator Console (DAC) - saved an important day for a DBA

Published 4 August 7 9:9 AM | SSQA.net

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...

Filed under: sql server, performance, management, analysis, blocking, dba, dac, sac, investigation

MDX query performance issues in SQL 2005 Analysis Services

Published 6 May 7 5:20 AM | SqlServer-QA.net (SSQA)

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...

Filed under: performance, mdx, analysis

Monitor Analysis Services performance

Published 4 May 7 2:12 PM | SqlServer-QA.net (SSQA)

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...

Filed under: performance, analysis, server, bi