How to evaluate the performance of the sql server

Hi all,
How to evaluate the performance of the SQL server 2000?
Hope you can help.
Eric
It depend of what area of performance that you are looking for. If you
are looking for database access or query performance, you can use
Profiler or examine the query execution plan.
If you want to see the server performance, you can use performance counter.
Eric wrote:
> Hi all,
> How to evaluate the performance of the SQL server 2000?
> Hope you can help.
> Eric
|||"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:24381665-3E5C-4554-84D7-B798402D8FF6@.microsoft.com...
> Hi all,
> How to evaluate the performance of the SQL server 2000?
> Hope you can help.
> Eric
Brad McGehee put together a great article on this.
http://www.devarticles.com/c/a/SQL-S...ormance-Audit/
Rick Sawtell
MCT, MCSD, MCDBA