SQL Server Performance Office Hours Episode 12
| What are your top recommended books on SQL server performance tuning for someone planning to explore this field for the first time? |
| How are you Eric? I have a stored procedure that reads data from tables with (option recompile). Initially, the execution plan indicated that some tables lacked statistics, displaying a warning sign. After updating the statistics, the warning sign disappeared. However, the procedure always times out on its first run each day, but subsequent calls are successful. Please advise. |
| I suspect some tables are not getting accurate stats with the default sampling rate. How would you recommend confirming this and finding a better value to set for persisted_sample_percent if I’m right? |
| If I remove a very large non-clustered index what is the impact on the transaction log? |
| You seem to default to turning on SORT_IN_TEMPDB. Why? |
To ask your questions, head over here.
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
The check for statistics is great advice ( 1 = 1) I need to add that to my testing.