Hi Biju,

Try this:

USE msdb
go
select object_name(id),[name],indid,reserved from sysindexes order by
reserved desc

This will give you information on which table uses the most space;then you
can check into it maybe a service,or something else.

Rgds,
Serge

-----Message d'origine-----
De : Biju.K [mailto:mysqldba-ezmlmshield-x61962274.[Email address protected]
Envoyé : mardi 21 août 2007 19:04
À : LazyDBA Discussion
Objet : CPU utilization

Hi Gurus,

One of my SQL server CPU utilization off late shows 90 to
100% sometimes . What is the best way to identify which database(application
queries) causes this. No dead locks created in these cases. Around 400 users
using various web based application to access this SQL server. Given below
the configuration of the server. Below given the server details. Do you
think the server with this configuration can handle only this much? .
Another thing in this server, the msdb database size 2.5Gb and some
databases of size 3GB.



Server - Windows 2000 Advanced Server Service Pack 4 (build 2195)



IBM 2.50 gigahertz Intel Xeon MP (2 installed)



3872 Megabytes Installed Memory



367.03 Gigabytes Usable Hard Drive Capacity



119.92 Gigabytes Hard Drive Free Space





Thanks for your help in advance.



Biju.K



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mysqldba-[Email address protected]
Website : http://www.LazyDBA.com

MySQL LazyDBA home page