PROBLEMA

Imaginamos que você tenha feito um site para o seu CallCenter(suporte)-'somente é um exemplo', com listas personalizadas, fluxos que envia email e tranfere dados para outras listas, enfim, N features.

SOLUÇÃO

COMO FAZER PASSO A PASSO

1. Abra o Sharepoint Designer 2007 e clique em:

Arquivo/Exportar/Exportar para Modelo do Sharepoint

 

1. Nome do Arquivo.
2. Nome do Modelo
3. Descrição.

 

 

OBS: Como o seu site foi criado em Português, então ele automaticamente adota a lingua Português.

 

ULTIMO PASSO. CRIAR UM SITE E USAR SEU NOVO TEMPLATE/MODELO

Agora como foi criado seu modelo, basta usar ele.

Vá na sua intranet, e cliquem em:

Ações do Site/Criar Site

No qual vai aparecer a opção para informar os dados do seu novo site, principalmente a parte que você escolhe o modelo/template no qual vai se basear seu novo site.

Eis que aí está!!! Clique na guia Personalizado, e vai estar lá seu template, no nosso caso. idevnetCallCenter

Abraços e espero ter ajudado.

1. Cria o BAT e coloque o conteúdo baixo.

ECHO installing templates - site admn
stsadm -o addtemplate -filename BoardDirectors.stp -title "Board of Directors" -description "The Board of Directors application template provides a single location for an external group of members to store and locate common documents such as quarterly reviews, shareholder meeting notes and annual strategy documents."
stsadm -o addtemplate -filename BusinessPerformance.stp -title "Business Performance Reporting" -description "The Business Performance Reporting application template helps organization managers track the satisfaction of customers through a combination of surveys and discussions."
stsadm -o addtemplate -filename CaseManagement.stp -title "Case Management for Government Agencies" -description "The Case Management for Government Agencies application template helps case managers track the status and tasks required to complete their work."
stsadm -o addtemplate -filename ClassroomManagement.stp -title "Classroom Management" -description "The Classroom Management application template helps instructors and students organize and store information related to a particular class."
stsadm -o addtemplate -filename ClinicalTrial.stp -title "Clinical Trial Initiation and Management" -description "The Clinical Trial Initiation and Management application template helps teams manage the process of tracking clinical trial protocols, objective setting, subject selection and budget activities."
stsadm -o addtemplate -filename CompetitiveAnalysis.stp -title "Competitive Analysis Site" -description "The Competitive Analysis Site application template helps teams organize information about competitors and their products."
stsadm -o addtemplate -filename DiscussionDatabase.stp -title "Discussion Database" -description "The Discussion Database application template provides a location where team members can create and reply to discussion topics."
stsadm -o addtemplate -filename DisputedInvoice.stp -title "Disputed Invoice Management" -description "The Disputed Invoice Management application template helps accounts payable departments track open invoices including the potential savings associated with paying the invoice early."
stsadm -o addtemplate -filename EmployeeActivities.stp -title "Employee Activities Site" -description "The Employee Activities Site application template helps manage the creation and attendance of events for employees."
stsadm -o addtemplate -filename EmployeeBenefits.stp -title "Employee Self-Service Benefits" -description "The Employee Self-Service Benefits application template provides tools for an organization to inform employees about available benefits as well as enabling them to enroll for each benefit."
stsadm -o addtemplate -filename EmployeeTraining.stp -title "Employee Training Scheduling and Materials" -description "The Employee Training Scheduling and Materials application template helps instructors and employees manage courses and related materials."
stsadm -o addtemplate -filename EquityResearch.stp -title "Equity Research" -description "The Equity Research application template helps teams collaborate on researching stocks and other equities."
stsadm -o addtemplate -filename ManufacturingProcess.stp -title "Manufacturing Process Management" -description "The Manufacturing Process Management application template helps teams to model and track manufacturing processes as well as tasks and issues that arise in the upkeep of these processes."
stsadm -o addtemplate -filename MarketingCampaign.stp -title "Integrated Marketing Campaign Tracking" -description "The Integrated Marketing Campaign Tracking application template helps marketing managers track the implementation and success of outbound marketing activities."
stsadm -o addtemplate -filename NewStoreOpening.stp -title "New Store Opening" -description "The New Store Opening application template helps a team manage the opening of new store locations or re-modeling of existing store location."
stsadm -o addtemplate -filename ProductPlanning.stp -title "Product and Marketing Requirements Planning" -description "The Product and Marketing Requirements Planning application template enables teams to manage the process of collecting and documenting requirements for new products."
stsadm -o addtemplate -filename RequestForProposal.stp -title "Request for Proposal" -description "The Request for Proposal application template helps manage the process of creating and releasing an initial RFP.  The site also helps simplify the process of notifying individuals about the status of the RFP and submitted proposals."
stsadm -o addtemplate -filename SportsLeague.stp -title "Sports League" -description "The Sports League Site application template helps an intra-company league administrator manage a baseball league."
stsadm -o addtemplate -filename TeamWorkSite.stp -title "Team Work Site" -description "The Team Work Site application template provides a place where project teams can upload background documents, track scheduled calendar events and submit action items that result from team meetings."
stsadm -o addtemplate -filename TimecardManagement.stp -title "Timecard Management" -description "The Timecard Management application template helps teams track hours spent working on various projects.  Team members ‘punch in’ and ‘punch out’ of work on project tasks.  Managers can view the total hours spent by project and by person."

 

