Otdfbt

Why does the hash of infinity have the digits of π?

Count Even Digits In Number

A steel cutting sword?

The roles understanding in the agile development / Is the PO always right?

Construct a word ladder

Make 24 using exactly three 3s

Count rotary dial pulses in a phone number (including letters)

What are the meaning and grammar of "Crying isn't like you"?

Adding edges to a TreeForm of an expression

Is it rude to call a professor by their last name with no prefix in a non-academic setting?

Can the Grave cleric's Sentinel at Death's Door feature turn a critical hit into a miss, while adamantine armor does not?

My employer faked my resume to acquire projects

Is there an online tool which supports shared writing?

NIntegrate doesn't evaluate

Is it truly impossible to tell what a CPU is doing?

Open office space - complaints for noise - how to respond

Pirate democracy at its finest

Do photons bend spacetime or not?

Why did the person in charge of a principality not just declare themself king?

Do I need full recovery mode when I have multiple daily backup?

Website returning plaintext password

Can I tell a prospective employee that everyone in the team is leaving?

First Match - awk

Is Jon Snow the last of his House?

Linux SQL Server on OpenVZ Linux Instance

Which virtualization platforms should I choose, Xen or OpenVZ?install and config openVZError when trying to open SQL Maintenance Plan - SSMS 2008Updating modules on VPS hosted under OpenVZUnable to connect to SQL Server 2012 Enterprise local instanceTrying to connect to a SQL Server 2000 instance via SSMS 2012SQL Server 2017 on Linux in script upgrade mode after updateConfigure SSRS remotely - A connection to the computer cannot be establishedSQL Server Ubuntu 16.04 - “Nothing” works (It always hangs)Blue question mark on SQL server and SQL server agent?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I've tried to install Linux SQL Server on 3 completely different VPS. 2 Running Centos 7 and one Ubuntu. All of them run on an OpenVZ Virtualization environment.

To install SQL Server I follwed this guide:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017

After installing and configuring the password the server starts normally, but when I try to do Queries, using SQLCMD or event try to connect using SSMS from a remote machine, the server hangs, starts using a lot of CPU and nothing happens. Also when I try to Stop the server nothing happens, I have to use "Kill -9" to stop all its process.

I did the same on a different VPS running also Centos 7 but using KVM virtualization, and it worked without a problem.

I was just wondering is someone has seen this behavior before or know if the OpenVZ is the problem.

I have look all the logs, and there is nothing that could explain this.
The only common ground of those 3 servers is the OpenVZ or maybe Im missing something else.

Any help will be much appreciated.

Best Regards

sql-server kvm-virtualization openvz

share|improve this question

asked May 11 at 20:17

tomcontrtomcontr

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I wouldn't use OpenVZ. It won't be able to keep up with the demands of SQL Server, or many other modern applications.
  
  – Michael Hampton♦
  May 11 at 21:14
  

  
  
  
  

add a comment | 

0

I've tried to install Linux SQL Server on 3 completely different VPS. 2 Running Centos 7 and one Ubuntu. All of them run on an OpenVZ Virtualization environment.

To install SQL Server I follwed this guide:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017

After installing and configuring the password the server starts normally, but when I try to do Queries, using SQLCMD or event try to connect using SSMS from a remote machine, the server hangs, starts using a lot of CPU and nothing happens. Also when I try to Stop the server nothing happens, I have to use "Kill -9" to stop all its process.

I did the same on a different VPS running also Centos 7 but using KVM virtualization, and it worked without a problem.

I was just wondering is someone has seen this behavior before or know if the OpenVZ is the problem.

I have look all the logs, and there is nothing that could explain this.
The only common ground of those 3 servers is the OpenVZ or maybe Im missing something else.

Any help will be much appreciated.

Best Regards

sql-server kvm-virtualization openvz

share|improve this question

asked May 11 at 20:17

tomcontrtomcontr

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I wouldn't use OpenVZ. It won't be able to keep up with the demands of SQL Server, or many other modern applications.
  
  – Michael Hampton♦
  May 11 at 21:14
  

  
  
  
  

add a comment | 

I've tried to install Linux SQL Server on 3 completely different VPS. 2 Running Centos 7 and one Ubuntu. All of them run on an OpenVZ Virtualization environment.

To install SQL Server I follwed this guide:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-ubuntu?view=sql-server-linux-2017

After installing and configuring the password the server starts normally, but when I try to do Queries, using SQLCMD or event try to connect using SSMS from a remote machine, the server hangs, starts using a lot of CPU and nothing happens. Also when I try to Stop the server nothing happens, I have to use "Kill -9" to stop all its process.

I did the same on a different VPS running also Centos 7 but using KVM virtualization, and it worked without a problem.

I was just wondering is someone has seen this behavior before or know if the OpenVZ is the problem.

I have look all the logs, and there is nothing that could explain this.
The only common ground of those 3 servers is the OpenVZ or maybe Im missing something else.

Any help will be much appreciated.

Best Regards

sql-server kvm-virtualization openvz

share|improve this question

asked May 11 at 20:17

tomcontrtomcontr

1

share|improve this question

asked May 11 at 20:17

tomcontrtomcontr

1

share|improve this question

asked May 11 at 20:17

tomcontrtomcontr

1

asked May 11 at 20:17

tomcontrtomcontr

1

asked May 11 at 20:17

tomcontrtomcontr

1