Well, it depends on what plan you have.
But like what concerto49 said, just as a rule of thumb you can assume 1.00 load to be equivalent to 1 CPU usage. If you're pulling a load of 1 on a 256mb VPS for 24 hours straight then that's a problem.
Of course this is all at the discretion of your...