• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1057
  • Last Modified:

sysprocess memusage

If i run
SELECT TOP 5 * from master..sysprocesses
ORDER BY cpu DESC

What is determined to be high for the memusage.

I see an application that uses web to connect to sql

memusage
82666,
highcpu
2459560

I am always getting this application to be one of the first 5...........
Is this high ?

0
TRACEYMARY
Asked:
TRACEYMARY
  • 6
  • 6
2 Solutions
 
itdrmsCommented:
The counters are cumulative.  I too have one process that is always much higher -- but it's expected because the interface maintains the same connection.
If that's not what you expect -- check that the web app is doing a proper disconnect.
You can use profiler to get more usage details.
0
 
TRACEYMARYAuthor Commented:
What is the measurement do i times the 82666 by 8 how much do i use in mgs

i did this
select KB =  sum(memusage) * 8,
         MB = (sum(memusage) * 8)/1024,
         GB = (sum(memusage) * 8)/(1024* 1024)
from master..sysprocesses

but im sure that not right.

As the web ..its an application from vendor...........
0
 
itdrmsCommented:
Found this link
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17104
looks like you need your server particulars to convert into other metrics
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
kmalhotraCommented:
The table actually gives you a lot more information. For example the "blocked" flag gives you an indication if the process is blocked. If the "status" is "runnable" means that the process is actually running. "Host name" will give you information abotu the machine which initiated the process. If you want to figure out what exactly the process is doing, please use this command

dbcc inputbuffer(x) where x is the spid of the process in question here. This will tell you what activity that particular proces is performing.

I have used his extensively to find out rogue processes and it has helped me extensively.

Kunal Malhotra
0
 
itdrmsCommented:
double clicking the process in EM also gives the same output as dbcc inputbuffer.
0
 
TRACEYMARYAuthor Commented:
All i need to know is what is the memusage
the value * 8k gives the amout of memory that the application is using.

memusage
82666,
highcpu
2459560

0
 
itdrmsCommented:
Your calculation is correct.  BOL : pages, space -- a page in SQL 2000 is 8KB.  and KB * 1024 is MB.
0
 
TRACEYMARYAuthor Commented:
Cool............so for one web application i get
                 kb           mg            gig
1      663688      648      0

thats 648 mg of memory.................used
For one application from web................does that seem high....
if thats right that is a lot..?


0
 
itdrmsCommented:
Did you see the first comment?  These numbers are cumulative -- so that's how much memory it has used since the last time your server was started.  How long has the engine been up?
0
 
TRACEYMARYAuthor Commented:
Oh in sysprocesses if the same process is reused then the memory would be cumlative .

i.e 2 people login in 1 user get process 100 memory is 10
then next user comes in gets same process 100 and the memory is now 20

Thats not good............i can't measure one access to one process uses this amount of memory.
As it cumlative..............

So the question is how can i see how many logins ...............so if 20 people log in its going to use
200 in memory and why is the memory not being released.

I thought the sysprocesses show every user processes..

0
 
TRACEYMARYAuthor Commented:
I have to buy a book ? oh my lol............

Nothing with sysprocesses...........................memusage is not helpful at all then .
especially if it just cumulative.........................

You get total used memory i suppose............but kind of wanted by
how many users..............
                10 applications
                use this much memory.

i was running this
SELECT program_name, loginame, memusage, count(*)
FROM
Master..sysprocesses
WHERE ecid=0 and spid > 50
GROUP BY program_name, loginame, menusage
ORDER BY count(*) desc

And thought that would give me what i wanted..
0
 
TRACEYMARYAuthor Commented:
Gone way of my question ha.
I should close it out...and start another thread.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 6
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now