MrVault
asked on
Effect of having a DNS suffix in the domain/workgroup settings?
I have no idea if this is causing any issues or not, but one of our 10 SQL servers is having performance issues. There are many things I can look for in perfmon, but one thing that stood out immediately is this.
All of our SQL servers are in the same workgroup. There is no domain or Windows DNS servers for various reasons. One the one that's poorly performing, if you go to the workgroup name settin and click the More... button there is a DNS suffix listed in the text box unlike the rest which having nothing in there.
My first question is "what is the effect of having something in or not in this field and could that possibly affect our experience/performance?"
My second question is:
"What is the difference between this setting here and the NIC properties settings which say either (A) "Append primary and connection specific DNS suffixes [append parent suffixes of the primary DNS suffix], or (B) Append these DNS suffixes (in order)"?
My last question is:
All of our SQL servers are in the same workgroup. There is no domain or Windows DNS servers for various reasons. One the one that's poorly performing, if you go to the workgroup name settin and click the More... button there is a DNS suffix listed in the text box unlike the rest which having nothing in there.
My first question is "what is the effect of having something in or not in this field and could that possibly affect our experience/performance?"
My second question is:
"What is the difference between this setting here and the NIC properties settings which say either (A) "Append primary and connection specific DNS suffixes [append parent suffixes of the primary DNS suffix], or (B) Append these DNS suffixes (in order)"?
My last question is:
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Our servers don't talk to each other. Only the clients/customers point to our servers.
For the dns suffix in the computer name properties, what effect does it have by putting something there? I realize the NIC settings give it additional dns suffixes to use when searching by computer name (so it could search "pc1.mydomain.com" or pc1.myotherdomain.com.
But in workgroup environment, what benefit or hindrance could it be causing by appending "mydomain.com" on the end of the PC name?
For the dns suffix in the computer name properties, what effect does it have by putting something there? I realize the NIC settings give it additional dns suffixes to use when searching by computer name (so it could search "pc1.mydomain.com" or pc1.myotherdomain.com.
But in workgroup environment, what benefit or hindrance could it be causing by appending "mydomain.com" on the end of the PC name?
Now really a benefit if not domain or internal DNS servers are being used.
ASKER
thanks. I removed the setting but we can't reboot until early next week. so I'll report back then to see if it's fixed anything.
ASKER
still waiting for an approved reboot. will update then.
ASKER
The errors have gone away and it looks like we're still fine with the change in place. thanks everyone!
Windows Server 2008
Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.
86K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://technet.microsoft.com/en-us/library/cc778792(WS.10).aspx