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. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
The check for statistics is great advice ( 1 = 1) I need to add that to my testing.