meine Sys/Db admin & Developper Notitzen - wer Rechtschreibfehler findet darf sie behalten ... my Sys/Db Admin and developper notes - I don't care about typos
Friday, May 29, 2015
einfaches / simple power shell script
[CmdletBinding()]
param(
[Parameter(Mandatory=$True)]
[string[]] $Computername='localhost'
)
Get-VM -ComputerName $Computername
with help:
<#
.Synopsis
short Explanation
.Description
long Explanation
.Parameter Computername
paramdesc
.Example
getVm localhost
#>
[CmdletBinding()]
param(
[Parameter(Mandatory=$True)]
[string[]] $Computername='localhost'
)
Get-VM -ComputerName $Computername
Monday, May 25, 2015
nützliche power shell cmdlets
update-help
help
alias
Import-PSSession
New-PSSession
Get-PSSession
help exit-PSSession -ShowWindow
icm
$env:PSModulePath -split ";"
's1','s2' | foreach {write-output $_}
Wednesday, May 20, 2015
vs (visual studio) shotcuts
shift Alt Enter ... Fenster groß / klein
Vs2013: Alt +Pfeiltaste: Zeile verschieben
Strg Alt Space ... toggle INtellisense Mode
Strg-Shift-V Rotate Zwischenablage
crt-shift Mausrad Zoom
crt k,s : surround with
crt F10 debug till curser
wichtige EInstellungen:
Optionen / Projekte und Solutions / Aktives Element im Projektmappen Explorer überwachen
Vs2013: Alt +Pfeiltaste: Zeile verschieben
Strg Alt Space ... toggle INtellisense Mode
Strg-Shift-V Rotate Zwischenablage
crt-shift Mausrad Zoom
crt k,s : surround with
crt F10 debug till curser
wichtige EInstellungen:
Optionen / Projekte und Solutions / Aktives Element im Projektmappen Explorer überwachen
Saturday, May 16, 2015
powershell drivesize remaining
PS C:\Windows\system32> icm hv01,hv02,hv04 {Get-Volume} | select pscomputername, driveletter,sizeremaining | Format-Table -AutoSize
Tuesday, May 12, 2015
sql disk io
short reblogged from http://www.mssqltips.com/sqlservertip/2127/benchmarking-sql-server-io-with-sqlio/
1) change param.txt to bigger testfile (10Gb) and correct drive:
param.txt
c:\testfile.dat 8 0x0 10240
#name threads cpuaffinity sizeInMB
2) create testfile: sqlio -kW -s5 -fsequential -o4 -b64 -Fparam.txt
C:\Program Files (x86)\SQLIO>sqlio -kW -s5 -fsequential -o4 -b64 -Fparam.txt
sqlio v1.5.SG
parameter file used: param.txt
file c:\testfile.dat with 8 threads (0-7) using mask 0x0 (0)
8 threads writing for 5 secs to file c:\testfile.dat
using 64KB sequential IOs
enabling multiple I/Os per thread with 4 outstanding
size of file c:\testfile.dat needs to be: 10737418240 bytes
current file size: 0 bytes
need to expand by: 10737418240 bytes
expanding c:\testfile.dat ... done.
using specified size: 10240 MB for file: c:\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 1327.03
MBs/sec: 82.93
VM on HyperV on SSD Raid,other examples:
Al:
IOs/sec: 3862.24
MBs/sec: 241.39
3) RANDOM WRITE TEST: (-d ... Drive -s seconds -t threads simultan)
sqlio -dC -BH -kW -frandom -t1 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kW -frandom -t2 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kW -frandom -t4 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kW -frandom -t8 -o1 -s60 -b64 \testfile.dat
C:\Program Files (x86)\SQLIO>sqlio -dC -BH -kW -frandom -t1 -o1 -s90 -b64 \testfile.dat
sqlio v1.5.SG
1 thread writing for 90 secs to file C:\testfile.dat
using 64KB random IOs
enabling multiple I/Os per thread with 1 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 10240 MB for file: C:\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 1082.02
MBs/sec: 67.62
Al -t1:
IOs/sec: 915.90
MBs/sec: 57.24
4)RANDOM READ TEST:
sqlio -dC -BH -kR -frandom -t1 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kR -frandom -t2 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kR -frandom -t4 -o1 -s60 -b64 \testfile.dat
sqlio -dC -BH -kR -frandom -t8 -o1 -s60 -b64 \testfile.dat
C:\Program Files (x86)\SQLIO>sqlio -dC -BH -kR -frandom -t1 -o1 -s30 -b64 \testfile.dat
sqlio v1.5.SG
1 thread reading for 30 secs from file C:\testfile.dat
using 64KB random IOs
enabling multiple I/Os per thread with 1 outstanding
buffering set to use hardware disk cache (but not file cache)
using current size: 10240 MB for file: C:\testfile.dat
initialization done
CUMULATIVE DATA:
throughput metrics:
IOs/sec: 2409.36
MBs/sec: 150.58
Al:
IOs/sec: 278.00
MBs/sec: 17.37
Sunday, May 10, 2015
powershell examples
get-host
update-help
Get-ExecutionPolicy
Get-PSDrive
get-vm -ComputerName hv01,hv02,hv04 | where State -eq Off | sort name
help New-SelfSignedCertificate -Examples
New-SelfSignedCertificate -DnsName www.test.net -CertStoreLocation Cert:\LocalMachine\My
$var=read-host "Enter a Computername"
Write-Output "Test"
Write-Host "Test"
Write-Warning "Test"
's1','s2' | foreach {write-output $_}
Wednesday, May 06, 2015
kiwi syslog daily logfile
Default/Actions/Log to file
C:\Programme\Syslogd\Logs\Interfaceueberwachung\log%DateISO.txt
Tuesday, May 05, 2015
Subscribe to:
Posts (Atom)