April 5, 2012 at 1:28 pm
I was reading through this topic: http://msdn.microsoft.com/en-us/library/ms189310(v=sql.105).aspx
My question is wont JUST adding the new port number in IPALL filed will suffice ? Why do I have to go through creating a new end point.
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the process of creating a new end point.
Thanks
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
April 5, 2012 at 3:37 pm
April 5, 2012 at 4:12 pm
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the process of creating a new end point.
Yes, you should create the new endpoint.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2012 at 4:18 pm
SQLRNNR (4/5/2012)
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the process of creating a new end point.
Yes, you should create the new endpoint.
Advantages of two separate endpoints versus one listening on two ports?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 5, 2012 at 4:24 pm
opc.three (4/5/2012)
SQLRNNR (4/5/2012)
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the process of creating a new end point.
Yes, you should create the new endpoint.
Advantages of two separate endpoints versus one listening on two ports?
The article the OP referenced talks about TDS (tabular data stream) and it could be beneficial there. Otherwise, I would like to clarify and say that it depends on whether you have a need with regards to TDS. As the article states further down, you can just configure IPALL to listen on multiple ports.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 5, 2012 at 4:29 pm
SQLRNNR (4/5/2012)
opc.three (4/5/2012)
SQLRNNR (4/5/2012)
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through the process of creating a new end point.
Yes, you should create the new endpoint.
Advantages of two separate endpoints versus one listening on two ports?
The article the OP referenced talks about TDS (tabular data stream) and it could be beneficial there. Otherwise, I would like to clarify and say that it depends on whether you have a need with regards to TDS. As the article states further down, you can just configure IPALL to listen on multiple ports.
Thanks for the response. I went straight to TCP TDS endpoints (maybe jumped too fast) based on separate mentions of IPALL and TCP port.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 6, 2012 at 2:03 am
opc.three (4/5/2012)
I suspect it will work in SQL 2008+, but have not tried it.
It's commonly used on hardware based NUMA systems 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2012 at 7:27 am
Perry Whittle (4/6/2012)
opc.three (4/5/2012)
I suspect it will work in SQL 2008+, but have not tried it.It's commonly used on hardware based NUMA systems 😉
Sure, configuring additional endpoints is common when using NUMA. My comment related to how to get one endpoint to listen on multiple ports, the OPs original query. That I have not tried on 2008+, but the documentation supports it, so I suspect it will work.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 6, 2012 at 8:12 am
opc.three (4/6/2012)
Sure, configuring additional endpoints is common when using NUMA.
No, commonly you would just simply add different port assignments to the TCP\IP address to target database conections to certain NUMA nodes. You go a step further by configuring multiple TCP\IP addresses\endpoints and ports.
opc.three (4/6/2012)
My comment related to how to get one endpoint to listen on multiple ports, the OPs original query. That I have not tried on 2008+, but the documentation supports it, so I suspect it will work.
That's what I was targeting, one IP multiple ports for targeting connections to specific NUMA nodes. Works just as you'd expect 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2012 at 9:11 am
Perry Whittle (4/6/2012)
opc.three (4/6/2012)
Sure, configuring additional endpoints is common when using NUMA.No, commonly you would just simply add different port assignments to the TCP\IP address to target database conections to certain NUMA nodes. You go a step further by configuring multiple TCP\IP addresses\endpoints and ports.
Thanks for sharing your experience. You are correct, as well, so I am not sure what we're discussing here. My statement still stands.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 7, 2012 at 3:31 am
Minnesota - Viking (4/5/2012)
My question is wont JUST adding the new port number in IPALL filed will suffice ? Why do I have to go through creating a new end point.
You don't have to create the new endpoint. If all you're doing is modifying the system endpoint to listen across more ports then just use SQL server configuration manger and supply a comma delimited list of TCP ports 😉
Remember to ensure that any local or perimeter firewalls have the appropriate hole punched in them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply