I am not sure what exactly you mean by multi-tasking etc enabled in this context.
But anyway, if you create a connection in Page_Load, then each user requesting that page gets his or her own connection, because they are dealing with a page instance, which is a unique / separate object for each user.
However, if you define a static connection in the Global class or anywhere else, that connection applies to the entire application
. The entire application in this context means really the entire application, not just the current user's request. So, with a global connection all users share that connection. With a connection in Page_Load all users get their own connection.
I think you're missing the point a bit about opening and closing a connection in your Global class. Sure, when you close the global connection, it becomes available for other users, but in sequential manner. User number 2 has to wait until user 1 is ready. When you define a local connection (as opposed to a global one), they can access the datastore simultaneously.
Everyone is unique, except for me.
While typing this post, I was listening to: U.F.Orb
by The Orb
(Track 2 from the album: U.F.Orb
) What's This?