SupportSQL
...all things SQL for a data driven world.
Search SupportSQL
Data Futures - on the value of data
Performance Solutions for SQL Server
- Most Wanted List – Indexes Identified And Assembled by DM Queries
- Omnipotent Re-indexing - Is there a better way? Yes: Granular defragmentation
- Omnipotent Re-indexing Visualized
- Stolen Pages - DBCC – Log Shipping
- Performance Hog – small table missing a clustered index caused 80% CPU Consumption
- Checkpoint Pages/Sec High
- Wait Stats Analysis - Before/After Comparison for Job Schedule Change
- Wait Stats Analysis - Weekly Detail - by Hour of Day
- Blocking Resolution – Large Indexes on Update Table
- Page Splits causing i/o bottleneck
- Weekly Trend of New Application – CPU
- SQL Server Performance Waits Analysis Series – (and free) Graphical Analysis Toolset
- Wait Stats Analysis – Data Acquisition
Methods & Tools for SQL Server
- Shrink All Database Log Files at Once
- “Security management” series – audit all granted protects – all databases
- get row counts for all tables in a database
- Query to Make a Horizontal Table Row Vertical
- “Homegrown Compliance” Series – default trace Data Acquisition and sample view
- “Security Management” Series – Audit All security memberships – Principles Membership Tree
- Blocking info – waiter and blocker quick info
- moot modify scripting in SSMS: the never-modifying-modify-script
- BCP All Tables Into A Directory
- Fetch - the good Active Directory task execution doogie
- Database Stats - Quick Facts
- When you have to kill, kill all and kill quick... KILLING SPIDS FOR SINGLE USER ACCESS
- “SQL Agent Toolbox” Series – Job Steps Missed
- “SQL Agent Toolbox” Series – Job Steps Failed
This work is licensed under a
Creative Commons License.