cpu & memory usage on large, long-running query

Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
LoaneIf you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:

>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.
4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
>