DSN, or Domain Naming System or Domain Naming Service, simply converts human readable names and URLs into a machine usable numeric IP address. For example when you type www.yahoo.com into your browser it converts that into 209.131.36.158, one of Yahoo's web servers.
Your ISP does provide DNS services but there are many other providers that you can use as well. One of the best known in IT circles is OpenDNS. Many ISPs' DNS servers are over-subscribed and this can result in performance issues on occasion. AT&T has some of the worst DNS servers on the Internet, IMHO. When DNS is slow or non-responsive it can severely affect performance.
OpenDNS attempts to resolve these problems by placing a number of extremely high-performance servers around the globe. These servers are configured with very large memory caches and they automatically fail over to other OpenDNS servers if one goes off-line. OpenDNS also offers optional filtering and blocking services that can block access to certain types of sites such as proxies, porn, or phishing and malware sites.
While some DNS providers do restrict access to their own customers, both AT&T and OpenDNS allow access to anyone world-wide without restriction. You can try OpenDNS at the following addresses:
208.67.222.222
208.67.220.220
Note that in a corporate or campus environment, DNS is usually provisioned by the network administrator and you must always use their DNS. If you don't, you'll lose access to internal resources and may not even be able to log on. In a small office or home environment there's no reason why you cannot manually configure your machines to use OpenDNS. You may be pleasantly surprised with it's performance. Check out their service at http://www.opendns.com