I have to learn more about system design...

https://github.com/kevingo/system-design-primer-zh-tw

留言

張貼留言

這個網誌中的熱門文章

Configure Application Insights on Windows Server of Azure Virtual Machine

圖片
According to these references, we can get telemetry data from virtual machine by these steps: Install Application Insights Status Monitor on Windows Server (VM). Update it to latest version. Run 'lusrmgr.msc' and add the IIS AppPool account(s) into 'Performance Monitor Users' group. Reset IIS. Reference: Instrument web apps at runtime with Application Insights Reference: Application insight monitor doesn't send data to portal due to insufficient permission
閱讀完整內容

Minimize MS-SQL table deadlocks

There are two SPs perform complicated commands on the same table in our product. Our DBA said he didn't know how to reduce the deadlocks. After Google the key word 'minimizing deadlocks', I found this official document: Key-Range Locking According to above document and this  example , if I select data rows by parameter on non-unique index and then perform some operations, I will only lock these rows. Need some tests......
閱讀完整內容