SQLDiag on 2005 x64

microsoft.public.sqlserver.tools

20 Dec 2006 6:54 PM

Ada

Hi All,

I am working on a performance issue on SQL Server 2005 Ent. SP1 x64-bit
cluster.

I am lack of available tools I used on 2000. How do you handle performance
issues on 2005 64-bit?

PSSDIAG : not supported

SQLDIAG on 2005 x64: giving me an error and I cant find sqldiag.xml file.

C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqldiag /O J:\PSS\ /B
200612
20_132100 /E 20061220_132300
2006/12/20 13:21:27.98 SQLDIAG Error creating script file . Function
result: 2.
Message: The system cannot find the file specified.

2006/12/20 13:21:27.98 SQLDIAG Error unpacking files. Aborting

Read80Trace: not supported

Blocker script: ???

Thanks,

Ada

--
SQL Server DBA