PRB: SQLDiag Output Incomplete Against Clustered Server

ID: Q233332

The information in this article applies to:

SYMPTOMS

When a server is set up with SQL Clustering, the output from SQLDiag is incomplete.


WORKAROUND

Use the following steps to get all information provided by SQLDiag:

  1. Connect to the virtual server using Query Analyzer.


  2. Run the following command to obtain the SQL Server information: 
    
xp_cmdshell '<shared drive>\mssql7\binn\sqldiag -E -O<local drive>\SQLdiag.txt'


  3. Run the following from a command prompt to get the system information: 
    
winmsd \\<nodename> /a /f
    Executing the code creates a file, nodename.txt, in the directory from which winmsd was executed. For further information on winmsd parameters, run the following from a command prompt: 
    
winmsd /?


REFERENCES

SQL Server Books Online; search on: "SQLDiag parameters"

Additional query words: 


Keywords          : kbSQLServ700 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbprb

Last Reviewed: July 29, 1999