SQL Server Performance Forum – Threads Archive

Configuration

Dear All, What is the easiest way to get the details of Server COnfiguration? Oops! am I asking a stupid question? [<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />] Software and Hard Ware. Thanks Usha Rani

No question is Stupid.. You can use the tool called SQLDIAG (sqldiag.exe) which will be in (DRIVE

rogram 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
Moderator
http://www.SQL-Server-Performance.Com/forum
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
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Thanks Frank, 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! <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> -Johnson

Thank u Frank.
As always helpfull. Usha Rani

]]>