August 20, 2013 at 9:40 am
Steve Jones - SSC Editor (8/19/2013)SQL Server is complex. We can't easily reduce the solutions to problems to a set of rigid protocols that ensure optimal performance. If we could, there truly wouldn't be as much of a need for DBAs as there is.
Good read and to the point. I would add one thing. Since SQL Server is complex and the configuration etc of the product depends ... There is very little chance that the SQL configuration out of the box will be optimal for most if any applications/systems. Due to both the complexity of the product and the business practices there is a high probability that the simple, default, generic configuration will need to be significantly altered to optimize the services needed.
Not all gray hairs are Dinosaurs!
August 20, 2013 at 4:04 pm
Miles Neale (8/20/2013)
Good read and to the point. I would add one thing. Since SQL Server is complex and the configuration etc of the product depends ... There is very little chance that the SQL configuration out of the box will be optimal for most if any applications/systems. Due to both the complexity of the product and the business practices there is a high probability that the simple, default, generic configuration will need to be significantly altered to optimize the services needed.
There is one configuration change that I always make immediately after I install SQL Server, and advise everyone else to do too. That is turn off Named Pipes. I don't know if they'll ever get rid of it, but I think it is the most useless thing M$ ever did.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
August 21, 2013 at 7:21 am
Jim P. (8/20/2013)
There is one configuration change that I always make immediately after I install SQL Server, and advise everyone else to do too. That is turn off Named Pipes. I don't know if they'll ever get rid of it, but I think it is the most useless thing M$ ever did.
LOL, named pipes used to be important. Back when I started, we weren't running TCP/IP and named pipes worked well to allow communication.
It is archaic and unneeded now, but it served a purpose at a time.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply