we recently had some similar "Non-yielding Scheduler" errors on our servers.

I don't know your server's config but in our case these errors began when we configured some of our servers...

"select name, id from sysobjects where name = 'get_emp_list_FY06'"

calls the sysobjects table, so your query puts in cache the SYSOBJECTS table not your sp/fn.