Prev: SQL Server 2005 and 2008
Next: Big transaction log file
From: RG on 22 Apr 2010 18:05
I am running this really complicated olap query on my workstation (xp 64 bit)
which takes roughly 8 minutes to complete. During execution the cpu
utilization is pushing 100% but oscilates.

When I run the same query against a db containing the same data on windows
server 2003 on a machine which is much more powerfull with scsi hard drives,
it executes forever. The log looks good. However, the cpu utilization is at
rest at 100% and memory is growing over time.

Any troubleshooting suggestions is greately appreciated.

Thanks in advance
From: Uri Dimant on 22 Apr 2010 23:22
RG
Indexes are speed up the queries. Please examinate an execution plan of the
query to se how the optimizer does the job


"RG" <RG(a)discussions.microsoft.com> wrote in message
news:2FA3F488-8562-41F0-9A5A-46D6F01E61C6(a)microsoft.com...
>I am running this really complicated olap query on my workstation (xp 64
>bit)
> which takes roughly 8 minutes to complete. During execution the cpu
> utilization is pushing 100% but oscilates.
>
> When I run the same query against a db containing the same data on windows
> server 2003 on a machine which is much more powerfull with scsi hard
> drives,
> it executes forever. The log looks good. However, the cpu utilization is
> at
> rest at 100% and memory is growing over time.
>
> Any troubleshooting suggestions is greately appreciated.
>
> Thanks in advance


From: Erland Sommarskog on 23 Apr 2010 18:09
RG (RG(a)discussions.microsoft.com) writes:
> I am running this really complicated olap query on my workstation (xp 64
> bit) which takes roughly 8 minutes to complete. During execution the
> cpu utilization is pushing 100% but oscilates.
>
> When I run the same query against a db containing the same data on
> windows server 2003 on a machine which is much more powerfull with scsi
> hard drives, it executes forever. The log looks good. However, the cpu
> utilization is at rest at 100% and memory is growing over time.

Obviously you get different query plans. Since I know nothing about the
queries and the tables it is difficult to say where to begin. But comparing
the plans may inspire to the use of some hints. May MAXDOP, although for
OLAP queries it's usually a win to have a high degree of parallelism.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: SQL Server 2005 and 2008
Next: Big transaction log file