| Author |
Topic |
|
DeepSeed
Yak Posting Veteran
52 Posts |
 Posted - 2010-01-11 : 12:02:42
|
| Hello, I would like to have my SQL 2008 instance listening on at least 7 different ports. When I type different ports into the IP Addresses TCP Port fields (within Configuration Manager) and restart the service it stops listening on any ports. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 12:15:20
|
I can put a soft-NUMA node on each port. For example 1433[1],1434[2],1435[4],1436 , etc. I have up to 3 ports open but when I try to add more they dont open in standard edition. It works in development edition but I cant install dev on customer environment. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-12 : 12:23:26
|
| Well you can use Enterprise Edition in place of Developer Edition, of course licensing costs will be higher.Are you doing this configuration for performance reasons? We only use one static port and have about 3000 queries happening per second on our system and have no need for the configuration you are proposing.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 12:36:33
|
| Really wow. Well we have a Dual Proc 8 Core E5520 server and one user can max it out by running a single report in our program and we have 1000's of users and mutliple clients. So what we want to make sure happens is that while this user is running this report they do not effect performance of the other clients. It is ok that their report takes longer only running on 2 cores as it is a report, we just don't want other clients applications taking longer to do simple things like logging in. |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 12:38:39
|
| Is 3 really the max ports for Standard Edition? Thats insanity. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-12 : 12:50:46
|
| We run reports only in a reporting environment. Transactional replication is the preferred method for keeping the reporting environment current. Our system has 16 CPUs (4 quad-core sockets) and 64GB of memory. The database is about 1 terabyte. We split up the database into 21 data files that span 7 mount points and 7 RAID controllers. Our performance requirement is for 99% of queries to complete in 300 milliseconds or less. I don't know what the max ports is for Standard edition, but I would assume 3 due to your testing.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 13:34:03
|
| Unfortunatly many of those configurations are handled by development which our team is working on, though they just started working on performance development where everything has been feature development in the past. My job is to try and reduce the performance problems with hardware until we can improve in development. There is no way we can afford Enterprise Edition, they are asking 1800/mo/proc through SPLA. I don't see how anyone could afford that. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-12 : 13:45:39
|
| We host our own SQL Server environments, so we don't have monthly licensing costs. For the system mentioned above, we are using Enterprise Edition with CPU-licensing so we purchased 4 licenses (one-time cost with software assurance). That is a large chunk of change, but our applications earn revenue. We actually use Enterprise Edition on all of our systems since they are external facing, revenue earning, have high availability requirements, and are mission critical to our customers. Standard Edition doesn't allow online index rebuilds, which would cause us huge performance problems during the maintenance jobs since our systems are 24x7.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 14:05:09
|
| I do not see any restrictions on ports according to Microsoft. Their article just says all versions are the same. Not sure why it will not open up more than 3 ports. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 14:15:05
|
| Do you know where there is so many areas to enter the ports? SHould I just use the IPAll area? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 14:51:37
|
| So I found that if I take the brakets out of the ports it opens as many as I want. But when I try to do something like 1433[1],1435[2],1436[4],1437 it only opens the first 2 or 3 ports. |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 16:26:53
|
| I guess its cuz I only have 2 nodes, it says right on the Microsoft article you can create as many Soft-NUMA nodes as you want, I wish they would say how, there is no solutions when you search create more soft numa nodes on google. |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 16:41:10
|
| Wow, every freaking blog in the world all says the same thing. you can also use soft-NUMA to subdivide hardware NUMA nodes into smaller groups. And then they all point you to this useless article that does not tell you how to do a single thing, it just talks about what you could do if you ever knew how.http://msdn.microsoft.com/en-us/library/ms178144.aspxI guess you have to pay microsoft to find out how to do it. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-12 : 19:14:08
|
| Ok Ill try that, thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-13 : 12:38:43
|
| Seems to me that you're cutting off your leg because your toe hurts.Also, wheree did you get the idea that 3 is the max? I don't think thats right. |
|
|
|
DeepSeed
Yak Posting Veteran
52 Posts |
Posted - 2010-01-13 : 14:34:42
|
| I found that that is incorrect. It is not opening the ports because I am running out of Nodes. now I know what I need. I need to subdivide the hardware NUMA nodes (I have 2 of them) into more soft-NUMA nodes, so that I can open more ports. I need to specify a distinct node for each port I want to open for this to be successful.Here is my latest post, so far not going anywhere.http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/9fe83445-2689-4204-9297-eb3a6bc98bc7?prof=required |
|
|
|
|
Listening on multiple ports