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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Tuning Advisor

Author  Topic 

SQLFOX
Starting Member

45 Posts

Posted - 2010-09-14 : 17:19:37
Just installed SQL Server 2008 Developer Edition and can't see the Tuning Advisor feature so probably didn't install it correctly??? Any advice is much appreciated! :-)

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-14 : 17:21:41
That's good because the DTA sucks! I never use it. There are better ways to tune your system such as with the DMV Index reports.

Okay I got that out of my system.

You should see it under Tools in Management Studio. If you don't, rerun setup for the tools.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

SQLFOX
Starting Member

45 Posts

Posted - 2010-09-14 : 17:50:16
Ha ha ha - glad I could help release any stress! :-)

It's not under Tools so I'll re-run setup again and give it another try - no doubt I'll be back with more questions though!

Oh, what does DMV stand for and how does it work?

Thanks for your help. :-)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-09-14 : 18:08:53
DMV is the acronym for data management views, which are builtin views that provide a ton of information about your system.

Here's the index reports that I mentioned: http://sqlserverpedia.com/wiki/Index_Related_DMV_Queries

I use the missing indexes report a lot. You have to be very careful with these results as well as the DTS results as you can really harm your system if you added everything that SQL Server recommends. It recommends so many duplicates and near duplicates and just too wide of indexes. Spend a bit of time on the index analysis before deploying them to production.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -