Disk I/O Perfomace issue

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

  1. what database/tables are getting more disk write

  2. What Process and SQL is used for disk write

  3. Is there any optimization technique you know that we have ti put in C#

  4. 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.

more ▼

asked Mar 06, 2017 at 12:35 PM in Default

avatar image

11 3

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 06, 2017 at 12:35 PM

Seen: 44 times

Last Updated: Mar 06, 2017 at 02:42 PM

Copyright 2018 Redgate Software. Privacy Policy