ECHO adding solutions -server admin
stsadm -o addsolution -filename AbsenceVacationSchedule.wsp
stsadm -o addsolution -filename BudgetingTrackingMultipleProjects.wsp
stsadm -o addsolution -filename BugDatabase.wsp
stsadm -o addsolution -filename ChangeRequest.wsp
stsadm -o addsolution -filename ContactsManagement.wsp
stsadm -o addsolution -filename DocumentLibraryReview.wsp
stsadm -o addsolution -filename EventPlanning.wsp
stsadm -o addsolution -filename InventoryTracking.wsp
stsadm -o addsolution -filename ITTeamWorkspace.wsp
stsadm -o addsolution -filename JobRequisition.wsp
stsadm -o addsolution -filename PhysicalAssetTracking.wsp
stsadm -o addsolution -filename ProjectTrackingWorkspace.wsp
stsadm -o addsolution -filename RoomEquipmentReservations.wsp

ECHO deploying solutions - site admin
stsadm -o deploysolution -name AbsenceVacationSchedule.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name BudgetingTrackingMultipleProjects.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name BugDatabase.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name ChangeRequest.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name ContactsManagement.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name DocumentLibraryReview.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name EventPlanning.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name InventoryTracking.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name ITTeamWorkspace.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name JobRequisition.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name PhysicalAssetTracking.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name ProjectTrackingWorkspace.wsp -allowgacdeployment -immediate
stsadm -o deploysolution -name RoomEquipmentReservations.wsp -allowgacdeployment -immediate

ECHO resetting IIS
IISRESET

1. Coloque todos os templates WSP e STP no mesmo diretorio  que está o BAT.
2. Detalhe para facilitar sua vida coloque o caminho do stsadm no PATH em variaveis do ambiente, assim, não precisará ficar toda vez que executar o comando ir no diretorio dele.
3. Caso vc colocou o Diretorio do stsADM.EXE no PATH, e seguiu os passos acima, basta clicar no NomeArquivo.BAT e dai vc abre o Sharepoint Portal.
4. Clique em HOME, "Ações do Site" e "CRIAR SITE".
5.  Bem como eu seu que vc vai fazer a pergunta !!! " Bha na Seleção do Modelo kd os Site Admin Templates???? só entrou os Server Admin Templates, na guia ":  Resposta--> Os sites ADMIN templates só tem em INGLES ou seja, se vc tiver seu portal em Portugues só vai aparecer a guia "Modelos de Aplicativos" no qual são so 20 modelos que estão disponíveis na lingua Portuesa.
6. Bha e agora o que eu faço???? Bom calma!!! Segue a resposta.
   1. Basta vc instalar o OptionPackLanguage em ingles para ele apareça. Segue o link.
   2. http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=36ee1bf0-652c-4e38-b247-f29b3eefa048
7. Bom infelizmente terá que executar novamente as linhas abaixo.

