Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avipenina
Starting Member
44 Posts |
 Posted - 2008-01-15 : 14:42:07
|
| Hi All,from your experience in SQL 2005 - do i have any free software that can help in improve performance or can help in identifying performance bottleneck. two examples of performance and help that i use usually use are the maintenance plan that do (check DB > reorganized index > rebuild index > update statics) and the second software is the SQL 2005 DASHBOARD for the reporting help.do you have any other free tools and help that you can give me for performance or any thing that i must have in my SQL 2005 servers.Thx |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-15 : 16:16:03
|
| Have you tried the Index Tuning Advisor..?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
avipenina
Starting Member
44 Posts |
Posted - 2008-01-15 : 16:48:59
|
quote:
Originally posted by dinakar
Have you tried the Index Tuning Advisor..?
yes Thx.any other tips or tools? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-15 : 16:55:17
|
| Use the DMVs in 2005. Find the unused/missing indexes. Collect the list every week for a month or two. Observe the trends. IF you have indexes never used in 2 months, chances are they never will be. So you could just remove those indexes. That can help improve inserts/updates/deletes and also reduce your maintenance window.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
performance and database improve help