Thursday, February 25, 2016

"SQL Advanced Monitoring" Session for PASS DBA Virtual Chapter

On February 24th 2016 I have presented my session "SQL Advanced Monitoring" for PASS DBA Virtual Chapter.

 Here you can find the recording


 Here can access to the slides and the scripts

http://dba.sqlpass.org/Home.aspx?EventID=4661



Hope you find it useful
--Javier


Posted by at
Labels: , , , , , ,

6 comments:

  1. UnknownMarch 22, 2016 at 2:00 PM

    one of the functions was left out (dbo.FN_Str2VarBinary64). Trying to set up your DeadLock XEVENT Advance Monitoring

    ReplyDelete
    Replies
    1. Javier VillegasMarch 27, 2016 at 7:56 AM

      Here we go

      Create function dbo.FN_Str2VarBinary64 ( @Str varchar(max) )
      returns varbinary(64)
      as
      Begin
      if @Str is null return null

      Declare @Ret varbinary(64)
      Declare @HexStr varchar(max)
      Declare @I smallint
      Declare @C smallint

      Set @Str = replace(@Str, '0x', '' )
      Set @I = 2
      Set @HexStr = ''

      while 1=1
      Begin
      Set @C = charindex( substring(@Str, @I, 1), '0123456789abcdef' ) - 1
      if @C = -1
      break
      Set @HexStr = @HexStr + char( (16 * (charindex( substring(@Str, @I-1, 1), '0123456789abcdef' ) - 1) ) + @C )
      Set @I = @I + 2
      End

      Set @Ret = convert(varbinary(64), @HexStr)

      return @Ret
      End

      Delete
  2. BillyApril 17, 2016 at 2:53 PM

    This comment has been removed by the author.

    ReplyDelete
  3. UnknownMarch 22, 2018 at 5:36 AM

    good information Sql Server dba Online Training Bangalore

    ReplyDelete
  4. latesttechnologyblogsJuly 9, 2018 at 6:04 AM

    It was so nice article. I was really satisfied by seeing this article. SQL server dba Online Training

    ReplyDelete
  5. latesttechnologyblogsJuly 9, 2018 at 6:15 AM

    It was so nice article. I was really satisfied by seeing this article. SQL server dba Online Training

    ReplyDelete

Subscribe to: Post Comments (Atom)