PSSDiag Utility Questions

Would anyone can told me following about PSSDiag ?

1. The Performance Monitor output is default set to output as .BLG file, would it be other format like CSV or TXT ?

2. For SQL Trace log gathering location, even those we set to drive other than C:\ , it still need some spaces for temporary storage in C:\ under setting of TEMP and TMP path, so is PSSDIAG still need temporary spaces in dirve C:\
3. Does this utility also support monitor on SQL 2005 server ? Pls
Many Thanks First.
[2062 byte] By [TaTaLam] at [2008-1-7]
# 1

1. You cannot change the default output for PERFMON.

2. Yes it access the TEMP directory to perform few computations.

3. http://www.microsoft.com/downloads/details.aspx?familyid=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang=en refers :

System Requirements

  • Supported Operating Systems: Windows 2000; Windows NT; Windows Server 2003; Windows XP
SQL Server 2000 or SQL Server 7.0
MSXML 4.0 Service Pack 2 (Microsoft XML Core Services so no SQL 2005
SatyaSKJ at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 2

how about if my server cannot install MSXML 4.0 SP2 ? Can I use alternative method that use ini instead of xml configuration file ?

Also, can I find some example of the ini file format somewhere as I can't find any in the web especially those with some calling custom utility function as I want to start the Performance Monitor myself which can stored as csv format?

Many Thanks.

TaTaLam at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 3

Have you tested the installation of MSXML SP in thsi case?
SatyaSKJ at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 4
Satya SKJ wrote:

Have you tested the installation of MSXML SP in thsi case?

yes. if using MSXML4.0SP2, I can start the PSSDIAG but my production server not allow me to apply them. If so, need to go through a complex QC cycle. So, only test on testing server but cannot apply them into Production Server.

TaTaLam at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Tools General...
# 5

Then I believe we are out of option, either you can open a case with Microsoft Support to have desired facility or follow whatever is available.
SatyaSKJ at 2007-10-2 > top of Msdn Tech,SQL Server,SQL Server Tools General...

SQL Server

Site Classified