Solved

Effect of having a DNS suffix in the domain/workgroup settings?

Posted on 2010-11-15
7
1,048 Views
Last Modified: 2012-05-10
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:

0
Comment
Question by:MrVault
  • 4
  • 3
7 Comments
 
LVL 59

Accepted Solution

by:
Darius Ghassem earned 500 total points
ID: 34140938
One the append option appends the domain at the end of a DNS query

Another searches the list of domain names listed
0
 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 34140961
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
0
 

Author Comment

by:MrVault
ID: 34145171
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?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 59

Expert Comment

by:Darius Ghassem
ID: 34145599
Now really a benefit if not domain or internal DNS servers are being used.
0
 

Author Comment

by:MrVault
ID: 34175644
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.
0
 

Author Comment

by:MrVault
ID: 34219311
still waiting for an approved reboot. will update then.
0
 

Author Comment

by:MrVault
ID: 34249587
The errors have gone away and it looks like we're still fine with the change in place. thanks everyone!
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

BIND is the most widely used Name Server. A Name Server is the one that translates a site name to it's IP address. There is a new bug in BIND (https://kb.isc.org/article/AA-01272), affecting all versions of BIND 9 from BIND 9.1.0 (inclusive) thro…
I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now