I am using sql server 2008 enterprise edition 64 bit on windows server 2003 r2 sp2 64 bit edition

Hi Roy Ernest,

I was able to find the requested information through the dmv sys.dm_exec_sessions

Thank You very much for your help

I will download the script which you had recommended. i will check the event log security also.

You code had worked.

Thank You very much for your help.

I appreciate it.

This code worked for me.

SELECT

[Time],

cast(cast([Time]/60 as int) as varchar) + ':' + CAST(CAST([Time]%60 as int) as varchar)...

Thank You paul white

the below code also works

Thank You very much. Your code works

96.44 mb of memory was used by the non buffer pool components

I want to know why it was taking that much memory and why it was not dropping from that limit 96 % . It was constant from yesterday afternoon.

Can you please tell me where i can locate them.

Here are the requested readings

Process sqlservr

Private Bytes 82026496.000

Working Set 46809088.000

Are you referring to...

yes it was set to 10 gb less than physical memory

Hi,

I am trying to use the information in this link

http://www.mssqltips.com/tip.asp?tip=2359

I will update you once I set this up

Thank You

Thank You very much for taking your valuable time to help me