I am running a windows 2003 server with sql 2000 sp3.
I have 2 80GB databases. I also have an 8 way processor.
cpu is consistently above 80%.
what can i do to gain some performance improvements?
Thank youYou have to identify what exactly is resulting in high CPU utilization.
I would use Profiler to track down the long running and most CPU intensive
stored procedures and queries, and tune them.
Often, the lack of useful indexes results in performance problems.
You will probably find the following link helpful:
http://vyaskn.tripod.com/analyzing_profiler_output.htm
Microsoft SQL Server 2000 Performance Tuning Technical Reference
http://vyaskn.tripod.com/sql_server...ance_tuning.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:BD5E933B-33C3-4A57-8FEE-C53D3505E1D3@.microsoft.com...
I am running a windows 2003 server with sql 2000 sp3.
I have 2 80GB databases. I also have an 8 way processor.
cpu is consistently above 80%.
what can i do to gain some performance improvements?
Thank you|||RobinMC,
Have a look at the articles at www.sql-server-performance.com. Your
question is very general, and as such cannot be answered satisfactorily
here.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RobinMC wrote:
> I am running a windows 2003 server with sql 2000 sp3.
> I have 2 80GB databases. I also have an 8 way processor.
> cpu is consistently above 80%.
> what can i do to gain some performance improvements?
> Thank you
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment