Browse by Tags

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose

SQL Server 2005 methods to find table INDEX or Statistics age for better performance

Published 9 January 8 2:55 AM | SSQA.net

Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...

Filed under: sql server, performance, query, index, process, agent, statistics, timeout, statiscs age

Monitoring the parallel processing performance of Analysis Services?

Published 8 October 7 3:8 AM | SSQA.net

The ascmd.exe command-line utility is a handy tool for testing performance characteristics to determine the appropriate values for parallel processing. This utility is similar to the sqlcmd.exe utility that you use to execute SQL statements in SQL Server...

Filed under: sql server, performance, data mining, process, tool, samples, Analysis Services, command line, parallel, ascmd

While processing Cubes - Error: Memory error: Allocation failure : Not enough storage is available to process this command

Published 27 August 7 5:47 AM | SSQA.net

Got an email to inbox asking a resolution for : I can't find a remedy for this problem on Google either. Any help would be appreciated. When performing the data mining cube process - Error: Memory error: Allocation failure : Not enough storage is...

Filed under: sql server, performance, memory, server, process, cube, Analysis Services

Table fragmentation, Index contention and locking issues to resolve

Published 31 July 7 9:31 AM | SSQA.net

Yet another important factors that every DBA needs to concerned about table & index fragmentation within their SQL Server environment. Refer to the a rticle about DetectTableFragmentation in both 2000 and 2005 version. Fragmentation occurs due to...

Filed under: sql server, profiler, performance, blocking, trace, process, table, locking, loss, fragmentation

Troubleshoot a process (SPID) using tools & TSQL queries

Published 31 May 7 10:50 AM | SSQA.net

First thing a DBA would follow to troubleshoot a query is to look at the process (SPID) ID for that query and with the help of Enterprise Manager tool looking at the Current Activity option under management pane will give you list of processes that are...

Filed under: sql server, performance, dmv, spid, sp_who, process