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?”

Habilidades: Microsoft Azure, Microsoft SQL Server , System Administration, Administração de Bancos de Dados, Database Management

Sobre o Cliente:
( 28 comentários ) Blackduck, United States

ID do Projeto: #34282366

21 freelancers estão ofertando em média $482 nesse trabalho

(66 Comentários)
(21 Comentários)
(11 Comentários)
(6 Comentários)

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 Mais

$250 USD in 3 dias
(9 Comentários)
(2 Comentários)

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 Mais

$750 USD in 4 dias
(1 Comentário)
(3 Comentários)
(1 Comentário)
(1 Comentário)

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 Mais

$250 USD em 1 dia
(1 Comentário)

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 Mais

$250 USD em 1 dia
(0 Comentários)

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 Mais

$250 USD in 2 dias
(0 Comentários)
(0 Comentários)

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 Mais

$500 USD in 7 dias
(0 Comentários)

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 Mais

$251 USD in 7 dias
(0 Comentários)

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 Mais

$425 USD in 4 dias
(0 Comentários)
(0 Comentários)
(0 Comentários)

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

$250 USD in 7 dias
(0 Comentários)