One of my clients Azure SQL Databases has recently begun consuming unreasonable amounts of DTU, and we are having difficulty pinpointing a root cause. This database is fairly simple in architecture; the design was reviewed by a group of DBAs who found no concrete inherent design issues. The database ran without issue for over 2 years, consistently using below 25 DTU, before “falling off a cliff”. Inexplicably, it does not matter how much DTU we allocate, whether 100 DTU or 800 DTU, it will consume 100% of the allocation.

The end client would like to bring on a consulting DBA with a specific knowledge of Azure SQL Database and SQL Server, as this issue involves the SQL Server engine and Azure-specific concepts like DTU. We want to have a full understanding of the problem, as this design pattern exists across our systems. Here are a few specific questions that have arisen from research:

• Are there known situations where DTU usage can swing severely without a correlated uptick in usage?

• Are there inherent weaknesses in the Azure SQL Database platform?

• Are there known issues in SQL Server with using GUID data types for non-clustered indexes or foreign key relationships?

• We are seeing notable index fragmentation for the GUID-based indexes (expected); is this possibly the culprit even though it is not a new condition?

• Is there a recommended fill factor for indexes built on GUID columns?”

Kemahiran: Microsoft Azure, Pelayan Microsoft SQL, System Administration, Pentadbiran Pangkalan Data, Database Management

Tentang Klien:
( 28 ulasan ) Blackduck, United States

ID Projek: #34282366

21 pekerja bebas membida secara purata $482 untuk pekerjaan ini

(66 Ulasan)
(21 Ulasan)
(11 Ulasan)
(6 Ulasan)

Hello Sir, I am core SQL Server DBA with 15+years of experience .Managed 1000+ Instances from Azure SQL database Managed Instance ,Single database, Elastic pools , SQL Server on VM 2000-2019 versions ,I am proficient i Lagi

$250 USD dalam 3 hari
(9 Ulasan)
(2 Ulasan)

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the Lagi

$750 USD dalam 4 hari
(1 Ulasan)
(3 Ulasan)
(1 Ulasan)
(1 Ulasan)

Hi, Is there a way you can provide me access to the Azure portal or a screen-share so that I can check the issue. I can complete this task for you within 150$ I have more than 13 years of experience as a SQL Database Lagi

$250 USD dalam sehari
(1 Ulasan)

Greetings, I can assist you with this project related to Azure SQL DBA . I am experienced in Database Management, Database Administration, System Administration, Microsoft SQL Server and Microsoft Azure. I have comple Lagi

$250 USD dalam sehari
(0 Ulasan)

hello I devour your demand that you’re viewing Azure SQL DBA I provide creative, proactive and high-tech solutions to your development needs. I have solid experience in HTML, Javascript, PHP,CSS,metatrader, MySQL, No Lagi

$250 USD dalam 2 hari
(0 Ulasan)
(0 Ulasan)

Hello. I have read your description very carefully and I can complete it perfectly in short time. I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use th Lagi

$500 USD dalam 7 hari
(0 Ulasan)

Guid give out performance by default in ms SQL reached one level of records, that helps little bit with fill factor to 70% I have 15 years experience of large scale web API, Microsoft platform applications development Lagi

$251 USD dalam 7 hari
(0 Ulasan)

Hi, I've read through the description of your project and find it intriguing. I have a few ideas as to what could be the underlying cause and how to go about resolving it. To address your questions, a DTU is an aggreg Lagi

$425 USD dalam 4 hari
(0 Ulasan)
(0 Ulasan)
(0 Ulasan)

i want to part of this project, i do have experience on on premises and Azure sql dba and performance tuning

$250 USD dalam 7 hari
(0 Ulasan)