Performance

Hi
I have a sql server 2000 running with SP4.
My goal is the improvement of server prformance! Can i install server
performance advisor and get about SQL?
RegardsChico
Start with
http://www.sql-server-performance.com/
"Chico" <Chico@.discussions.microsoft.com> wrote in message
news:7015EDDF-A5D5-403A-BEFD-6FFD003A0D26@.microsoft.com...
> Hi
> I have a sql server 2000 running with SP4.
> My goal is the improvement of server prformance! Can i install server
> performance advisor and get about SQL?
> Regards
>|||Run profiler for 20 minutes or so during a period of high activity. Store
the trace in a SQL table. Index the trace table by cpu, then duration, then
reads, then writes - ie 4 seperate indexes.
Then do queries like this
select top 1000 textdata from tracetable order by duration desc
GO
select top 1000 textdata from tracetable order by writes desc
GO
select top 1000 textdata from tracetable order by Reads desc
Go
select top 1000 textdata from tracetable order by CPU desc
Now you know the most expensive queries or stored procedures. From here on
end its a matter of improving the performance of the queries, procs
identified above. Study the execution plans and see if you can't improve the
code itself, or improve the performance by well placed indexes.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Chico" <Chico@.discussions.microsoft.com> wrote in message
news:7015EDDF-A5D5-403A-BEFD-6FFD003A0D26@.microsoft.com...
> Hi
> I have a sql server 2000 running with SP4.
> My goal is the improvement of server prformance! Can i install server
> performance advisor and get about SQL?
> Regards
>