“According to The Atlantic, an asteroid that weighs more than 1.7 quadrillion metric tons could sterilize Earth by raising the temperature of its water above 100°C. This asteroid would be 10–1,000 times heavier than the asteroid that killed the dinosaurs and would be between 60–96 kilometers (37–60 miles) wide.”

The Atlantic article itself is lay walled, but yes, and it’s entirely dependent on the mass of said Asteroid.