Re: SQL 2000 90% CPU util, help!
Tech-Archive recommends: Fix windows errors by optimizing your registry
Eric wrote:
I've got a clustered SQL 2000 SP3 database that is killing the CPU on our
server. The db is 66% fragmented, and I need to figure out what is taking up
all the CPU cycles. The application that uses the db has recently switched
to JDBC driver. I've tried running SQL profiler and I dont see any large
usage in the CPU column. Is there any other way to find out what is causing
the problem. Thanks!
Is the application using prepared statements to do queries, and using
string parameters to set search arguments for varchar columns?
Joe Weinstein at BEA Systems
.
Relevant Pages
- Re: games are going 2fps every 5 secs
... Watch the CPU column while a game is running to see what's ... stealing your CPU cycles. ...
(alt.comp.hardware.pc-homebuilt) - Re: large binary immediately SEGVs
... The server level, where there were expected to be four kinds of servers: ... simple is that they do not have to run the switch. ... we did not actually budget CPU cycles. ... hard drives, ...
(comp.os.linux.misc) - RE: POP3 Connector Question and general Exchange
... CPU cycles. ... Windows Small Business Server 2003-based computer ... this issue can also be caused by Anti-spam or SMTP ... This posting is provided "AS IS" with no warranties, ...
(microsoft.public.windows.server.sbs) - Re: T5200 - Ideal configuration
... Application server running on them and the OS is Solaris ... Each server has 4 instances of WebLogic running on them. ... FSS will make all CPU cycles available to any process on the ...
(comp.unix.solaris) - I think it may be a virus...
... Here are my symptoms, I am not sure what my next step is. ... I took a packet sniffer and installed it on my SBS2000 server and I noticed ... The Kernel is taking up all of my CPU cycles, I am running between 90 and ...
(microsoft.public.backoffice.smallbiz2000) |
|
