Etusivu Tutki Apua
Rekisteröidy Kirjaudu sisään
Apq
/
tigertoolbox
peilaus alkaen https://github.com/microsoft/tigertoolbox.git
1
0
Haarauta 0
Tiedostot Esitykset 0 Wiki
Puu: 2.0.0
Haarat Tunnisteet
tigertoolbox
/
SQL-Performance-Baseline
Parikshit dcad1ef7c0 Update CreateSystemhealthDBAndSchema.sql 9 vuotta sitten
..
CREATECollectionJob.sql cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
CREATEDATABASE.sql cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
CREATEOBJECTS.sql cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
CreateSystemhealthDBAndSchema.sql dcad1ef7c0 Update CreateSystemhealthDBAndSchema.sql 9 vuotta sitten
Get-SQLPerfCounters.ps1 cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
Out-DataTable.ps1 cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
README.md 5ef576c176 Create README.md 9 vuotta sitten
Reporting.zip cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten
Write-DataTable.ps1 cc39eb19a0 Adding files for SQL Performance Baseline 9 vuotta sitten

README.md

SQL Performance Baseline

A recording of the webinar which talks about this solution is available on YouTube

Data Collection

  1. T-SQL Scripts
  2. CREATEDATABASE, CREATEOBJECTS & CREATECOLLECTIONJOB -> these t-SQL script creates the database dba_local & schema & SQL Agent Jobs required for performance data collection. These SQL scripts needs to be ran on all the sql instance which needs to be monitored
  3. Powershell Scripts
  4. Get-SQLPerfCounters, Out-DataTable, Write-DataTable -> These Powershell scripts needs to be copied to location C:\Scripts\ which is used for Perfmon data collection. These script needs to be copied on all the target server which needs to be monitored & should be copied to the folder C:\Scripts

SQL Performance baselining Reports & Xevent Reports (SSRS Reports)

The SSRS Reports should be deployed on the central SSRS server which should be greater than SQL 2012.

You can follow the steps mentioned below to set it up in your environment.

Data Collection Steps for each SQL Instance to Monitor

  1. Connect to SQL instance to monitor
  2. Run CREATEDATABASE.sql
  3. Run CREATEOBJECTS.sql
  4. Run CREATECOLLECTIONJOB.sql
  5. Copy PS Scripts in the folder C:\Scripts
  6. Check SQL Agent JOBs History to see if it runs successfully
  7. Repeat for each SQL Instance you want to monitor

Setting up & Deploying Reporting

  1. Deploy the SSRS Reports & see if data populates in the reports.

DISCLAIMER: © 2016 Microsoft Corporation. All rights reserved. Sample scripts in this guide are not supported under any Microsoft standard support program or service. The sample scripts are provided AS IS without warranty of any kind. Microsoft disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample scripts and documentation remains with you. In no event shall Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility of such damages.