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
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......
留言