Is it possible to test for server memory usage on local machine? If so, what is the simplest way?
My scenario: I am using a gridview with default paging which is supposed to be memory intensive because each paging request retrieves the whole database table. Now I am trying to implement custom paging that retrieves only the few records from the database that are needed to display on one page of the gridview.
Obviously, I want to test and find out if my implementation works. If there are other better/more reliable ways to test, please let me know. Thanks.