ECHO installing templates - site admn
stsadm -o addtemplate -filename BoardDirectors.stp -title "Board of Directors" -description "The Board of Directors application template provides a single location for an external group of members to store and locate common documents such as quarterly reviews, shareholder meeting notes and annual strategy documents."
stsadm -o addtemplate -filename BusinessPerformance.stp -title "Business Performance Reporting" -description "The Business Performance Reporting application template helps organization managers track the satisfaction of customers through a combination of surveys and discussions."
stsadm -o addtemplate -filename CaseManagement.stp -title "Case Management for Government Agencies" -description "The Case Management for Government Agencies application template helps case managers track the status and tasks required to complete their work."
stsadm -o addtemplate -filename ClassroomManagement.stp -title "Classroom Management" -description "The Classroom Management application template helps instructors and students organize and store information related to a particular class."
stsadm -o addtemplate -filename ClinicalTrial.stp -title "Clinical Trial Initiation and Management" -description "The Clinical Trial Initiation and Management application template helps teams manage the process of tracking clinical trial protocols, objective setting, subject selection and budget activities."
stsadm -o addtemplate -filename CompetitiveAnalysis.stp -title "Competitive Analysis Site" -description "The Competitive Analysis Site application template helps teams organize information about competitors and their products."
stsadm -o addtemplate -filename DiscussionDatabase.stp -title "Discussion Database" -description "The Discussion Database application template provides a location where team members can create and reply to discussion topics."
stsadm -o addtemplate -filename DisputedInvoice.stp -title "Disputed Invoice Management" -description "The Disputed Invoice Management application template helps accounts payable departments track open invoices including the potential savings associated with paying the invoice early."
stsadm -o addtemplate -filename EmployeeActivities.stp -title "Employee Activities Site" -description "The Employee Activities Site application template helps manage the creation and attendance of events for employees."
stsadm -o addtemplate -filename EmployeeBenefits.stp -title "Employee Self-Service Benefits" -description "The Employee Self-Service Benefits application template provides tools for an organization to inform employees about available benefits as well as enabling them to enroll for each benefit."
stsadm -o addtemplate -filename EmployeeTraining.stp -title "Employee Training Scheduling and Materials" -description "The Employee Training Scheduling and Materials application template helps instructors and employees manage courses and related materials."
stsadm -o addtemplate -filename EquityResearch.stp -title "Equity Research" -description "The Equity Research application template helps teams collaborate on researching stocks and other equities."
stsadm -o addtemplate -filename ManufacturingProcess.stp -title "Manufacturing Process Management" -description "The Manufacturing Process Management application template helps teams to model and track manufacturing processes as well as tasks and issues that arise in the upkeep of these processes."
stsadm -o addtemplate -filename MarketingCampaign.stp -title "Integrated Marketing Campaign Tracking" -description "The Integrated Marketing Campaign Tracking application template helps marketing managers track the implementation and success of outbound marketing activities."
stsadm -o addtemplate -filename NewStoreOpening.stp -title "New Store Opening" -description "The New Store Opening application template helps a team manage the opening of new store locations or re-modeling of existing store location."
stsadm -o addtemplate -filename ProductPlanning.stp -title "Product and Marketing Requirements Planning" -description "The Product and Marketing Requirements Planning application template enables teams to manage the process of collecting and documenting requirements for new products."
stsadm -o addtemplate -filename RequestForProposal.stp -title "Request for Proposal" -description "The Request for Proposal application template helps manage the process of creating and releasing an initial RFP.  The site also helps simplify the process of notifying individuals about the status of the RFP and submitted proposals."
stsadm -o addtemplate -filename SportsLeague.stp -title "Sports League" -description "The Sports League Site application template helps an intra-company league administrator manage a baseball league."
stsadm -o addtemplate -filename TeamWorkSite.stp -title "Team Work Site" -description "The Team Work Site application template provides a place where project teams can upload background documents, track scheduled calendar events and submit action items that result from team meetings."
stsadm -o addtemplate -filename TimecardManagement.stp -title "Timecard Management" -description "The Timecard Management application template helps teams track hours spent working on various projects.  Team members ‘punch in’ and ‘punch out’ of work on project tasks.  Managers can view the total hours spent by project and by person."

ECHO resetting IIS
IISRESET

1. ACABOU??? Infelizmente não!!! AI VAI O BUG AGORA. (Um monte de JS que nao foi instalado)
2. Se vc tentar criar o Site com os modelos em ingles Site Admin Templates.  Vai ficar como na imagem abaixo, ele dará uma opção de lingua/idioma, para que escolha. Quando escolher Ingles, vai aparecer a guia CUSTOM, no qual pode escolher um modelo, para trabalhar com Surveys (sim só assim pode trabalhar com enquéritos, no qual antes via padrão) Busniess Performance Reporting
3. 
4. Após criar o site, aguarde ... QUE IRÁ CRIAR NORMALMENTE SEM ERROS, APARENTEMENTE.
5. Para entender o problema acompanhe em alguns foruns.
   1. http://forums.microsoft.com/Technet-BR/ShowPost.aspx?PostID=2388707&SiteID=29&mode=1
