Tuning SharePoint

Tuning SharePoint by first looking at SQL Server:

Run some queries and check this out showing the top 5 tables and indexes used:

table_name, index_name, user_seeks


Webs Webs_PK 116,483,799

AllDocs AllDocs_PK 78,993,246

Sites Sites_Id 71,948,246

UserInfo UserInfo_PK 33,327,126

AllLists AllLists_PK 30,029,967

So next step is to rebuild and change the fill factor.