January 21, 2008 at 7:13 pm
I use SQL Server 2000 at this point, I have very little experience in SQL Server 2005. What can I do to get up to speed? Their first priority is fine tune the database, can anyone give me some idea what to do? In SQL Server 2000, I would use Index, SQL Profiler, Estimate Query plan.
January 21, 2008 at 9:47 pm
Take out list of tables and check for fragmentation.
If the fragmentation is low go for dbcc index defrag.
It will definately increase performance.
You can use profile same way u are using in 2000.
January 21, 2008 at 10:51 pm
Not much of different 🙂
you can use all the tools and steps which you were following to tune in SQL Serevr 2000.
Database Engine Tuning Advisor is a new tool which can be used instead of the Index Tuning Wizard in SQL Server 2005, see the following topics in SQL Server 2005 Books Online:
• Differences between Database Engine Tuning Advisor and Index Tuning Wizard
• Database Engine Tuning Advisor tutorial
Please check the following links for more info:
http://support.microsoft.com/kb/243589/en-us
"More Green More Oxygen !! Plant a tree today"
January 23, 2008 at 5:40 am
SQL 2k5 has a whole bunch of new system catalog views that help you identify unused indexes, etc. Check out "sys.dm_db_index" in BOL. This will get you to the top of the list (you'll see some that say sys.Dm_db_Missing_index underneath) of views that you can use to locate stats on fragmentation, unused & missing indices, etc.
I'd also recommend the book "Pro SQL Server 2005" by Thomas Rizzo and published by APress. It's a decent beginner's book for SQL Server 2005 without all the certification exam stuff shoved into it.
Hope that helps.
January 23, 2008 at 6:41 am
I'd also look at the Inside SQL Server book on queries. That will help with tuning.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply