Avatar of MrVault
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:

DNSWindows NetworkingWindows Server 2008

Avatar of undefined
Last Comment
MrVault

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Darius Ghassem

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Darius Ghassem

If you aren't using DNS  then I would consider using host files to point the clients directly to the server's IP addresses which would speed the response time since currently you are just doing a broadcast to find the IP address of  the server.

http://technet.microsoft.com/en-us/library/cc778792(WS.10).aspx
ASKER
MrVault

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?
Darius Ghassem

Now really a benefit if not domain or internal DNS servers are being used.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER
MrVault

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
MrVault

still waiting for an approved reboot. will update then.
ASKER
MrVault

The errors have gone away and it looks like we're still fine with the change in place. thanks everyone!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.