Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions. Let me answer the questions here today.
Get CPU Details – SQL in Sixty Seconds #164
Q: What is the right number of the MAXDOP for my machine?
A: There is no right answer to this, however, if your workload is a transaction, I suggest you keep it in lower single digits.
Q: If I increase the CPU in my machine, will I get more performance?
A: If you are running out of threads, increasing CPU may help but if your MAXDOP is incorrect, you may get poor performance as you increase the CPU.
Q: Will higher clock speed improve query performance?
A: It may or it may not. I personally do not recommend this practice in my Comprehensive Database Performance Health Check.
Shutdown SQL Server Via T-SQL – SQL in Sixty Seconds #163
Q: Is Shutdown better than stopping service?
A: Ultimately both return us the same result. However, command Shutdown waits for all the processes to complete before it shut down the server.
Q: Can I start the server from T-SQL?
A: No, it is not possible to start or restart the server from T-SQL as it only works if SQL Server is up and running.
Q: What do Shutdown do behind the scene?
A: It does three things before stopping SQL Server services 1) Disables logins 2) Wait for processes to complete 3) Performing Checkpoint for every database.
SQL Server on Linux – SQL in Sixty Seconds #162
Q: Is Linux better than Windows for SQL Server?
A: I can’t say this one. While Linux is easy to manage, I have seen a similar performance on both machines.
Q: When I upgrade my Linux SQL Server what will happen to my data and log files?
A: They will be just there fine, just like windows SQL Server update, the only application is updated in Linux.
Q: Can I install SQL Server on Docker?
A: Yes, you can do that too. Here is my previous blog post on the topic:
- SQL SERVER – How to Get Started with Docker Containers with Latest SQL Server?
- SQL SERVER – Docker Volume and Persistent Storage
- Docker – Running SQL Server Image Without Running Pull Command
Please leave a comment and let us know what you think of this blog post on CPU, Linux, and Shutdown.
Reference: Pinal Dave (http://blog.SQLAuthority.com)