SQL Server Always On Availability Group Performance

See

https://blogs.msdn.microsoft.com/psssql/2018/04/05/lesson-learned-from-an-availability-group-performance-case/?utm_source=dlvr.it&utm_medium=twitter

which references

https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/21/sql-server-2012-alwayson-part-11-performance-aspects-and-performance-monitoring-i/

https://blogs.msdn.microsoft.com/saponsqlserver/2013/04/24/sql-server-2012-alwayson-part-12-performance-aspects-and-performance-monitoring-ii/

https://blogs.msdn.microsoft.com/psssql/2018/04/05/troubleshooting-data-movement-latency-between-synchronous-commit-always-on-availability-groups/

https://blogs.msdn.microsoft.com/psssql/2018/04/05/troubleshooting-sql-server-scheduling-and-yielding/

Advertisements

SQL Server on Linux update

SQL Server on Linux

Since 2017 CU4, the SQL Server Agent is no longer a seperate package.

To enable SQL Server Agent:

either

  • sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true
  • sudo systemctl restart mssql-server

OR

  • During setup export MSSQL_AGENT_ENABLED=’true’

 

Replication Agents on Linux are in preview aka.ms/sqleap

 

  • Replication Agents are packaged in the server package.
  • Replication can be setup across Windows/Linux and use AD Auth
  • Docker support is currently being tested and will come soon.
  • Replication Agents on Linux can be managed via SSMS on Windows and normally tools as mainly done via stored procs
  • Snapshot,Transactional and Merge Replication are supported
  • Publisher,Distribtutor or Subscriber can be on Linux
  • SQLOps Studio can be used to configure snapshot replication via stored procs

 

 


CPU Issues and Speculative Execution

http://smooth1.co.uk/security/CPU_issues.html

Updated Linux kernel patches and added HardenedBSD.


CPU Issues and Speculative Execution

http://smooth1.co.uk/security/CPU_issues.html

added

  • Cloud Providers – Linode,Open Telekom Cloud
  • Hypervisor – QEMU
  • Operating Systems – FreeBSD,OpenBSD,Gentoo,Container Linux (CoreOS)
  • Userland – GCC compiler,WebKit
  • Misc Vendor fixes – Raspberry Pi

 

Updated Linux kernel patches with more information


Windows Process Monitor

Windows Proccess Monitor – https://docs.microsoft.com/en-gb/sysinternals/downloads/procmon


CPU Issues and Speculative Execution

http://smooth1.co.uk/security/CPU_issues.html

added

  • Debian,Fedora
  • LLVM,ZFS,Lustre
  • Oracle Sparc,RISC-V
  • Oracle,Nexenta,Scality,Pure Storage,Wonderware,Rockwell Automation,Synology,F5,Qubes,Qubes,Fortinet,Netap

Updated Google cloud section to mention Retpoline a compile time fix for Variant 2 (part of  Spectre) with “almost no performance loss.”


CPU Issues and Speculative Execution

A comprehensive blog post on CPU Issues and Speculative Execution:

http://smooth1.co.uk/security/CPU_issues.html