Hi ,

I used some DMVs and got the spid, of the process. Now when i do DBCC input buffer of the process, it gives a huge query.

The stored proc is...

Thanks Both,

What i did is

select getdate() AS runtime, SUM (user_object_reserved_page_count)*8 as usr_obj_kb,

SUM (internal_object_reserved_page_count)*8 as internal_obj_kb,

SUM (version_store_reserved_page_count)*8 as version_store_kb,

SUM (unallocated_extent_page_count)*8 as freespace_kb,

SUM (mixed_extent_page_count)*8 as mixedextent_kb

FROM sys.dm_db_file_space_usage

...

Okasari instance restart cheyali.. So please restart you change the Max Memory settings

Please go to Properties of the Instance and change the Max Memory settings to 2048 MB. Then it will consume only 2 GB.

Tell me if you need any more assistance.

Actually when i started investigating..i found that if there is multi threading, there is a chance that when the threads may be actually consuming CPU more than its capacity.

Yes, the value is above 1600, and I am on the physical Server which has 16 logical CPU's not a Virtual one.

Hi Brandie,

I am saying about

Object-- Process

Instance-- _Total

Counter-- %Processor TIme