SQL Server Always On Availability Group Performance

Posted: April 5, 2018 | Author: | Filed under: Availability Groups, Microsoft SQL Server, Scheduling and Yielding | Tags: , | Leave a comment

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

Posted: March 31, 2018 | Author: | Filed under: Microsoft SQL Server, Microsoft SQL Server Replication, SQL Server on Linux | Tags: , , | Leave a comment

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

Posted: January 28, 2018 | Author: | Filed under: CPU Issues, Linux kernel, Security, Uncategorized | Tags: , , | Leave a comment

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

Updated Linux kernel patches and added HardenedBSD.

CPU Issues and Speculative Execution

Posted: January 22, 2018 | Author: | Filed under: CPU Issues, Linux kernel, Security | Tags: , , | Leave a comment

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

Posted: January 21, 2018 | Author: | Filed under: Debugging, Uncategorized | Tags: | Leave a comment

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

CPU Issues and Speculative Execution

Posted: January 21, 2018 | Author: | Filed under: CPU Issues, Security, Solaris | Tags: , , , , , , , , , , , | Leave a comment

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

Posted: January 11, 2018 | Author: | Filed under: Uncategorized | Leave a comment

A comprehensive blog post on CPU Issues and Speculative Execution:

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

 

← Older Entries