Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kapilratra
Starting Member
2 Posts |
 Posted - 2010-06-02 : 15:11:00
|
| Hi i have to create sql server script that utilises most of the cpu means %cpu utilization is very high in sql server:workloadgroupstatsplease help me out in giving some scripts so that i can test my sql server against cpu bottleneck |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-06-03 : 08:07:29
|
| put a "while loop" in place, doing calculations with no DML/DDL statements.psuedo code begin loop vara = vara + 1 vara = vara - 1 end loop after 1,000,000 iterations, etc |
 |
|
|
|
|
|
cpu bottleneck