Hi,

I am starting a new job next week. Part of what I am required to do is
a "system diagnostic" on a SQL Server 2000 box to determine what areas
can use improvement - this would include configuration settings,
backup/recovery, sql tuning, etc... and anything else I may not have
mentioned here!

What I need is a thorough and systematic approach to doing this. Can
anyone please give me advice, or point to a FAQ or other links that
discuss this. I am running out of time.

THANKS MUCH

tootsuite,

This is one link you might want to check out.

http://www.microsoft.com/downloads/d...displaylang=en

Also, this site has a wealth of performance information:

http://www.sql-server-performance.com/

-- Bill

<tootsuite@gmail.com> wrote in message
news:1170959288.304029.270560@l53g2000cwa.googlegr oups.com...
> Hi,
>
> I am starting a new job next week. Part of what I am required to do is
> a "system diagnostic" on a SQL Server 2000 box to determine what areas
> can use improvement - this would include configuration settings,
> backup/recovery, sql tuning, etc... and anything else I may not have
> mentioned here!
>
> What I need is a thorough and systematic approach to doing this. Can
> anyone please give me advice, or point to a FAQ or other links that
> discuss this. I am running out of time.
>
> THANKS MUCH
>

Thank you

- this link shows how to do a performance audit:

http://www.sql-server-performance.co...cles_audit.asp