Hi, need advice on system performance 1

[sqlgracie]

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

 

[ptheriault]

Here are some very good links to help you.

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

http://www.sql-server-performance.com/q&a_performance.asp

http://www.databasejournal.com/features/mssql/article.php/1466951

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[sqlgracie]

Thanks Paul,

I found a very good article on doing a performance audit on sql server on

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

sheesh, there is a lot to cover, and this doesn't even include sql tuning, per se.

But this is a good start!

 

[ptheriault]

no problem.
The sites have lots of good scripts too that you can run to check performance.

Good Luck in your new job.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[sqlgracie]

Oh, one more thing, I am also trying to find a FAQ that covers just "general DBA" maintenance tasks - sort of what you would see under maintenance plans. Or do you think maintenace plans cover the basics?

For example, things such as:

clean up of msdb backup tables
automatic reindexing
etc

Just want a list of everything that needs to be done

 

[ptheriault]

Here is a quick list of things that I daily and weekly.

Daily
-Backup all database and TLOG.
-For db's that I need to recover to a point in time I will run incremental TLOG backup through out the day.(every 30 min)
-Update stats

Weekly
Re-index
update usage
cycle the error log so log doesn't get to big
checkdb
delete old backup history (older than 3 months)

I'm sure I've left out somethings but you get the idea. Here is a really good site that can help.

http://www.sswug.org/Default.asp?

- Paul
- If at first you don't succeed, find out if the loser gets anything.