What are the steps to be taken for performance tunning of SQL Server2008?
I need to do the performance tunning in SQL Server 2008. So what are the main steps am should be follow. I'm the new one to do the performance tunnning.
       Because in some tables we don't did the Vaccum. So if i do vaccum , will it increase the performance ? Can i create the index for the large table or containing data.
What are the steps to be taken for performance tunning of SQL Server2008?
===

I need to do the performance tunning in SQL Server 2008. So what are the main steps am should be follow. I'm the new one to do the performance tunnning.
       Because in some tables we don't did the Vaccum. So if i do vaccum , will it increase the performance ? Can i create the index for the large table or containing data.