Re: SQL Server seems not to use processor enough

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 08:42:16 -0400

Do all of these servers have the same processor scheduling for applications
vs. background services?

How about the settings within SQL Server itself, how many processors is it
set to use, max worker threads, boost SQL Server priority, use NT fibers,
etc? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Ferenc Szidarovszky" <ferenc.szidarovszky@szidarovszky.com> wrote in
message news:2079801c459e3$60429100$a601280a@phx.gbl...
> We had some performance problems with one of our systems,
> and our investigation came to the following.
>
> We created a stored procedure:
> create procedure xxx as
> begin
>   declare @i integer
>   set @i = 0
>   while @i < 100000000
>   begin
>     set @i = @i + 1
>   end
> end
> go
>
> Executing this procedure on several different computers we
> mostly get <20% worth of processor usage, but on some we
> get 100%.
> Also, the latter finishes much faster (the ratio of times
> is about in conjuction with the ratio of processor usage).
>
> Notes:
> ------
> The term "worth of processor usage" means one processor.
> So <20% worth of processor usage means <20% on a one-
> processor and <5% on a four processor machine.
> We measured processor usage with task manager.
> We tested this behaviour on different versions and
> releases of SQL Server with same results.
> The operating systems were all versions of Windows 2000.
>

Relevant Pages

  • Re: How to crack encrypted store procedure in SQL 2005?
    ... If it is worth $79.95 to someone: http://www.devlib.net/decryptsql.htm ... And then there is this from the August 2007 SQL Server Magazine: ... application that uses a lot of stored procedures in SQL 2005 that I must ... protect the source codes in store procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: How to crack encrypted store procedure in SQL 2005?
    ... If it is worth $79.95 to someone: http://www.devlib.net/decryptsql.htm ... And then there is this from the August 2007 SQL Server Magazine: ... application that uses a lot of stored procedures in SQL 2005 that I must ... protect the source codes in store procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: Where/how are the documents stored
    ... So in a corp environment it's not worth doing unless you are running ... using either SQL Server or WMSDE which is just cut-down/restricted (and ... > MS-SQL. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Ridiculously simple question from a SQL Developer
    ... I'm a SQL Server 2000/2005 developer and I want to teach myself C#. ... other features introduced in 3.5 but it will serve the purpose ... I'm sure it's worth it. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Access backend database speed issues with DRW
    ... > is it worth having SQL server for a table with 60 records? ... It's not a matter of how many records you're fetching that would determine ... A database server such as SQL ...
    (microsoft.public.frontpage.client)