Configuration | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


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
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.. -Johnson
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.
Thanks a Lot John. Usha Rani
Thanks Satya and John. I will get if need more info. Usha Rani
You are welcome Usha Rani!! -Johnson
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.

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
Thank u Frank.
As always helpfull. Usha Rani