By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,827 Members | 813 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,827 IT Pros & Developers. It's quick & easy.

Need advice on system performance

P: n/a
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

Feb 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

<to*******@gmail.comwrote in message
news:11**********************@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

Feb 8 '07 #2

P: n/a
Thank you

- this link shows how to do a performance audit:

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

Feb 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.