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. 
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|||
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.
|||
Have you tested the installation of MSXML SP in thsi case?|||
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.
|||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.
