Prev: SQL 2005 - SQL Native Client doesn't work, MDAC does
Next: Transaction and resources
From: Archana on 31 Oct 2009 10:31
hi all,

I am facing one problem regarding sql server 2000. Client has reported
that due to some queries cpu utilization on dataase server reches
100. We executed same queries on local environment, but not getting
this problem.
And client is saying that this is not happening always. sometime it is
happening then client has to restart system.

If any one can shed some light on it then it will be really helpful
for me.

thanks in advance.
From: Plamen Ratchev on 31 Oct 2009 11:22
There could be many reasons for that (like using inefficient plans due to parameter sniffing). Best would be to use
server side trace to capture some queries that cause the high CPU utilization and then to analyze the execution plans.

--
Plamen Ratchev
http://www.SQLStudio.com
From: TheSQLGuru on 31 Oct 2009 12:11
Is the data volume the same between the environments? Database and server
settings the same? Physical hardware the same? Indexes the same?
Statistics updated on both boxes? Fragmentation the same?

Those are just the tip of the iceberg of issues that could be at play here.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Archana" <trialproduct2004(a)yahoo.com> wrote in message
news:60b559fe-b6c7-49eb-97b2-f984e6355d98(a)z3g2000prd.googlegroups.com...
> hi all,
>
> I am facing one problem regarding sql server 2000. Client has reported
> that due to some queries cpu utilization on dataase server reches
> 100. We executed same queries on local environment, but not getting
> this problem.
> And client is saying that this is not happening always. sometime it is
> happening then client has to restart system.
>
> If any one can shed some light on it then it will be really helpful
> for me.
>
> thanks in advance.


 | 
Pages: 1
Prev: SQL 2005 - SQL Native Client doesn't work, MDAC does
Next: Transaction and resources