文件列表:

SQL-Server_IO-Occurances-Powershell (0, 2021-01-06)
SQL-Server_IO-Occurances-Powershell\IO-Occurrence(s) Report.msg (120320, 2021-01-06)
SQL-Server_IO-Occurances-Powershell\IO_Occurrences.ps1 (6386, 2021-01-06)
SQL-Server_IO-Occurances-Powershell\IO_Output.PNG (29667, 2021-01-06)

# SQL-Server_IO-Occurances This script will give I/O Ocuurances beyond threshold details for SQL Server. Gives the email alert as well as HTML file with the important detail for passed servers in server list. ## Prerequisites Windows OS - Powershell
SqlServer Module need to be installed if not than type below command in powershell prompt.
Install-Module -Name SqlServer ## Note Process Name
IO Data (Bytes/s)
Data (Operations/Sec)
Other (Bytes/Sec)
Other (Operations/Sec)
Read (Bytes/Sec)
Read (Operations/Sec)
Write (Bytes/Sec)
Write (Operations/Sec) ## Use Open Powershell "C:\IO_Occurences.ps1" # Input Server list file path to (example) {$path = "C:\server_list.txt"}
The output file path to (example) {$HTML = "Path\IO_Report.html"}
Set Email From (example) {$EmailFrom = “example@outlook.com”}
Set Email To (example) {$EmailTo = “example@outlook.com"}
Set Email Subject (example) {$Subject = “IO Occurrences”}
Set Threshold (example) {$threshold = 30}
Set SMTP Server Details (example) {
$SMTPServer = “smtp.outlook.com”
$SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587)
$SMTPClient.Credentials = New-Object System.Net.NetworkCredential(“example@outlook.com”, “Password”);} ## Example O/P  ## License Copyright 2020 Harsh & Sahista ## Contribution * [Harsh Parecha] (https://github.com/TheLastJediCoder) * [Sahista Patel] (https://github.com/Sahista-Patel)
We love contributions, please comment to contribute! ## Code of Conduct Contributors have adopted the Covenant as its Code of Conduct. Please understand copyright and what actions will not be abided.

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：