{"action":"opened","issue":{"url":"https://api.github.com/repos/jimliu7434/Diary/issues/7","repository_url":"https://api.github.com/repos/jimliu7434/Diary","labels_url":"https://api.github.com/repos/jimliu7434/Diary/issues/7/labels{/name}","comments_url":"https://api.github.com/repos/jimliu7434/Diary/issues/7/comments","events_url":"https://api.github.com/repos/jimliu7434/Diary/issues/7/events","html_url":"https://github.com/jimliu7434/Diary/issues/7","id":254917515,"number":7,"title":"SQL Server 2017  (on linux)","user":{"login":"jimliu7434","id":16040059,"avatar_url":"https://avatars2.githubusercontent.com/u/16040059?v=4","gravatar_id":"","url":"https://api.github.com/users/jimliu7434","html_url":"https://github.com/jimliu7434","followers_url":"https://api.github.com/users/jimliu7434/followers","following_url":"https://api.github.com/users/jimliu7434/following{/other_user}","gists_url":"https://api.github.com/users/jimliu7434/gists{/gist_id}","starred_url":"https://api.github.com/users/jimliu7434/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimliu7434/subscriptions","organizations_url":"https://api.github.com/users/jimliu7434/orgs","repos_url":"https://api.github.com/users/jimliu7434/repos","events_url":"https://api.github.com/users/jimliu7434/events{/privacy}","received_events_url":"https://api.github.com/users/jimliu7434/received_events","type":"User","site_admin":false},"labels":[{"id":569629506,"url":"https://api.github.com/repos/jimliu7434/Diary/labels/backend","name":"backend","color":"84b6eb","default":false},{"id":682800201,"url":"https://api.github.com/repos/jimliu7434/Diary/labels/SQL","name":"SQL","color":"b60205","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-09-04T01:54:45Z","updated_at":"2017-09-04T01:54:45Z","closed_at":null,"author_association":"OWNER","body":"# sql server 2017 \r\n\r\n## on linux & on windows 效能差異\r\n\r\nHammerDB : 測試 DB 效能\r\n\r\n測試時需要安裝 db client 才能有可使用的 driver\r\n\r\nODBC SQL Server Driver 版本須注意\r\n\r\nazure : \r\n\r\n    亞洲   windows   15k~16k  TPM (Transaction / minute)\r\n    美國   windows   18k~19k  TPM\r\n    亞洲   linux     15k~16k  TPM\r\n    美國   linux     60kup    TPM\r\n\r\n最低支援 Centos 7.3 \r\n\r\n\r\nlinux 測試硬體效能 *mpstat* \r\n\r\nSQL Server Agent on linux 需另外安裝 \r\n\r\n安裝有問題時,可以暫時 disable  SELinux\r\n\r\n進階功能：\r\n\r\n    Cluster      OK\r\n    Log Shipping OK\r\n    Always On    OK\r\n    Replication  NOT Ok"}}
{"actor":{"display_login":"jimliu7434"}}