Hi, There huge disk i/o and processor utilization in my SQL Server Azure instance. Disk Write is 50GB for a single day, but know it should be hardly 100mb. Data is getting inserted using c# code(which i dont have control of :-( ).
Is there way to find
what database/tables are getting more disk write
What Process and SQL is used for disk write
Is there any optimization technique you know that we have ti put in C#
If there was a blocked transaction than how to find it later. since i will not be able to find it in real time as it can happen anytime of the day.
Database is responding very slow because of this.
Anything else you think which could be helpful for me.
Mar 06, 2017 at 12:35 PM