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


3 comments:

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

    ReplyDelete
    Replies
    1. 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. This comment has been removed by the author.

    ReplyDelete