Tag Archives for " DMV "

Apr 13

List Tables That May Be Over Indexed

By Lori Brown | Beginner , Helpful Scripts , Performance Tuning , SQL Administration , SQL Server , Tip of the Month

While not having enough indexes can be bad for query performance, having too many indexes can also be just as bad. Use the query below to get a list of tables in your database that has more than 10 indexes. — Tables with large number of indexes select t.name as TablesWithLargeNumInx, count(i.name) as CountIndexes from […]

Continue reading
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
>