Select with numeric conditions in the where part

[Cowboy \(Gregory A. Beamer\)]

Try this:
[url]http://www.winnetmag.com/Articles/Index.cfm?ArticleID=21365[/url]

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think Outside the Box!
************************************************** **************************
****
"Luigi Nizzi" <Luigi.nizzi@np.ge.com> wrote in message
news:078001c349f3$425dccf0$a101280a@phx.gbl...

> System:
> Windows: 2000 SP3
> IIS5.0
>
> We have a performance issue when we run a simple query
> with numeric field in the where part:
>
>
>
> We do not have the same problem in NT server (IIS 4.0) or
> using personal Web server (Windows 2000)
> :
>
> The query we run several times is:
> SELECT * FROM [fcotepos] WHERE Anno=0 AND Mese=0 AND
> Serial=0
>
> Performance On the Web server:
> Time Query
> [0.08] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> [0.09] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> .
> .
> CPU Utlization only 50% (why it does not use all the CPU
> available ? The other CPU remains idle)
>
> Performance On the Personal Web server:
> Time Query
> [0.01] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> [0.01] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> .
> .
> CPU Utlization 100%
>
> May you help us or give us indications ?
> Thanks
> Luigi
>

[Aaron Bertrand - MVP]

> CPU Utlization only 50% (why it does not use all the CPU

> available ? The other CPU remains idle)
>
> Performance On the Personal Web server:
> Time Query
> [0.01] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> [0.01] ### SELECT * FROM [fcotepos] WHERE Anno=0 AND
> Mese=0 AND Serial=0
> .
> .
> CPU Utlization 100%

(1) are the same indexes employed in both servers?

(2) does one of the servers only have 1 cpu allocated to SQL Server?