Solved

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

Posted on 2010-11-15
7
1,096 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to find computer SID in windows server 2008 r2 3 100
FTP server windows 2008 5 39
SOA*.tmp files 2 45
Modify Permissions in Windows Folders. 15 32
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

860 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