Skip to content

Latest commit

 

History

History
22 lines (18 loc) · 693 Bytes

File metadata and controls

22 lines (18 loc) · 693 Bytes

Library of missing powershell commands for SQL server, used for making static reports
Copy .css and .js files to root reporting folder for nicer html formatting

use it:

Import-Module "C:\Folder\sql_Monitor.psm1" -Force
SQLDoc-PerfCounters-Collect -DataWarehouseServer Petar-Tr -DataWarehouseDatabase SQL_Datawarehouse 

Functions included

Function Get-MissingIndexes     #v1.0
Function Get-unusedIndexes      #v1.0
Function Get-ExpensiveQueries   #v1.1 
Function Get-Warnings           #v1.1 
Function Match_Indexes          #v2.0 
Function Match_AG_Logins        #v2.0 
Function Get-BadPasswords       #v2.0 
Function Get-DefaultTrace       #v2.0