绩效计数器 [英] Performance Counters
本文介绍了绩效计数器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
关于动态性能视图，何时在Azure SQL数据库服务上重置性能计数器?
In reference to dynamic performance views, when do the performance counters get reset on Azure SQL Database Service?
预先感谢
推荐答案
Hello,
https://docs.microsoft.com/zh-CN/sql/t-sql/statements/alter-database-scoped-configuration-transact- sql?view = sql-server-2017
You can use ALTER DATABASE SCOPED CONFIGURATION with arguments XTP_PROCEDURE_EXECUTION_STATISTICS and XTP_QUERY_EXECUTION_STATISTICS
to clear DMVs related with store procedures and queries.
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-database-scoped-configuration-transact-sql?view=sql-server-2017
Hope this helps.
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于绩效计数器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
