Skip to content

Petar-T/SQLDoc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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 

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages