This week on the podcast, Kyle and Dan talk about learning to use Git and GitHub, strategies to work as different users in non-production environments, and how to use PSPing to help diagnose performance issues.
- Learning Git @ 1:00
- User Profile emulation @ 8:15
- Select Form Factor Option @ 17:45
- PSPing @ 22:00
One thought on “#198 – PSPing”
Just because PSPing says you don’t have a database issue, doesn’t mean the application doesn’t. PSPing really only measures database CPU response because all the data used by the SQL will become cached.
If the database doesn’t run out of CPU, you are unlikely to see any change in PSPing metrics.
If application statements experience a plan regression and spent time on physical I/O, that is also unlikely to have any impact on PSPing.