Monthly Archives: February 2016

Feb 12

SQL Connections – Finding what fixed port SQL is listening on

By Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server

— by Lori Brown  @SQLSupahStah While trying to add a database to an existing AlwaysOn Availability Group (AG), I was having difficulty making a connection from the primary replica to the secondary replica. The availability group was functioning but as I tried to add a database to it, my connection to the secondary replica was […]

Continue reading
Feb 04

Feb 2016 Tip of the Month – New function in SQL 2016: sys.dm_exec_function_stats

By SQLRx Admin | Intermediate , Performance Tuning , SQL Server , Tip of the Month

SQL Server Performance Tuning:  New function in SQL 2016: sys.dm_exec_function_stats Returns performance statistics for cached functions. Returns information about scalar functions, including in-memory functions and CLR scalar functions but not about table valued functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the […]

Continue reading