我怎样才能得到一些不好的查询来测试DWH的负载? [英] How can i get some bad running queries to test the load on DWH ?

问题描述

我想基于CPU利用率实现DWH的自动缩放
为此，我需要一些示例，这些示例运行得很糟糕，这些查询可以通过自动启用缩放功能来增加CPU的负载.
请帮助我在哪里可以得到它们

谢谢
Surya

Hi,
I want to implement the auto scale of DWH based on CPU utilization
For that , i need some sample really bad running queries which can increase the load on the CPU there by enabling the scaling automatically.
Please help me on where can i get them

Thanks,
Surya

推荐答案

您好Surya，

Hi Surya,

此

This Stack Overflow forum post has some good ideas. These are SQL Server specific, so some modification might be needed. Perhaps the community has some additional ideas. ~Mike

这篇关于我怎样才能得到一些不好的查询来测试DWH的负载?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！