i've been optimizing our azure sql database , started getting performance. main concern logging does. when running insert/update load test, low except cpu peaking around 15% , logging peaking around 25%. since logging io hitting 25%, causes dtus 25%. turned off auditing in settings database did nothing. there way reduce logging being done? i'm not sure logs being saved.
any insight on i've googled , couldn't locate worth mentioning logging happening.
here screen shot of metrics...
workflow details:
i don't have byte sizes on me i'm not in office atm. every task select , either insert or update, typical add or update flow using entity framework. these tasks fire off , finish @ rate of 63 tasks per second create metrics.
there no impact of auditing based on description of workload. insert / update produces log in order of data insert. couple options can try improve workload efficiency in sql db v12 disable si / rcsi. if records size small saves data io / log , temp db usage. more details @ http://www.sqlindepth.com/row-versioning-in-sql-database-version-v12/ can compress tables io / log can little less is, cpu consumption goes little.
Comments
Post a Comment