Source code for 'Healthy SQL' by Robert Pearl
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
9781430267737.jpg
ActiveXESessions_SystemHealthInfo_Ch06_ExpandingTheToolset.sql
AllDeadLockScripts_Ch08_Deadlocks.sql
CDCScripts_Ch10_ChangeDataCapture.sql
CalculateAllSQLServerPerformanceCounterValues_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql
CalculateCumulativeWaitTimesByWaitType_Chap03_SlowPerformance.sql
CaptureCfgChangesUsingDefaultTrace_Ch10_DefaultTrace.sql
CompareResourceWaitsVsSignalWaits_Chap03_SignalWaits.sql
CreateAgentAlerts_Ch08_CreateANewAlert.sql
CreateCustomDataCollectionScriptForQueryStats_Ch07_DefiningCustomDataCollection.sql
CreateCustomIndexUsageCollector_Ch07_DefiningCustomDataCollection.sql
CreateDDLTriggerForServerDatabaseEvent_Ch10_DDLTriggers.sql
CreateDECODE_TLOGScripts_Ch10_ReadingTheTransactionLog.sql
CreateHistoricalWaitStatsTable_Ch07_RollingYourOwn.sql
CreateMonitoredWaitTypesTable_Ch07_RollingYourOwn.sql
CreateSQLAuditsAndServerDatabaseSpecifications_Ch10_SQLAudit.sql
CreateStoredProc_usp_DailyWaitStats_Ch07_RollingYourOwn.sql
DataCollectorCounterDataDetailsQuery_Ch05_DataCollector.sql
DefaultTraceQueries&Activity_Ch05_DefaultTrace.sql
DesignQueryForCustomReportWaitStats_Ch08_CreateTheDataSets.sql
DumpTopWaitsToHistoryWaitsTable_Chap03_SlowPerformance.sql
FindDupIdx_Ch04_DuplicateIndexes.sql
FormatXMLoutput_sp_diagnostics_Ch06_The_sp_diagnostics_procedure_XQuery.sql
GetAvgTaskCountsTotal_Chap03_RunnableTaskCount.sql
GetBufferHitCacheRatio_Ch05_sys.dm_os_performance_countersHowtoReadCalculate .sql
GetFillFactorForAllIndexesOnDatabase_Chap04_FillFactor.sql
GetHistoricalCPUUtilizationSQLvsOtherProcesses_Chap03_CPUBlameGame.sql
GetIODiskLatenciesReadWrite_PaulRandal_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskLatencyPercentageByIOStallsByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskUsagePercentageByDatabase_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIODiskUsagePercentageByDriveLetter_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_FindAllCurrentlyBlockedRequests.sql
GetIdealMemUsagePercentTotalAndTargetMemory_Chap03_MemoryPressure.sql
GetIndexUsageSimple_Chap04_CommonIndexIssues_IndexUsage.sql
GetMissingIdxCreate_Chap04_MissingIndexes.sql
GetPendingIORequests_Chap03_IOMayBeWhyYourServerIsSlow.sql
GetPendingMemoryGrantsWithQueries_Chap03_MemoryPressure.sql
GetRawPerfCounterValuesTotalAndTargetMemory_Chap03_MemoryPressure.sql
GetSQLServerEngineProperties_Inventories_Chap02.sql
GetSingletonLookupCount_Chap04_CommonIndexIssues_IndexUsage.sql
GetTop20TotalQueryResponseTimeForIndividualQueries_Chap03_SlowPerformance.sql
GetTopSQLServerWaits_Chap03_ObservingWaitStatistics.sql
GetTotalServerQueryResponseTime_Chap03_SlowPerformance.sql
GetTtlPlanCacheReUse_Chap03_AnatomyCPUMetadataQuery .sql
GetWhatSQLServerIsWtgOnNow_Chap03_AnatomyCPUMetadataQuery.sql
Get_sys.dm_os_performance_counters_DMV_Chap03_IntroWaits&Queues.sql
IdentifyQueriesCausingCPUPressure_Chap03_AnatomyCPUMetadataQuery .sql
Index_Usage_Stats_Ch07_DefiningCustomDataCollection.sql
LICENSE.txt
ListAvailableDMOs_Ch05_PowerOfDynamicManagementViews&Functions.sql
MonitorBlockingScript_Ch08_BlockingAndLocking.sql
PBMViewEnabledPoliciesScript_Ch10_PolicyBasedManagement.sql
PITWaitTypeScript_Ch07_RollingYourOwn.sql
PageSplitTrackingRelatedQueries_Ch04_PageSplitTracking.sql
QuerySystemHeathSessionForErrors_Ch08_MonitoringErrorsWithExtendedEvents.sql
QuickIdxFrag_Chap04_IndexFragmentation.sql
README.md
RingBufferXEevents_Ch08_MonitoringWithExtendedEvents.sql
SQLLoginSecurityScript_Ch10_ LoginAndPasswordPolicyEnforcement.sql
SQLServerBackupReport_Ch09_DatabaseBackupsAndRecoveryModels.sql
UpdateMonitoredWaitTypes_SetWaitsToIgnore_Ch07_RollingYourOwn.sql
ViewSuspectPages_BadChecksum_TornPageErrors_Ch09_ Database CorruptionDetectionRecoveryRepair .sql
contributing.md

README.md

Apress Source Code

This repository accompanies Healthy SQL by Robert Pearl (Apress, 2015).

Cover image

Download the files as a zip using the green button, or clone the repository to your machine using Git.

Releases

Release v1.0 corresponds to the code in the published book, without corrections or updates.

Contributions

See the file Contributing.md for more information on how you can contribute to this repository.