Re: SQL 2005 Performance

Agreed.

Let me ask a generic question - has anybody seen the situation OP describes,
where CPU is the limiting resource for an OLTP system, anytime in the last
few years, with multiple-core multiple-gigahertz processors? I think it is
very likely he does have a problem, maybe some datatype conversions that
force bad plans.

Actually, we had a complaint at my current gig about 70% CPU utilization at
a particular hour every day, and traced it to workload - some big ETL jobs
were running at a particular time of day, but that was not really OLTP load.

(and yes, we can probably optimize the ETL code, but it's a serious mess
several thousand lines long right now )

Josh


"TheSQLGuru" wrote:

Best advice for such a scenario is to hire a performance tuning professional
to give your system a review. Coupla days ought to be sufficient. You can
learn while he/she evaluates the system too. Tuning is a VERY wide and deep
topic. It is very difficult to hunt-and-peck to an optimal system via a
news group! :-)

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


"Toni" <teibner@allinadotcom> wrote in message
news:%23JX3V3e3JHA.676@xxxxxxxxxxxxxxxxxxxxxxx
I've got a sql 2005 build 3282 cluster with 4 - 3.4Ghz Dual Core
Processors with 20gb RAM (15gb allocated to sql) that has been running
at 90-100% cpu all day every day since the beginning of the month at
least. It looks like it is all sql.

I can see that I have 1 database in particular that pushes through a
high number of transactions all the time. Watching it through PerfMon,
the highest I've seen transactions\sec so far has been 2188.439 just for
this one database. I've got 141 databases on this server.

I've run profile traces and at first glance, it appears the sql
statements are using indexes -- not running table scans.

How can I tell if it is time to move this database to a server of its
own? Is there something I can do on the existing server to improve
performance?

I apologize for being rather vague but I don't know what to start
looking at to improve things.
I'd appreciate any suggestions.

Thanks,

Toni

Toni

*** Sent via Developersdex http://www.developersdex.com ***



.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
Loading