SharePoint 2013 Reporting Services服务应用程序 [英] SharePoint 2013 Reporting Services Service Application
问题描述
是否建议查询由SharePoint Reporting Services服务应用程序创建的数据库?
Is it recommended to query database created by SharePoint Reporting Services Service application?
也请让我知道如果有人查询该数据库，我们将看到哪些复杂问题.
Also please let me know what are the complications we will see if someone queries that database.
谢谢
Praveen
Sharepoint帮助
Sharepoint HELP
推荐答案
您好，pravyn
Hi pravyn,
直接查询SharePoint数据库被认为是不行，您应该改用SharePoint对象模型或Web服务.
Direct Queries to SharePoint databases is considered a no-no, you should use SharePoint object model or web services instead.
- 您在安装SharePoint时同意的EULA完全不支持此功能.
- 由于Microsoft可以随时更改数据库架构，因此不能保证将任何修补程序或Service Pack应用于SharePoint后您的查询都能正常工作.
- 直接查询数据库可能会对服务器造成额外的负担，从而导致性能问题.
- 针对数据库的直接
SELECT语句在默认事务级别获得共享的读取锁，因此您的自定义查询可能会导致死锁，从而导致稳定性问题. - 您的自定义查询可能会导致检索到不正确的数据.
- This is completely unsupported by the EULA you agreed to when you installed SharePoint.
- Your queries are not guaranteed to work after applying any patches or service packs to SharePoint since Microsoft could change the database schema anytime.
- Directly querying the database can place extra load on a server and hence performance issues.
- Direct
SELECTstatements against the database take shared read locks at the default transaction level so your custom queries might cause deadlocks and hence stability issues. - Your custom queries might lead to incorrect data being retrieved.
请参阅以下有关不直接查询SharePoint数据库的原因的文章:
Refer to the following article about Reasons not to directly query SharePoint Databases:
https://www.codeproject.com/Articles /42787/无法直接查询SharePoint数据的五个原因
最好的问候
Lisa Chen
Lisa Chen
这篇关于SharePoint 2013 Reporting Services服务应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
