database tuning advisor

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Bilal Ahmed » database tuning advisor

database tuning advisor

Rate Topic

Display Mode

Topic Options

Author

Message

venugopal.machina

Posted Friday, June 24, 2011 11:58 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 22, 2012 1:19 AM
Points: 8, Visits: 98

what are the features and benifits of database tuning advisor?

Post #1131567

Jeff Moden

Posted Saturday, June 25, 2011 1:15 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:32 PM
Points: 32,906, Visits: 26,792

venugopal.machina (6/24/2011)

what are the features and benifits of database tuning advisor?

Gosh... look it up in Books Online. Figure out your own answer to the interview/test question. At least Google it! Wink

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1131673

ALZDBA

Posted Saturday, June 25, 2011 1:27 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

That could be achieved like this: http://www.google.be/search?hl=nl&source=hp&q=database+tuning+advisor&btnG=Google+zoeken&meta=&aq=f&oq=&sourceid=Mozilla-search

which might eventually get your to http://msdn.microsoft.com/en-us/library/ms166575.aspx
stating
Welcome to the Database Engine Tuning Advisor tutorial. The Database Engine Tuning Advisor enables you to tune databases for improved query processing. Database Engine Tuning Advisor examines how queries are processed in the databases you specify and then it recommends how you can improve query processing performance by modifying physical design structures such as indexes, indexed views, and partitioning.

....

et voila Hehe

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1131679

« Prev Topic | Next Topic »

Permissions