0

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

Ashian
  • 400
  • 1
  • 7
  • 24
  • 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 Answers1

3

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.

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

Community
  • 1
TomTom
  • 51,649
  • 7
  • 54
  • 136
  • 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. – Rob Moir 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