SQL Server Performance


Discussion in 'SQL Server 2005 Analysis Services' started by california6, Oct 5, 2007.

  1. california6 New Member

    Can I run 2005 Profiler against 2000 AS Server?
  2. bradmcgehee New Member

    While 2005 Profiler can trace many 2000 events, it can't trace 2000 AS events.
  3. satya Moderator

    What is the basic problem with the AS server?
    I believe here "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 FilesMicrosoft SQL Server90SamplesAnalysis ServicesAdministratorascmd folder. For more information on the ascmd command-line utility, see the Readme For Ascmd Command-line Utility Sample on MSDN.

Share This Page