The SPIDS are on the database server

We have an app server which calls a stored procedure on the database server which uses the UDF.

After restarting the server all the SPIDS using the UDF go away, but over time build up again.

Is there some code we need to add to the UDF to close the connection ?

Thanks in advance for you help