SQLFacts - A powerful suite of FREE tools for SQL Server database professionals.

Tool Functionality - Database Development
SQLFacts The SQLFacts tool is a detailed data dictionary, making it easy to identify many potential issues.
Browse The Browse tool is a subset of the SQLFacts tool, focused on a specified object (table/routine).
References The References tool traces lineage for a specified object (table/routine).
Search The Search tool searches the SQL code of routines (and jobs) for a specified string.
GenerateKeys The GenerateKeys tool generates SQL for primary keys, foreign keys, and foreign key indexes.
GenerateSQL The GenerateSQL tool generates SQL for INSERT, UPDATE, and SELECT statements.
PrimaryKeys The PrimaryKeys tool generates SQL to DROP/ADD all primary keys and unique constraints.
ForeignKeys The ForeignKeys tool generates SQL to DROP/ADD all foreign keys, with TRUNCATE in between.
Trimmer The Trimmer tool generates SQL to DELETE data from a branch of the database.
Features The Features tool returns information about less-commonly-used features currently in effect.
Logger The Logger tool creates objects to track DDL (CREATE/ALTER/DROP) and stored procedures.
Tables The Tables tool returns information about all the tables in the current database.
Routines The Routines tool returns information about all the routines in the current database.
Compressor The Compressor tool evaluates indexes for potentially applying PAGE data compression.
Tool Functionality - Database Administration
BACKUP The BACKUP tool returns information about previous BACKUP operations.
RESTORE The RESTORE tool generates a series of RESTORE statements from the BACKUP history.
MetricsNow The MetricsNow tool gathers diagnostics on the fly and returns several result sets.
MetricsHistory The MetricsHistory tool is a complete monitoring/alerting system for historic diagnostics.
Auditor The Auditor tool returns information about server audits and database audits.
SQLAgent The SQLAgent tool returns information about SQL Server Agent jobs/schedules.
Bufferin The Bufferin tool returns information about what's in the SQL Server buffer cache.
Databases The Databases tool returns information about user databases and tempdb.
Sessions The Sessions tool returns information about what SQL Server is currently doing.
Snooper The Snooper tool returns information about configuration and usage of memory and tempdb.
WaitingRoom The WaitingRoom tool returns information about waits experienced by current sessions.
Resources The Resources tool does on-the-fly monitoring to watch for excessive use of memory or tempdb.
Blocking The Blocking tool does on-the-fly monitoring to watch for excessive blocking of other sessions.
Locksmith The Locksmith tool returns information about locks, granted and/or waiting, in the instance.
Deadlocks The Deadlocks tool returns information about recent SQL Server deadlocks.
Planner The Planner tool returns aggregations for what’s in the SQL Server execution plan cache.
AGLatency The AGLatency tool returns information about databases in Always On Availability Groups.
Tool Functionality - Performance Tuning
Statistics The Statistics tool returns information about statistics associated with indexes and columns.
Threshold The Threshold tool returns information about SQL statements that meet specified thresholds.
QueryHistory The QueryHistory tool returns performance metrics for SQL statements and stored procedures.
QueryTracker The QueryTracker tool returns execution details for a stored procedure and each statement in it.
QueryIndexes The QueryIndexes tool returns information about routines and the indexes they are using.
IndexHistory The IndexHistory tool returns information about indexes, including if/how they are being used.
IndexActivity The IndexActivity tool returns very technical information about index access patterns.
IndexNeeds The IndexNeeds tool returns information about missing index suggestions from DMVs.
IndexNeedsPlus The IndexNeedsPlus tool returns information about missing index suggestions from cached plans.
INCLUDE The INCLUDE tool returns information about routines and indexes, including useful extensions.
Indexer The Indexer tool returns information about existing indexes. It's like a toolkit within a toolkit.
Janitor The Janitor tool returns information (and SQL) about read/write activity for tables/indexes.
Storage The Storage tool returns information about database storage configuration and consumption.
© Copyright 2021 Wingenious