6. CONTINUANDO.... A SOLUÇÃO PARA ESTE ERRO
   1. Problema está em  Editar a Navegação (Navigation) de Site TEmplates, qual pede esta opção aparece este erro.
      -->
      Cannot make a cache safe URL for "SelectorControls.js", file not found. Please verify that the file exists under the layouts directory.
      Troubleshoot issues with Windows SharePoint Services.
   2. Faça o seguinte
      1. Abra O IIS.
         Localize o site Sharepoint
         Verifique que tem uma pasta 1033 e 1046
         * 1033 (é os site templates) no qual tem que ter o arquivo Js, que ele ta pedindo.
         Veja que nao tem. Basta compiar do 1046 para dentro da pasta
         * 1046 (é o admin templates)
      2. Copie os dois arquivos
      3. --> AssetPickers.js (serve para vc controlar a udiencia dos menus), HierarchicalListBox.js / SelectorControls.js (vai resolver o erro do Navegação) (   Look and Feel /Navigation )
         --> PickerTreeDialog.js,CmsSiteManager.js (vai resolover o erro do Site Administration/   Content and structure )
          Vai faltar o CSS tb tem que arrumar.
          * Copie a pasta Sytle tb do 1046 para o 1033 (porém nao subistitua os css somente copie as que estao faltando)

Espero ter ajudado, pois isto me enxeu o saco por quase 4 horas, até resolver isto.

Abraços galera.

Esta ferramenta te dá algumas opções como:

1. Analisar Querys e performance em cima dele, dando resultados como: Melhoria de Indíces e Particionamento de Tabelas Gigantes(somente realmente grandes vale a pena exemplo: 50 GB de disco ou milhoes de registro)
2. Em cima de uma única Query, rodar no seu BD para verificar tb os índices.
3. Ou uma técnica bem simples, que é usar a PROFILER executar ele, usando alguns fitros como: (Fique analisando as querys por 3 horas mais ou menos e salve o trace para que possa ser usado pelo DTA), fazendo assim que ele analise por exemplo querys rodadas por determinado sistema para ver onde é o gargalo.
   1. DataBaseName  - Like 'NomeBanco'
   2. TextData - Like 'Select%' - NotLike 'Delete%', 'Update%', 'Insert%'

  DTA ( DataBase Engine Tuning Advisor)

No menu Start / All Programs / Microsoft SQL Server 2005, / Performance Tools/ Database Engine Tuning Advisor.

Após abrir o DTA, você vai notar que ele tem algumas opções de qual banco de dados vai fazer este exame.

1. Basta clicar no Check box, do BD que deseja, escolhe o nome do Database Workload BD.
2. Logo depois de seguir os passos acima, ou seja, vc tem o arquivo com SQL ou TRC(trace do profiler), vc escolhe a opção do WorkLoad ( tipo de trabalho que será carregado)..
3. Clique em Browse busque o arquivo com os SELECTS ou TRACE que vc quer que ele analyze. Veja a figura a baixo.

Nas opções avançadas deixe tudo padrão, pois caso vc modifique alguma coisa pode acarretar que o DTA ele dé a sugestão e também faça a ação. O caso se ele criar Indices para vc nao tem problema. O problema maior e se ele deleta um índice importante. Em ingles deixe Keep(deixar), caso vc modificou alguma coisa.

Clique em Actions->Start Analysis (para começar a analisar)

Após terminar a anáise vai ser aberto algumas opções como RECOMENDAÇÔES. Veja na figura abaixo.

IMPORTANTE: Note que tem uma coluna chamada Recomendation, se ela estiver em branco, não tem que fazer ação nenhuma.

Caso se ela tiver, terá informações como CREATE, DROP, DELETE, que vai indicar para criar índices, deletar índices.

Agora você pode salvar em XML e calmamente analisar as recomendações que ele fez.

Fazer a implementação VIA Comando DOS

Também pode ser feito via Prompt-DOs basta executar o comando acima. dta -? | more

 IMPORTANTE: Pessoal , uma coisa muito importante, o DTA ele somente dá dois tipos de Recomendações ìndices e Particionamento e até análises de indireto de querys com problemas.

Ex: Se vc usar BD Nortwind

1. Query usando índice Clusterizado (PK)
   • set statistics io on -- ligando as estatisticas
   • go
   • select employed , customerid from  orders where employeid=7
   • Resultado da query (estatistica)
   • logical reeds 24 (24 leituras logicas)
2. Query usando índice não Clusterizado (criado por alguem )  com With (somente o sql server 2005 usa exta sintaxe
   • set statistics io on -- ligando as estatisticas
   • go
   • select employed , customerid from with (index=IX_employed)  orders where employeid=7
   • Resultado da query (estatistica)
   • logical reeds 97 (97 leituras logicas)

RESUMINDO:

Vc verifica que o indice criado IX_employed, foi criado porém é um índice ruim, por isto pode ser removido este indice.

Este é somente um exemplo para você poder interpretar as recomendações do DTA.

Bom era isto.

Boa sorte, qq coisa mandem email beleza? t+