SQL Azure的性能分析 [英] SQL Azure Profiling
问题描述
我读上SQL Azure不支持SQL事件探查器MS网站。什么是使用的人来分析这个平台上运行的查询？
I read on the MS site that SQL Azure does not support SQL Profiler. What are people using to profile queries running on this platform?
推荐答案
我没有得到太远与SQL Azure的玩弄迄今为止，但是从我的理解没有什么可以此刻使用。
I haven't got too far playing around with SQL Azure as yet, but from what I understand there isn't anything you can use at the moment.
<一个href=\"https://azure.microsoft.com/en-us/documentation/articles/sql-database-technical-overview/\">From MS （可能你的文章读）：
From MS (probably the article you read):
由于SQL Azure的执行
物理管理，任何
语句和选项试图
直接操纵物理资源
会被阻止，如资源
省长，文件组引用，
一些物理服务器DDL语句。
它也无法设置服务器
选项和SQL跟踪标志，或者使用
SQL Server事件探查器或数据库
优化顾问事业。
Because SQL Azure performs the physical administration, any statements and options that attempt to directly manipulate physical resources will be blocked, such as Resource Governor, file group references, and some physical server DDL statements. It is also not possible to set server options and SQL trace flags or use the SQL Server Profiler or the Database Tuning Advisor utilities.
如果有是一个alernative，我想这将需要的能力来设置跟踪标志，你不能这样做，因此我不认为这是目前的一个选项。
If there were to be an alernative, I'd imagine it would require the ability to set trace flags which you can't do, hence I don't think there is an option at the moment.
解决方案？我只能建议你有分贝的地方发展副本，以便您可以在其上本地运行探查。我知道，不会与活的问题/调试/监控帮助，但它取决于你需要什么。
Solution? I can only suggest you have a local development copy of the db so you can run profiler locally on it. I know that won't help with "live" issues/debugging/monitoring but it depends on what you need it for.
编辑：
从报价<一个href=\"http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/6514c399-079d-451b-ae2d-59763c8cfb54\">MSDN论坛：
问：SQL事件探查器支持SQL
Azure的？
Q: Is SQL Profiler supported in SQL Azure?
答：我们不支持SQL事件探查器中
V1 SQL Azure中的。
A: We do not support SQL Profiler in v1 of SQL Azure.
现在，你可以跨preT，作为一个暗示，探查器将在未来的版本支持。我认为这将是一个很大的要求，得到了很多人在船上，使用SQL Azure的重视。
Now, you could interpret that as a hint that Profiler will be supported in future versions. I think it will be a big requirement to get a lot of people on board, using SQL Azure seriously.
这篇关于SQL Azure的性能分析的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
