xEonBuRn Posted July 25, 2004 Share Posted July 25, 2004 Is there a way to change the listening port on Microsoft SQL server? Link to comment Share on other sites More sharing options...
0 prof_stig Posted July 26, 2004 Share Posted July 26, 2004 How to use static and dynamic port allocation in SQL Server 2000 Good explanation of the entire process. Don't forget to configure any clients you have. hope this helps Link to comment Share on other sites More sharing options...
0 Ultra Frosty Posted July 26, 2004 Share Posted July 26, 2004 While on the topic of MS SQL Server: When I installed MS SQL Server Express Beta 1 I noticed it used 50MB of RAM. Is this normal or was it a leak ? Ill download Beta 2 and see if it is still using 50MB, cause otherwise I will use MySQL, Link to comment Share on other sites More sharing options...
0 Sn1p3t Posted July 26, 2004 Share Posted July 26, 2004 While on the topic of MS SQL Server: When I installed MS SQL Server Express Beta 1 I noticed it used 50MB of RAM. Is this normal or was it a leak ?Ill download Beta 2 and see if it is still using 50MB, cause otherwise I will use MySQL, I'm thinking this may be because of the .NET integration. Before you get all angry at .NET, read: When you run an application that uses the .NET framework, it allocates a large portion of memory to that application. That memory is optimized and managed for better performance. However, if you start running out of memory for other applications, it will reduce it's managed memory allocation as far as it needs to. Therefore, the fact that it's using 50MB just goes to show you don't even need the memory, and shouldn't be worrying :D Link to comment Share on other sites More sharing options...
0 Ultra Frosty Posted July 26, 2004 Share Posted July 26, 2004 (edited) Well, I have no choice. Edited July 26, 2004 by b0b Link to comment Share on other sites More sharing options...
0 Sn1p3t Posted July 26, 2004 Share Posted July 26, 2004 Well, I have no choice. Try running the server and looking at it's memory usage. Then try running a game, or severl instances of Word, or SOMETHING that would take a large amount of RAM (how much do you have). Notice how SQL Server Yukon's memory usage goes down as you reach your maximum physical memory. Link to comment Share on other sites More sharing options...
0 Ultra Frosty Posted July 26, 2004 Share Posted July 26, 2004 I'm having some tech difficulties installing Beta 2. How do I make a .mdf file ? Link to comment Share on other sites More sharing options...
Question
xEonBuRn
Is there a way to change the listening port on Microsoft SQL server?
Link to comment
Share on other sites
6 answers to this question
Recommended Posts