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 against an Analysis Services server.
The ascmd.exe utility is included in SQL Server Samples, available at SQL Server 2005 Samples and Sample Databases on the Microsoft Download Center. After you install the samples, you can find ascmd.exe in the c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Administrator\ascmd folder. For more information on the ascmd command-line utility, see the Readme For Ascmd Command-line Utility Sample on MSDN.
What can be confusing is that all of the Samples ship in source code, not as binary executables. If you want a version of the ascmd utility that you can run, you need to compile it by using either Visual Studio or the .NET Framework software development kit (SDK). The ascmd readme.html file has complete instructions for recompiling the utility. Recompiling is also covered in the SQL Server 2005 Books Online (BOL) entry for ascmd.
Further read on monitoring the parallel process in Analysis services: BLog link.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.