数据库阻塞问题 [英] Database Blocking Issue

问题描述

To
解析数据库查询阻塞问题的程度应该被视为DBA任务还是数据库开发人员任务？ 

---

专业BI开发人员。专业数据库管理员和开发者专业网络工程师专业.NET开发人员专长：MCITP BI开发人员（2005,2008）MCITP SQL Server数据库管理（2005,2008）MCDBA 2000 MCSE / MCSA
2003 /安全/消息传递MCTS数据库开发SQL Server 2005,2008 ，2012

To what extent resolving database queries blocking issue should be considered as DBA tasks or database developer tasks? 

---

professional BI developer. professional database administrator and developer. professional network engineer professional .NET developer Specialties: MCITP BI Developer (2005,2008) MCITP SQL Server Database Administration (2005,2008) MCDBA 2000 MCSE/MCSA 2003/Security/Messaging MCTS Database Development on SQL Server 2005,2008,2012

推荐答案

DBA应该能够对它们进行故障排除，并向数据库开发人员推荐如何最小化它们。

The DBA should be able to troubleshoot them and recommend to the database developer how to minimize them.

在某些情况下，索引可以在DBA任务的位置解决它们。在其他情况下，它将涉及一些重新架构，其中应该为数据库开发人员分配任务。

In some cases indexes can solve them where it is a DBA task. In other cases it will involve some re-architecture where the database developer should be assigned the task.

这篇关于数据库阻塞问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！