Hi, Maybe here I will find an answer for my question. For some tests I need to create a query or set of queries which overloads my test machine which is quite powerful, two 6 cores CPUs and 50GB RAM. I was trying to create multiple joins, aggregates, UDFs but nothing is able to make the CPUs suffering. Also linked servers usage which influenced CPU greater degree than previous combinations haven’t even loaded CPU till 50%. Do you think it’s it possible to overload CPUs on such powerful machine? Do you know some tips to create really heavy query which can kill machine? Thanks in advance!
Thanks for ideas! I was able to successfully overload my machine up to 100% CPU by using combination of your advice (used A.Mechanic tool) and query which I got from Sergiy on SSC forum: SELECT * INTO #columns FROM sys.columns AS C DECLARE @RCNT int SET @RCNT = 0 SET NOCOUNT ON; WHILE @RCNT = 0 BEGIN UPDATE #columns SET column_id = 0 WHERE ISNUMERIC(CONVERT(float, CONVERT(nvarchar(20), CONVERT(varchar(20), column_id)))) = 0 SELECT @RCNT = @@ROWCOUNT END The query was added to the procedure which I ran by SQLQueryStress tool in 40 threads.