January 13, 2009 at 8:22 pm
I am new as DBA, I need to know which are the best practices for SQL Server 2000, what can I do to improve the performance of the server, What do I have to check first??
January 14, 2009 at 12:22 am
here's a starter :
- simplyfied http://www.extremeexperts.com/sql/articles/BestPractices.aspx
- http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
- http://msdn.microsoft.com/en-us/sqlserver/bb671432.aspx
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 14, 2009 at 12:47 am
More information:
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
http://vyaskn.tripod.com/analyzing_profiler_output.htm
http://searchsqlserver.techtarget.com/general/0,295582,sid87_gci1182550,00.html?Offer=SQLdefpt37
But, in the web, there is a lot of more information.
January 14, 2009 at 6:09 am
After you work through the best practices, you can start here [/url]to work on performance.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 16, 2009 at 12:05 pm
you'll also need experience with systems, something which will only come with time. This isn't something you can learn from a few links and blog posts.
I'd suggest you purchase the SQL Server 2000 performance tuning technical reference - microsoft press; this is the most comprehensive introduction to performance tuning and still holds true for 2005/2008.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 16, 2009 at 1:06 pm
If it is not obvious you are posting SQL Server 2000 on a SQL Server 2005 forum ... The links and opinion above may or may not be valid for you ... just keep that in mind 😉
* Noel
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply