This repo is the home of various SQL-Server-Tools
This repo is the home of various SQL-Server-Tools for MS SQL-Server
MailJobTimeLine_DE.sql - This SQL (german, theres also a not actual english version MailJobTimeLine.sql) sends an email with all jobs displayed in a graphical timeline: Exampletimeline
GetExecutionPlans.sql - Find executionplans
GetProcedureMetrics.sql - Get proceduremetrics
GetErrorLog.sql - Get/Read errorlog
GetIndexFragmentation.sql - Get index fragmentaion
GetExecutionAndInvokecount.sql - Get executionplans and count of invoke
FREEPROCCACHE.sql - Delete executionplan of specific object, see also GetExecutionAndInvokecount.sql to get the planhandle
GetConnections.sql - Get current connections
FindTriggers.sql - Find triggers
Top10WorstProcedures.sql - The TOP 10 of the worst procedures
SelectFlatFiles.sql - Run selects against flatfiles from a filesystem
ChangeOptionsInDatabases.sql - Executes an SQL on all or selected Databases
CleanupHistories.sql - Cleans up histories
OpenTransactions.sql - Shows all current transactions
ShowFragmentation.sql - Shows fragmentation, customize where-clause
GetSynonyms.sql - Get all synonyms of all databases
DeleteExecutionPlan.sql - Delete specific executionplans
GetStatisticSamples.sql - Get all statistics with a sample size < 100%
HallengrenHeaviestMail.sql - Sends an mail with the heaviest statisticsupdates of an hallengren maintenance
MailFragmentation.sql - Sends an mail with all indexes > 100 pages and >= 5% fragmentation
GetOldStatistics.sql - Get old statistics
TriggerDependencies.sql - Find dependencies to other tables in triggers
AnalyzeTraceFileFromSQLProfiler.sql - Query and analyze a tracefile from SQL Profiler