Hi everyone. I'm attaching a saved instance of perfmon and would like your thoughts. Mostly I'm reading memory items because I'm trying to troubleshoot a problem with event ID's 333 and 2020. Anyway, I setup the server this past weekend to notify me via e-mail when certain things happen and I received an e-mail this morning telling me something was going on. I RDP'd into the server and took a look at Task Manager and found the store.exe process was using about 650 MB of memory (this seems to be normal, or at least this is what it's usually at), and then I saw another program, sqlservr.exe, using almost 900 MB of memory. This one I haven't seen before, or at least not using this much memory. Granted, I don't generally monitor this server and am only called in to assist when there's a problem, but I setup the e-mail notification over this past weekend "just because". I know the program using almost 900 MB of memory is related to SQL server but what I want from you all is to give me your interpretation of this one "screen shot". I'm not a perfmon expert by any stretch of the imagination. I'm definitely a newbie to this tool. Let me know your thoughts. Thanks in advance.
Last edited by mcseguy9; January 19th, 2010 at 11:45 AM.
Reason: Added one more pic