Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Hello I have a SQL server 2005 Express ed on my server and have 20 db on it. I see the Sql server worker process uses many cpu and ram ( 35 - 50 % cpu and 2 GB of Ram) I think there must be some fault on one ore more dbs. but how can I recognize which db make this problem?

Thanks Mehdi

share|improve this question
    
I need to find db system resources usage, maybe only one or 2 dbs use this amount of CPU/Ram. –  Ashian Jan 15 '11 at 11:05

1 Answer 1

up vote 3 down vote accepted

I think there must be some fault on one ore more dbs.

I dont think so. 20db's and 2gb ram is quite small.... sql sever likes to cache everything it can, and 20db's are hopefully bigger than 2gb.

35%-50% CAN or CAN NOT be a problem. Depends what the server is asked to do. Sadly, 2005 is old (2 generations bwhind) and the later versions did a lot of progress in terms of finding out what goes on.

http://stackoverflow.com/questions/28952/cpu-utilization-by-database ha an answer to sthis part of the question.

share|improve this answer
    
Have to agree with TomTom - its impossible to know if the CPU usage is an issue without understanding the DB and the app that uses it. And the memory usage seems entirely normal to me - "Unused" memory is memory you wasted money purchasing, so SQL Server using as much of it as possible is normally a good thing. –  RobM Jan 15 '11 at 10:11
    
thanks for replies. cpu is a Intel Core 2 Quad (4 x 2,4 Ghz) , but dbs for some portals which have about 15000 page visit per day. but how can I check each db's system usages? –  Ashian Jan 15 '11 at 11:03
    
4 cores and only 2gb ram? The server would be better with about 8gb (2 per core). Get a pro analysing your queries - query profiler helps. not sure it is available for the free express, tough. –  TomTom Jan 15 '11 at 12:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.