SQL Server Performance


Discussion in 'Performance Tuning for Hardware Configurations' started by PAMUR, Sep 14, 2005.

  1. PAMUR New Member

    Dear All,<br /><br />What is the easiest way to get the details of Server COnfiguration?<br />Oops! am I asking a stupid question? [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />Software and Hard Ware.<br /><br /><br />Thanks<br /><br /><br />Usha Rani
  2. johnson_ef Member

    No question is Stupid..

    You can use the tool called SQLDIAG (sqldiag.exe) which will be in (DRIVE:program FilesMicrosoft SQL ServerMSSQLBinn)

    Once run this tool, this will create a log in the LOG folder.

    This will detailed information about whole config about the server and more details like, logs etc..

  3. satya Moderator

    True, valid answer by John.
    You don't have any downtrend in using this tool as many times MS PSS will ask to run for the configuraiton.

    As John said we all learn from asking simple questions, without a question there is no answer.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. PAMUR New Member

    Thanks a Lot John.

    Usha Rani
  5. PAMUR New Member

    Thanks Satya and John. I will get if need more info.

    Usha Rani
  6. johnson_ef Member

    You are welcome Usha Rani!!

  7. FrankKalis Moderator

    Just in case you are using SQL Server 2000 with SP 4. You'll receive a "Buffer overrun" error message. This is a known and already reported bug. There is a workaround in that you replace the sqldiag.exe file with the one on your installation CD. That seems to work.

    Frank Kalis
    Microsoft SQL Server MVP
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  8. johnson_ef Member

    Thanks Frank,<br /><br />I was not aware of this bug, now I tried and I got error in my server where I have applied SP4, and I got this error, and tried with the older copy of SQLDIAG (sqldiag.exe) with your solution.. Its working.. Thanks once again!<br /><br /><img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />-Johnson
  9. PAMUR New Member

    Thank u Frank.

    As always helpfull.

    Usha Rani

Share This Page