Advertisement
Guest User

Untitled

a guest
Oct 11th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. $failed = $false;
  2. $loginDuration = (Measure-Command {
  3. $ncon = New-Object System.Data.SqlClient.SqlConnection `
  4. @( 'Data Source=1.2.3.4,16143;Database=Test;User=Test;Password=****;Pooling=false;' );
  5. try
  6. {
  7. $ncon.Open();
  8.  
  9. $cmd = New-Object System.Data.SqlClient.SqlCommand `
  10. @( 'SELECT @@VERSION', $ncon );
  11. $cmd.ExecuteNonQuery();
  12.  
  13. $ncon.Dispose();
  14. }
  15. catch
  16. {
  17. $failed = $true;
  18. }
  19. }).TotalMilliseconds;
  20. Write-Metric -metric 'itp.dbserver.logintime' -unit 'milliseconds' `
  21. -value (&{if ($failed) { 120000 } else { $loginDuration }});
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement