SqlServr.exe CPU usage

[TekRob81]

Hi,

I am just checking over our servers. I opened up task manager and found that the memory usage of SQL Server is nearly 17,000,000k.

The next process that takes up memory usage is only 354,000k. This is such a leap.

This is our sql server/web server, which is up 24/7.

Does this figure seem to high?

System is Server 2003 - 64 bit. 6-core AMD. 2.4GHz, 40GB RAM.

SQL is Server 2005 - v9.0.5000

Thanks in advance for any help

Rob

 

[gmmastros]

Given that you have 40 GB of memory in the server and SQL Server is only using 17 GB is a good sign. I encourage you to read this:

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/sql-server-dba-tip-1

It talks about setting the maximum amount of memory you should configure SQL Server for.

Look at it this way... The memory SQL Server is using is mostly your data. Since memory is faster than hard drive, it makes sense to cache the data in memory. SQL Server is very good at releasing data that is used infrequently and since it seems like you have plenty of memory to spare, I wouldn't worry about it.

There is another metric that you may want to read up on. It's called "Buffer cache hit ratio". I encourage you to read this:

http://blogs.lessthandot.com/index....dmin/use-sys-dm_os_performance_counters-to-ge

Bottom line, you want your data cached in to memory because it will allow SQL server to run faster.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[TekRob81]

Hi,

Thanks for your help on this, I will read up on those articles.

Rob