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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-09 : 13:46:48
|
D.A.Kuzmichev writes "While we perform query like this
set nocount on
Declare @I int
select @I=0
while @I < 100000
begin
select @I=@I+1
end
set nocount off
we can see 100% cpu usage on client side.
When we put this query into stored proc we does not
see it. This behavior decreases performance.
Please, explain to us.
We performed query in Enterprise Manager.
SQL Server 6.5.
Thank you." |
|
|
|
|
|
100% CPU usage on client side while performing query