Browse by Tags

Site sponsored by:

RSS Feeds

parallel (RSS)

SQL Server 2005 EE Performance Problem - No Parallel Execution Plan for Large Query

Hi, I am working on a DW/BI project and I have a 16 way, 32 GB of ram system attached to a SAN with 32 arms. Our database is 50GB and growing quickly. I am have a large join query that is very slow, and does not execute using a parallel plan. I checked what queries where running in parallel and there...

Posted to SQL Server 2005 T-SQL Performance Tuning (Forum) by cmwahlqu on 02-01-2008
Monitoring the parallel processing performance of Analysis Services?

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. The ascmd.exe utility executes XMLA commands...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 10-08-2007