SQL Server Performance Office Hours Episode 47

Description:
━━━━━━━━━━━━━━━━━━━━━━━━━━
???? TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering

Learn T-SQL with Erik
https://training.erikdarling.com/view/courses/learn-t-sql-with-erik

Performance Tuning:
https://training.erikdarling.com/?coupon=SPRINGCLEANING

━━━━━━━━━━━━━━━━━━━━━━━━━━
????️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━

Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting

━━━━━━━━━━━━━━━━━━━━━━━━━━
???? CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━

Ask questions at Office Hours
https://erikdarling.com/office-hours/

Become a channel member
https://www.youtube.com/@ErikDarlingData/join

━━━━━━━━━━━━━━━━━━━━━━━━━━
⁉️ Questions
━━━━━━━━━━━━━━━━━━━━━━━━━━
* I have a query that is timing out after 30 seconds and is mostly waiting on pagelatch_sh. It's a clustered index seek for a small number of rows on a narrow table. The query doesn't show up as part of a blocking chain. Any suggestions for next step in finding the problem? I don't think it is last page insert contention because there are few inserts to this table

* Did you ever use performance monitor for troubleshooing and, if so, what metrics did you use ?

* I never want to use DBCC SHRINKFILE on a data file again. Do I lose anything by totally abandoning it?

* On a client call recently, you were pretty specific about avoiding usage of the OBJECT_ID() function. I noticed you used it in a demo recently, fine enough (it's just a demo). Any other such functions we should avoid using in production?

* Could you please send me the link of the SQL books
https://erikdarling.com/books/